SQL error system - need to find a fix

Léo Fabre Posted in Technical Support 8 years ago

Hey,

I've having some errors, after 4/5h from my ossn website lauching.

Please take a look at :

OssnDatabaseException: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SELECT DISTINCT o.guid FROM ossn_object as o LEFT JOIN ossn_entities as e0 ON e0.owner_guid=o.guid LEFT JOIN ossn_entities_metadata as emd0 ON e0.guid=emd0.guid LEFT JOIN ossn_entities as e1 ON e1.owner_guid=o.guid LEFT JOIN ossn_entities_metadata as emd1 ON e1.guid=emd1.guid WHERE(o.subtype='wall' AND o.type='user' AND (e0.type='object' AND e0.subtype='access' AND (1=1) AND e1.type='object' AND e1.subtype='poster_guid' AND (emd0.value=2 OR emd0.value=3))) ORDER by o.guid DESC LIMIT 0, 10; in /customers/e/6/0/pumpshare.com/httpd.www/classes/OssnDatabase.php:77 Stack trace: #0 /customers/e/6/0/pumpshare.com/httpd.www/classes/OssnDatabase.php(175): OssnDatabase->execute() #1 /customers/e/6/0/pumpshare.com/httpd.www/classes/OssnObject.php(430): OssnDatabase->select(Array, true) #2 /customers/e/6/0/pumpshare.com/httpd.www/components/OssnWall/classes/OssnWall.php(367): OssnObject->searchObject(Array) #3 /customers/e/6/0/pumpshare.com/httpd.www/components/OssnWall/plugins/default/wall/siteactivity.php(19): OssnWall->getAllPosts(Array) #4 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.views.php(27): include('/customers/e/6/...') #5 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.views.php(50): ossn_include('/customers/e/6/...', Array) #6 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.plugins.php(75): ossn_view('/customers/e/6/...', Array) #7 /customers/e/6/0/pumpshare.com/httpd.www/components/OssnWall/plugins/default/wall/pages/wall.php(27): ossn_plugin_view('wall/siteactivi...') #8 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.views.php(27): include('/customers/e/6/...') #9 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.views.php(50): ossn_include('/customers/e/6/...', Array) #10 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.plugins.php(75): ossn_view('/customers/e/6/...', Array) #11 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.initialize.php(119): ossn_plugin_view('wall/pages/wall') #12 /customers/e/6/0/pumpshare.com/httpd.www/libraries/ossn.lib.page.php(67): ossn_user_pagehandler(Array, 'home') #13 /customers/e/6/0/pumpshare.com/httpd.www/index.php(21): ossn_load_page('home', Array) #14 {main}

anyone got issues?

thanks.

Replies
French Léo Fabre Replied 8 years ago

I'm not using VPS from them. I got the professional "pack", including 100go storage, 1go RAM, 2x CPU etc.

I've asked them on support about the query limitations, because they didn't notified it anywhere, so i'm waiting for one of their technician to mail me.

Indonesian Arsalan Shah Replied 8 years ago

Are you using VPS from them? The packages they listed seems they offering VPS, if it is VPS there shouldn't be problem with SQL queries.

French Léo Fabre Replied 8 years ago

The name of the current hosting provider is one.com.

Indonesian Arsalan Shah Replied 8 years ago

Please let us know the name of your hosting provider, we shall provide you alternative provider accordingly.

French Léo Fabre Replied 8 years ago

Thanks for quick reply.

So i've just bought one year on that hosting provider, that's so annoying.

Nevermind, i'll go on another one, have you any european hoster working with OSSN w/o limited query size to link me please.

Thanks you very much, appreciated.

Indonesian Arsalan Shah Replied 8 years ago

Hello Your hosting provider have limited query size, you have to choose different hosting provider or use the VPS.