No announcement yet.

Major problem? Invalid SQL...

  • Filter
  • Time
  • Show
Clear All
new posts

  • Major problem? Invalid SQL...

    Ok i just got up this morning and went to my forums, and got this error

    Database error in vBulletin 3.6.1:
    Invalid SQL:
    SELECT userid, lastactivity, options, username, user.usergroupid, displaygroupid,
    groupa.opentag as opentaga, groupa.closetag as closetaga,
    groupb.opentag as opentagb, groupb.closetag as closetagb
    FROM vb3_user as user
    LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
    LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
    WHERE lastactivity > 1159225200 ORDER BY username;
    MySQL Error : Got error 127 from storage engine
    Error Number : 1030
    Date : Tuesday, September 26th 2006 @ 09:26:23 AM
    Script :
    Referrer :
    IP Address : xx.xx.xx.xx
    Username : xxxxxxxx
    Classname : vb_database

    I changed i.p and username to xxxxxx

    Anyone know what problem is, i needa solve this asap.

  • #2
    MySQL error code 127: Record-file is crashed

    Try repairing your tables from AdminCP->Maintenance

    You might need to repeat this 2 or 3 times.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: