Announcement

Collapse
No announcement yet.

Database Error

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

  • Database Error

    Hey guys, I got this error today:

    Database error in vBulletin 3.0.0:
    Invalid SQL:
    SELECT COUNT(*) AS count
    FROM post
    WHERE dateline >= 1082876400

    mysql error: Can't open file: 'post.MYI'. (errno: 144)
    mysql error number: 1016
    Date: Sunday 25th of April 2004 01:01:18 PM
    Script: http://www.maddennation.com/forums/
    Referer:
    Username: CraigM
    IP Address: 68.204.249.154

    I tried to repair it but I can't. Any suggestions? Thanks!

  • #2
    If you can login to your adminCP.

    AdminCP > Import & Maitence > Repair / Optmize Tables > Select all and hit continue, you made need to do this more than once.

    If you cannot access the AdminCP from phpmyAdmin you can run this

    REPAIR TABLE post;

    Comment


    • #3
      This is what I get:

      post Check Warning: Table is marked as crashed and last repair failed
      post Check Error: Found 126 keys of 72167

      Comment


      • #4
        Keep trying untill its repaired

        Comment


        • #5
          And if that doesn't work?

          Comment


          • #6
            And... this is the error I get when I enter the SQL you told me to enter in earlier.

            Can't create new tempfile: '/var/lib/mysql/maddenna_forums/post.TMD'

            Comment


            • #7
              This is sounding like a host issue, you should try contacting your host.

              Comment


              • #8
                Originally posted by Sinko
                This is what I get:

                post Check Warning: Table is marked as crashed and last repair failed
                post Check Error: Found 126 keys of 72167
                do the following in this order

                1. close forum via admincp off switch
                2. if you have ssh telnet access type the following

                mysqlcheck -s -u mysqlusername -p vbdatabasename

                this reports which mysql tables have errors (ignore any messages to do with session table)

                now to repair

                mysqlcheck -r -q -u mysqlusername -p vbdatabasename

                reason why is vB's internal mysql repair options can no repair all mysql corruptions like mysqlcheck can

                mysqlcheck is available from mysql 3.23.38 onwards
                :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                :: Nginx SPDY SSL - World Flags Demo [video results]
                :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                Comment

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