I upgraded from vB4 to 5 a couple of months ago and have had endless problems ever since and seriously regret upgrading. vB5 has pretty much killed my forums. I've been a vBulletin customer for many years and have never had problems like this. I'm ready to give up on the software if you're unable to or unwilling to help.
My once busy forums (over 30,000 members) now barely get any posts. Members and moderators have reported not being able to post at all, or having to try several times before a post will actually post, and sometime can't even access the forums as they're so slow. We had no problems at all with vB4. My host has increased the memory on my server several times. The database crashes on a regular basis, leaving me being bombarded with thousands of sql error message emails.
The most we've gone without any error messages or problems is about 2 weeks. Very often, every few days I'm having to repair the cache and cacheevent databases to get rid of database error messages. It's got beyond a joke now and I'm at my wits end with it all. I did go through the ticket system originally but got precious little useful help, other that being repeatedly told to repair the database tables, and that it was an issue with my server rather than vBulletin. However after reading through posts on here it appears that database and other errors are very common in vB5.
Here are some of the database error messages that I get--
~~~~~~~~~~~~~~~~~~~~~~~~
Database error in vBulletin 5.1.0:
Invalid SQL:
SELECT * FROM cache
WHERE `cacheid` IN ('preloadTemplates_58');
MySQL Error : Can't find record in 'cache'
Error Number : 1032
Request Date : Thursday, April 24th 2014 @ 08:14:32 PM
Error Date : Thursday, April 24th 2014 @ 08:14:32 PM
Script : ******
Referrer :
IP Address : 36.250.176.40
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
~~~~~~~~~~~~~~~~
Invalid SQL:
/** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
VALUES
('getSearchResults_27a79249a71bcab174dc8644463fc9d1', 1398384957, 1398384897, 0, '1', 'a:4:{i:10323;a:1:{s:6:\"nodeid\";s:5:\"10323\";}i:127083;a:1:{s:6:\"nodeid\";s:6:\"127083 \";}i:127125;a:1:{s:6:\"nodeid\";s:6:\"127125\";}i:127136;a:1:{s:6:\"nodeid\";s:6:\"127 136 \";}}')
ON DUPLICATE KEY UPDATE expires = VALUES(expires), created = VALUES(created),
locktime = VALUES(locktime), serialized = VALUES(serialized),data = VALUES(data);
MySQL Error : Incorrect key file for table './*******_forums/cache.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, April 24th 2014 @ 08:14:57 PM
Error Date : Thursday, April 24th 2014 @ 08:14:58 PM
Script : **************
Referrer :
IP Address : 198.143.130.90
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Database error in vBulletin 5.1.0:
[Showing truncated query, original length: 12650]
[First 500 chars]
Invalid SQL:
/** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
VALUES
('vB_UserPerms42523', 1398478908, 1398392508, 0, '1', 'a:9:{s:12:\"groupintopic\";a:0:{}s:10:\"usergroups\";a:1:{i:0;s:1:\"2\";}s:14:\"moderator perms\";a:0:{}s:7:\"primary\";s:1:\"2\";s:9:\"secondary\";a:0:{}s:10:\"infraction\";a:0:{} s:13:\"channelAccess\";a:7:{s:8:\"selfonly\";a:0:{}s:7:\"canview\";a:47:{i:1;i:1;i:2;i:2;i :3;i:3;i:6;i:6;i:308907;i:308907;i:13;i:13;i:14;i:14;i:16;i:16;
[Last 500 chars]
tertotalcount\";s:2:\"11\";s:15:\"starterurlident\";s:18:\"newbie-i-need-help\";s:14:\"deleteusername\";N;s:14:\"lastauthorname\";N;s:11:\"edit_reason\";N;s:11:\"e dit_userid\";N;s:13:\"edit_username\";N;s:13:\"edit_dateline\";N;s:10:\"hashistory\";N;s:1 8:\"starternodeoptions\";s:3:\"138\";s:18:\"channelnodeoptions\";s:3:\"138\";}')
ON DUPLICATE KEY UPDATE expires = VALUES(expires), created = VALUES(created),
locktime = VALUES(locktime), serialized = VALUES(serialized),data = VALUES(data);
MySQL Error : Incorrect key file for table './******_forums/cache.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, April 24th 2014 @ 10:21:48 PM
Error Date : Thursday, April 24th 2014 @ 10:21:50 PM
Script : **************
Referrer :
IP Address : 69.30.238.18
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
~~~~~~~~~~~~~~~~~~~~~
My once busy forums (over 30,000 members) now barely get any posts. Members and moderators have reported not being able to post at all, or having to try several times before a post will actually post, and sometime can't even access the forums as they're so slow. We had no problems at all with vB4. My host has increased the memory on my server several times. The database crashes on a regular basis, leaving me being bombarded with thousands of sql error message emails.
The most we've gone without any error messages or problems is about 2 weeks. Very often, every few days I'm having to repair the cache and cacheevent databases to get rid of database error messages. It's got beyond a joke now and I'm at my wits end with it all. I did go through the ticket system originally but got precious little useful help, other that being repeatedly told to repair the database tables, and that it was an issue with my server rather than vBulletin. However after reading through posts on here it appears that database and other errors are very common in vB5.
Here are some of the database error messages that I get--
~~~~~~~~~~~~~~~~~~~~~~~~
Database error in vBulletin 5.1.0:
Invalid SQL:
SELECT * FROM cache
WHERE `cacheid` IN ('preloadTemplates_58');
MySQL Error : Can't find record in 'cache'
Error Number : 1032
Request Date : Thursday, April 24th 2014 @ 08:14:32 PM
Error Date : Thursday, April 24th 2014 @ 08:14:32 PM
Script : ******
Referrer :
IP Address : 36.250.176.40
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
~~~~~~~~~~~~~~~~
Invalid SQL:
/** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
VALUES
('getSearchResults_27a79249a71bcab174dc8644463fc9d1', 1398384957, 1398384897, 0, '1', 'a:4:{i:10323;a:1:{s:6:\"nodeid\";s:5:\"10323\";}i:127083;a:1:{s:6:\"nodeid\";s:6:\"127083 \";}i:127125;a:1:{s:6:\"nodeid\";s:6:\"127125\";}i:127136;a:1:{s:6:\"nodeid\";s:6:\"127 136 \";}}')
ON DUPLICATE KEY UPDATE expires = VALUES(expires), created = VALUES(created),
locktime = VALUES(locktime), serialized = VALUES(serialized),data = VALUES(data);
MySQL Error : Incorrect key file for table './*******_forums/cache.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, April 24th 2014 @ 08:14:57 PM
Error Date : Thursday, April 24th 2014 @ 08:14:58 PM
Script : **************
Referrer :
IP Address : 198.143.130.90
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Database error in vBulletin 5.1.0:
[Showing truncated query, original length: 12650]
[First 500 chars]
Invalid SQL:
/** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
VALUES
('vB_UserPerms42523', 1398478908, 1398392508, 0, '1', 'a:9:{s:12:\"groupintopic\";a:0:{}s:10:\"usergroups\";a:1:{i:0;s:1:\"2\";}s:14:\"moderator perms\";a:0:{}s:7:\"primary\";s:1:\"2\";s:9:\"secondary\";a:0:{}s:10:\"infraction\";a:0:{} s:13:\"channelAccess\";a:7:{s:8:\"selfonly\";a:0:{}s:7:\"canview\";a:47:{i:1;i:1;i:2;i:2;i :3;i:3;i:6;i:6;i:308907;i:308907;i:13;i:13;i:14;i:14;i:16;i:16;
[Last 500 chars]
tertotalcount\";s:2:\"11\";s:15:\"starterurlident\";s:18:\"newbie-i-need-help\";s:14:\"deleteusername\";N;s:14:\"lastauthorname\";N;s:11:\"edit_reason\";N;s:11:\"e dit_userid\";N;s:13:\"edit_username\";N;s:13:\"edit_dateline\";N;s:10:\"hashistory\";N;s:1 8:\"starternodeoptions\";s:3:\"138\";s:18:\"channelnodeoptions\";s:3:\"138\";}')
ON DUPLICATE KEY UPDATE expires = VALUES(expires), created = VALUES(created),
locktime = VALUES(locktime), serialized = VALUES(serialized),data = VALUES(data);
MySQL Error : Incorrect key file for table './******_forums/cache.MYI'; try to repair it
Error Number : 126
Request Date : Thursday, April 24th 2014 @ 10:21:48 PM
Error Date : Thursday, April 24th 2014 @ 10:21:50 PM
Script : **************
Referrer :
IP Address : 69.30.238.18
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
~~~~~~~~~~~~~~~~~~~~~
Comment