Announcement

Collapse
No announcement yet.

Database Error after upgrading to 4.2.0 - forumautosave crashed

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

  • [Forum] Database Error after upgrading to 4.2.0 - forumautosave crashed

    Since upgrading to 4.2.0 I am getting a data base error when I try to click on any post, the error I have posted below, I assume that I have to repair Table './shoppingtelly/forumautosave' is marked as crashed and should be repaired can anyone help as been driving me nuts for hours now - Thanks in advance.


    Database error in vBulletin 4.2.0:
    Invalid SQL:
    SELECT
    pagetext, title
    FROM forumautosave
    WHERE
    contentid = 0
    AND
    parentcontentid = 36481
    AND
    contenttypeid = 'vBForum_Post'
    AND
    userid = 2377;
    MySQL Error : Table './shoppingtelly/forumautosave' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Thursday, September 6th 2012 @ 08:42:06 PM
    Error Date : Thursday, September 6th 2012 @ 08:42:07 PM
    Script : http://forum.shoppingtelly.com/forum...rices-10-09-12
    Referrer : http://forum.shoppingtelly.com/forum...searchid=15243
    IP Address : 94.170.197.99
    Username : NEWS
    Classname : vB_Database
    MySQL Version : 5.0.95

  • #2
    Admin CP -> Maintenance -> Repair / Optimize Tables: Check "forumautosave", make sure "Repair Tables" is set to Yes, and click the Continue button.

    Alternatively, you can run the following MySQL query:
    Code:
    REPAIR TABLE forumautosave;

    Comment


    • #3
      Thank you, I think that may have brought up the problem, I got the message below after I clicked the continue button, any help you can give would jusgt be brilliant, thanks again.

      forumautosave Check Warning: Table is marked as crashed
      forumautosave Check Warning: 1 client is using or hasn't closed the table properly
      forumautosave Check Error: Size of indexfile is: 90112 Should be: 91136
      forumautosave Check Error: Corrupt
      forumautosave

      Comment


      • #4
        If running the repair once doesn't fix it, try it again.

        Comment


        • #5
          Thank you Matthew so much, now have another problem but will search before I post, thanks again.

          Comment

          Related Topics

          Collapse

          Working...
          X