Log in

View Full Version : Data Base Problem all of a Sudden


Battle_Ring
04-14-2004, 03:26 PM
all of a sudden when trying to post im getting

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
thread.*
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)

WHERE thread.threadid = 48

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Wednesday 14th of April 2004 09:22:54 AM
Script: http://battlering.net/forums/newreply.php
Referer: http://battlering.net/forums/showthread.php?t=48
Username: Chris

Battle_Ring
04-14-2004, 03:33 PM
When i go to forums it says
Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost>=1081959774 AND open<>10,1,0)) AS newthread
FROM thread AS thread

WHERE forumid = 19
AND sticky = 0
AND visible = 1

AND thread.lastpost >= 1075480319



mysql error: Can't open file: 'thread.MYI'. (errno: 145)

mysql error number: 1016

Date: Wednesday 14th of April 2004 09:31:59 AM
Script: http://battlering.net/forums/forumdisplay.php?f=19
Referer: http://battlering.net/forums/index.php?
Username: Chris

Scrub
04-14-2004, 03:47 PM
Nevermind. :p

Battle_Ring
04-14-2004, 03:52 PM
i got it i had to repair all tables i had to run it 2 times it had thread as crashed