Hey friends..
Today accidentally my site powered by MyBB displayed me error as below..
Quote:MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1323664394' ORDER BY u.username ASC, s.time DESC
Please contact the MyBB Group for support.
I am using MyBB 1.6.4, i know that error is something related to sessions
But can you explain me in brief ? that how can i solve it ?
My forum URL is :
http://www.crunchplus.com
Other Info :::
- I can access admin panel.
- I asked my Hosting provider about SQL Server status.. they replied me that its working fine !!
Either it is not able to connect with your SQL database or something is missing in the database which I doubt, its surely your host issue. See the error it gives, SQL server has gone away, clearly states the problem, ask your host to check that error and that he'd recognize it.
hm.m... and tell me may i solve this problem by upgrading to latest MyBB 1.6.5 ?
^ No. "2006 - MySQL server has gone away" suggests that it is a host issue though they declined it !
@ranjani
as you told me that it's about SQL Server host problem..
then why its working ?
http://www.crunchplus.com/test/
I just installed new mybb successfully on above link...
and homepage including all area working well !!!
I have attached image of my server status..
I also called my hosting provider now, he told me that everything is fine !!
Please see this image..
[
attachment=25000]
^ is it the same database ?
nop...
but database name of
http://www.crunchplus.com/test is cr_mbb***23
and for original crunchplus.com it is cr_mybb**08
now let me swap it together to identify problem.,.. !!
yeah.. we found it !! i mean i detected that something went wrong in database but not on mysql server..
now crunchplus.com working with empty database of crunchplus.com/test !!
see there !!
you can try optimizing mybb_sessions table ; still I see it as a host problem ...
Hello guys !!
Problem Solved !
It's PHP memory limit problem behind all this things
My PHP memory limit is only 64 MB !!
How i solved it ?
- I have done backup of mysql database
- Then I Removed all plugins one by one
- and refreshed site each time after uninstalling each plugins !!
- and got site back after removing more then 7 plugins !!
- Thanks god !!
Thanks to mybb community for good support
See the site its live now !!
^ oh! BUT recently there should have been a couple of warnings while adding a new plugin
{I learnt a new cause for the issue..}