MySQL Forums
Forum List  »  Newbie

Got error 134 from storage engine. Error number 1030
Posted by: jon burlison
Date: December 06, 2011 10:58PM

My server crashed and I started getting this errors emailed to me.

In cpanel I did the repair database and it completed but I still cannot access the forum.

I am a novice and don't know what I am doing.

Here are the messages that came to me.

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
session.userid, session.inforum, session.lastactivity, session.badlocation,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

FROM vb4_session AS session
LEFT JOIN vb4_user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1323227059

ORDER BY username ASC;

MySQL Error : Got error 134 from storage engine
Error Number : 1030
Request Date : Tuesday, December 6th 2011 @ 10:34:19 PM
Error Date : Tuesday, December 6th 2011 @ 10:34:19 PM
Script : http://edcforums.com/forum.php
Referrer : http://edcforums.com/
IP Address : 72.184.132.151
Username : austindavis1989
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


FROM vb4_post AS post
LEFT JOIN vb4_user AS user ON(user.userid = post.userid)
LEFT JOIN vb4_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb4_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vb4_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vb4_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb4_customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN vb4_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vb4_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1)
LEFT JOIN vb4_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1)
LEFT JOIN vb4_sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (01009285,1009293,1009364)
ORDER BY post.dateline;

MySQL Error : Table './jsbur2_vb4edc/vb4_user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, December 6th 2011 @ 11:15:26 PM
Error Date : Tuesday, December 6th 2011 @ 11:15:26 PM
Script : http://edcforums.com/showthread.php/81986-pocket-clip
Referrer :
IP Address : 157.55.17.145
Username : Unregistered
Classname : vB_Database
MySQL Version :

Options: ReplyQuote


Subject
Written By
Posted
Got error 134 from storage engine. Error number 1030
December 06, 2011 10:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.