Database error in

I'm frequently getting the error mentionned in the topic subject. I'm getting a confirmation via email and the file sizes are pretty impressive on these messages..

Oddly enough as well, these errors are always coming in in blocks of 3's .. So, everytime this happens .. i get those 3 errors.. file sizes vary .. but they come in this particuliar order.

Here are the error messages and the filesize .. can anyone point me in the right direction on how to correct these please ?

Error #1 : File Size 73 megs

Database error in

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/mysite/public_html/inc/classes/BxDolEmailTemplates.php' at line 31.
Called 'getOne' function with erroneous argument #0.

Error #2 : File Size 17 Megs

Database error in

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/mysite/public_html/inc/classes/BxDolEmailTemplates.php' at line 31.
Called 'getOne' function with erroneous argument #0.

Last but not least .. the 3rd error with a Filesize of 4 Megs :

Database error in

Query:

SELECT `OwnerID` AS `owner_id`, `allowView` AS `group_id` FROM `bx_blogs_posts` WHERE `PostID`='2' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/mysite/public_html/inc/classes/BxDolPrivacyQuery.php' at line 61.
Called 'fromMemory' function with erroneous argument #2.

Now the 1st two are exactly the SAME error with a different file size. The 3rd is different.. but they all share in common the following message :

Mysql error: MySQL server has gone away

Am I correct in assuming that MySQL is timing out ???

Thanks for the help.

BeN

I have this same issue and it overloads my server and nobody has answered it....

I have got the same mails in the beginning, but after some days not more.

are you guys on a shared environment. this could be disk space is used up. what its saying is that the database has gone away, meaning its unreachable. have you submitted a ticket to your hosting service provider on this?

I'm experiencing the same error...email contains large sizes contents of duplicate queries and happens one or twice a day.

Database error in

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/ethiomys/public_html/inc/classes/BxDolEmailTemplates.php' at line 31.
Called 'getOne' function with erroneous argument #0.

I just had my shared host migrated to another server, so not sure what triggered it. My host (HFW) is advising me to contact Boonex to check their scripts. So, not sure how to resolve this one.

Hello everybody!

As u may see form this link http://dev.mysql.com/doc/refman/5.0/en/gone-away.html this error can't be dependent from BoonEx scripts :-) except case when ur MySQL can't allow so many queries from Dolphin - so u may try to delete some of modules for experiment.

Regard

Can you please explain this better? I am having trouble understanding your English. I am also getting this error once in a while and would like to resolve it.

@BenGalf this seems to address your problem:

You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end. More information on setting the packet size is given in Section B.5.2.10, “Packet too large”.

Notice how it says the max allowed packet is 1mb, and your sending packets of 73m, 17m, and 4m, seems to be the issue.  I would try changing the settings as stated and try again.  Btw what in the world are you putting into the email templates that is 73megs?

LeonidS provided a link that explains most of the causes.


As for the rest of what he said i reworded below to perhaps explain it better.


Except for cases where your MySQL server cannot handle the number of queries that dolphin is executing or is not configured to handle a large number of queries. Removing some modules that are not needed will reduce the number of queries which may resolve the problem.

Um, I know I'm the resident dummy here but I think this error can also be caused by your email settings. I think if your email cannot accept that file size it will throw the error?

i´ve got nearly the same problem - but I don´t see any answer here?

Did anyone get and tried an effecitve solution?