Announcement

Collapse
No announcement yet.

Urgently Help please

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Urgently Help please

    My database has report this error.How can i fix that


    HTML Code:
    Database error in vBulletin 3.0.3:
    Invalid SQL: 
      SELECT
       user.username, (user.options & 512) AS invisible, user.usergroupid,
       session.userid, session.inforum, session.lastactivity,
       IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
      FROM session AS session
      LEFT JOIN user AS user ON(user.userid = session.userid)
      WHERE session.lastactivity > 1103556737
      ORDER BY username ASC
     
    mysql error: Can't open file: 'session.MYI'. (errno: 145)
    
    mysql error number: 1016

  • #2
    Sorry forget it i use REPAIR TABLE session; and OK now.

    Thanks

    Comment


    • #3
      You shouldnt be able to repair a session table IIRC, what is the table type for your session table?

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X