I was receiving a load of these last night, so I ran a repair and optimise but, although it fixed the problematic thread (showthread.php?t=69893) it caused loads of other threads to do strange things i.e. the thread title was there but the content had vanished.. any ideas?
Database error in vBulletin 3.0.8:
Invalid SQL:
SELECT postid FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
WHERE threadid = 69893 AND visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY dateline
LIMIT 48, 16
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Wednesday 12th of April 2006 09:17:38 PM
Script: http://www.path_to_thread/showthread.php?t=69893&page=4
Referer: http://www.*******/forumdisplay.php?f=4
Username: ******
IP Address: **.**.**.**
Database error in vBulletin 3.0.8:
Invalid SQL:
SELECT postid FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
WHERE threadid = 69893 AND visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY dateline
LIMIT 48, 16
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Wednesday 12th of April 2006 09:17:38 PM
Script: http://www.path_to_thread/showthread.php?t=69893&page=4
Referer: http://www.*******/forumdisplay.php?f=4
Username: ******
IP Address: **.**.**.**
Comment