Help! MySQL Has Died!

[JohnBradshaw]

Hi

I keep getting this error message:

Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0
AND user.invisible = 0
AND session.lastactivity>1003267637)
WHERE post.postid IN (0,1916,1921,1925,1926,1935,1951,1997,2001,2054,59 83)
ORDER BY dateline

mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Tuesday 16th of October 2001 10:42:17 PM
Script: /forums/showthread.php?postid=5983
Referer:

This happened yesterday, my board had been working fine for 6 months.

I have RedHat Linux and the later version of vB

Can anyone help me please!

[orca]

I did a search on www.mysql.com and one hit was about the size of the db was exceeded beyond various others.

[JohnBradshaw]

I think my database may be corrupted, how do I fix this?

I get this error with the database fixing tool:

Database error in vBulletin: Invalid SQL: CHECK TABLE announcements
mysql error: You have an error in your SQL syntax near 'CHECK TABLE announcements' at line 1
mysql error number: 1064
Date: Wednesday 17th of October 2001 02:08:02 PM
Script: /forums/repair.php?html=1&check=1&forum=deskpro&iterations=4
Referer:


John Bradshaw
10-17-2001 09:33 AM
I have managed to narrow the problem down to just showing threads, everything else seems to work fine, including logins etc...

The error I am gettin is:
Database error in vBulletin: Invalid SQL:
SELECT DISTINCT
session.userid AS sessionuserid,
announcementid,startdate,enddate,announcement.titl e,pagetext,user.*,userfield.*
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM announcement
LEFT JOIN user ON user.userid=announcement.userid
LEFT JOIN userfield ON userfield.userid=announcement.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=announcement.userid
LEFT JOIN session ON (session.userid = announcement.userid
AND session.userid <> 0
AND user.invisible = 0
AND session.lastactivity>1003324331)
WHERE startdate<='1003325231' AND enddate>='1003325231' AND (announcement.forumid='3' OR announcement.forumid='1' OR announcement.forumid='-1') ORDER BY startdate DESC
mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Wednesday 17th of October 2001 02:27:11 PM
Script: /forums/announcement.php?forumid=3
Referer: http://www.scc-forums.org/forums/forumdisplay.php?forumid=3


or

Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>1003324378)
WHERE post.postid IN (0,3324,5703,5723)
ORDER BY dateline

mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Wednesday 17th of October 2001 02:27:58 PM
Script: /forums/showthread.php?threadid=444
Referer: http://www.scc-forums.org/forums/forumdisplay.php?forumid=3


Please help I am really stuck!!

[orca]

Did you try rnning repair.php?

[Steve Machol]

I wish I could help. You might want to fill out a support request form:

http://www.vbulletin.com/support/

[eva2000]

try this if you're using mysql 3.23.x and have root telnet access http://i4net.tv/marticle/get.php?action=getarticle&articleid=7

[JohnBradshaw]

Still no change I am afraid, the error messages from the forums read:

Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>1003351165)
WHERE post.postid IN (0,5117,5553,5694,5800,5948)
ORDER BY dateline

mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Wednesday 17th of October 2001 09:54:25 PM
Script: /forums/showthread.php?postid=5948#post5948
Referer: http://www.scc-forums.org/forums/

The repair error message reads:

Database error in vBulletin: Invalid SQL: CHECK TABLE announcements
mysql error: You have an error in your SQL syntax near 'CHECK TABLE announcements' at line 1
mysql error number: 1064
Date: Wednesday 17th of October 2001 09:57:14 PM
Script: /forums/repair.php?html=1&check=1&forum=deskpro&iterations=4
Referer:



Chris Padfield suggested, and is, doing data dumps and copying them over to a new clean install of forums.

[eva2000]

so the instructions at http://i4net.tv/marticle/get.php?action=getarticle&articleid=7 didn't work ????

[JohnBradshaw]

They didn't work :-(

I would be happy to give you root access to my server and phpadmin/vB access too, if you can fix it