Bug MySQL Error

[Mick]

I keep getting 1000's of these type of errors.

And at the moment I am getting members complaining about delays in posting (could be related?)

EDIT, it is related, as soon as I disable the product posting is instant again, and when enabled it can take around 30 seconds for a post to post to the forums, and then you also get a leave the page popup???


#####################################
Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO theforumprefix__credits_transaction (eventid, actionid, userid, timestamp, amount, status, referenceid, forumid, ownerid, multiplier, currencyid, negate, message) VALUES (11, 'post', 14320, 1418200431, 0.5003, 1, 2481484, 437, 6477, 3, 1, 0, '');

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, December 10th 2014 @ 08:33:51 AM
Error Date : Wednesday, December 10th 2014 @ 08:34:53 AM
Script : DigitalWorldz Technology Forum - Satellite, Cable TV, IPTV, Console Experts
Referrer : https://www.digitalworldz.co.uk/
IP Address : 86.18.74.157
Username : joe516
Classname : vB_Database_MySQLi
MySQL Version :
#####################################

Thank you.

Mick

 

[Fillip H.]

Please see this MySQL manual entry on the "MySQL Server has Gone Away" error: MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away

 

[Mick]

Ok I get that,

But when this modification is on these errors start.

When it is off there is no errors.

And also the posting LAGGING?

Why is that happening?

 

[Fillip H.]

But when this modification is on these errors start.

When it is off there is no errors.

That's because your database server is not configured correctly to handle the additional demand placed upon it by vBCredits. The manual entry has a few steps you can try in order to alleviate the issue

And also the posting LAGGING?

Why is that happening?

Most likely due to the same server configuration issue.

 

[Mick]

The manual entry has a few steps you can try in order to alleviate the issue

Sorry I do not want to sound like an idiot but where is this ?

Thank you.

Mick

 

[Fillip H.]

Increase the wait_timeout and interactive_timeout settings in my.cnf