Tried to ban a selection of users and got error message at /admin/index.php?module=user-users (see attached scrnshot)...
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
REPLACE INTO mybb_datacache SET title='banned',cache='a:3269:{i:2;a:10: ........
Ideas ?
Does this happen everytime you try to ban that user? If so try to repair that table and see what happens (the mybb_datacache) by going into your admincp and then rebuilding that table under "Tools & Maintenance" and then "Rebuild & Recount".
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
REPLACE INTO mybb_datacache SET title='banned',cache='a:3269:{i:2;a:10: ........
Unfortunately, you have to contact your host. There is some problem with your MySQL server. Your host would be able to better assist you.
[update] Same 'host' for 2 different domain/forums, one not getting any error message.
Thanks much for the direction.
Contacted the 'host' and below are the (problem still occurring) question/replys...
HostMantis...
Hello,
We have not had any recent issues on that server and running a database repair on that database showed no issues.
Thank you,
HostMantis Support
[email protected]
akm...
> Sorry, account is 'akm.org' and database is 'akm'.
HostMantis...
Hello,
Which account is this issue on?
What is the database name that you are having this issue with?
Thank you,
HostMantis Support
[email protected]
akm...
> Tried to ban a selection of users at a MyBB /admin and got an error message at
> /admin/index.php?module=user-users (scrnshot attached)...
> MyBB has experienced an internal SQL error and cannot continue.
> SQL Error:
> 2006 - MySQL server has gone away
> Query:
> REPLACE INTO mybb_datacache SET
title='banned',
cache='a:3269:{i:2;a:10:
> ........
> The advice at the MyBB forum was to check with the host.
> Please advise.
> Thank you.
> Alan
(2013-11-10, 05:59 AM)Arbaz Wrote: [ -> ]Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
REPLACE INTO mybb_datacache SET title='banned',cache='a:3269:{i:2;a:10: ........
Unfortunately, you have to contact your host. There is some problem with your MySQL server. Your host would be able to better assist you.
How many people have you banned?
.
Thanks for the followup !
So far have banned 3650 users (spammers).
(2013-11-14, 05:31 AM)Dennis Tsang Wrote: [ -> ]How many people have you banned?
Perhaps the length of the query to update the banned cache was just too big for the server to handle (perhaps a limit is imposed for "security").
.
Thanks for the suggestion.
It sounds like a question for the 'host', yes ?
(2013-11-15, 02:56 AM)Dennis Tsang Wrote: [ -> ]Perhaps the length of the query to update the banned cache was just too big for the server to handle (perhaps a limit is imposed for "security").
You could try asking them if they have a query length limit.
Something easier to try might be to delete a bunch of your oldest spam users (you don't need them around anymore do you?) and see if banning works again.
Good idea/s. thanks !
Will try both... some banned users have not tried to re-login, so will work with those.
If it works, ie if deleting some fixes the problem, is the problem then at the host server/database, or with the limits of MyBB program ?
(2013-11-15, 05:42 PM)Dennis Tsang Wrote: [ -> ]You could try asking them if they have a query length limit.
Something easier to try might be to delete a bunch of your oldest spam users (you don't need them around anymore do you?) and see if banning works again.