Tweet
I wasn't getting any database errors then we turned PHP-FM off and the errors started pouring in. However, we had to turn PHP-FM off to address a different issue and I never had it on at my prior server.
I realize you always say this is a server problem, but I am on a new server at Liquid Web with now 8Gb (versus 2Gb before) and 8 core (versus 2 core before) and still stacks of database errors are coming in.
There may be something wrong with my database? that perhaps has to do with that it is upgraded from vb3. It doesn't make sense that a forum with as little traffic as mine (no more than a couple hundred logged on at the same time, and usually more like a hundred) would have all these problems on a 8 core VPS.
(errors below are truncated, too long to post here)
Database error in vBulletin 5.5.5:
Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_64199_lvl1data' AND event = 'nodeChg_64199') OR
(cacheid = 'node_64200_lvl1data' AND event = 'nodeChg_64200') OR
(cacheid = 'node_64201_lvl1data' AND event = 'nodeChg_64201') OR
(cacheid = 'node_64202_lvl1data' AND event = 'nodeChg_64202') OR
(cacheid = 'node_64203_lvl1data' AND event = 'nodeChg_64203') OR
(cacheid = 'node_64204_lvl1data' AND event = 'nodeChg_64204') OR
(cacheid = 'node_64205_lvl1data' AND event = 'nodeChg_64205') OR
Database error in vBulletin 5.5.5:
Invalid SQL:
/** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
VALUES
('node_132_lvl1data', 1573486984, 1573400584, 0, '1', 'a:57:{s:6:"nodeid";s:3:"132";s:7:"routeid";s:2:"91";s:13:"contenttypeid";s:2:"20";s:11:"p ublishdate";s:10:"1237530543";s:13:"unpublishdate";s:1:"0";s:6:"userid";s:1:"1";s:7:"group id";N;s:10:"authorname";s:5:"XXXXX";s:11:"description";N;s:5:"title";s:84:"XXXXXXXX";s:9 :" htmltitle";s:84:"MC___ suspension
Database error in vBulletin 5.5.5:
Invalid SQL:
SELECT * FROM cache
WHERE `cacheid` IN ('node_1_lvl1data');
MySQL Error : MySQL server has gone away
Database error in vBulletin 5.5.5:
Invalid SQL:
SELECT * FROM cache
WHERE `cacheid` IN ('vB_UserPerms1');
MySQL Error :
Database error in vBulletin 5.5.5:
Invalid SQL:
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (25551);
MySQL Error : MySQL server has gone away
---
also in my vb4 forum
Database error in vBulletin :
mysqli_real_connect(): (HY000/2002): Connection refused
/home/XXX/public_html/XXXX.com/forums/includes/class_core.php on line 1351
I realize you always say this is a server problem, but I am on a new server at Liquid Web with now 8Gb (versus 2Gb before) and 8 core (versus 2 core before) and still stacks of database errors are coming in.
There may be something wrong with my database? that perhaps has to do with that it is upgraded from vb3. It doesn't make sense that a forum with as little traffic as mine (no more than a couple hundred logged on at the same time, and usually more like a hundred) would have all these problems on a 8 core VPS.
(errors below are truncated, too long to post here)
Database error in vBulletin 5.5.5:
Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_64199_lvl1data' AND event = 'nodeChg_64199') OR
(cacheid = 'node_64200_lvl1data' AND event = 'nodeChg_64200') OR
(cacheid = 'node_64201_lvl1data' AND event = 'nodeChg_64201') OR
(cacheid = 'node_64202_lvl1data' AND event = 'nodeChg_64202') OR
(cacheid = 'node_64203_lvl1data' AND event = 'nodeChg_64203') OR
(cacheid = 'node_64204_lvl1data' AND event = 'nodeChg_64204') OR
(cacheid = 'node_64205_lvl1data' AND event = 'nodeChg_64205') OR
Database error in vBulletin 5.5.5:
Invalid SQL:
/** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
VALUES
('node_132_lvl1data', 1573486984, 1573400584, 0, '1', 'a:57:{s:6:"nodeid";s:3:"132";s:7:"routeid";s:2:"91";s:13:"contenttypeid";s:2:"20";s:11:"p ublishdate";s:10:"1237530543";s:13:"unpublishdate";s:1:"0";s:6:"userid";s:1:"1";s:7:"group id";N;s:10:"authorname";s:5:"XXXXX";s:11:"description";N;s:5:"title";s:84:"XXXXXXXX";s:9 :" htmltitle";s:84:"MC___ suspension
Database error in vBulletin 5.5.5:
Invalid SQL:
SELECT * FROM cache
WHERE `cacheid` IN ('node_1_lvl1data');
MySQL Error : MySQL server has gone away
Database error in vBulletin 5.5.5:
Invalid SQL:
SELECT * FROM cache
WHERE `cacheid` IN ('vB_UserPerms1');
MySQL Error :
Database error in vBulletin 5.5.5:
Invalid SQL:
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (25551);
MySQL Error : MySQL server has gone away
---
also in my vb4 forum
Database error in vBulletin :
mysqli_real_connect(): (HY000/2002): Connection refused
/home/XXX/public_html/XXXX.com/forums/includes/class_core.php on line 1351
Comment