Announcement

Collapse
No announcement yet.

SQL errors

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

  • SQL errors

    Recently I have been having problems with my server, now when I try to access forums or threads on my site it gives me mysql errors. The site is http://www.nameforums.net/index.php?

    Thanks!
    http://nameforums.net

  • #2
    Your thread table is corrupted:

    mysql error: Can't open file: 'vb3_thread.MYI'. (errno: 145)

    Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      there are a ton of things that say corrupt or error and each time i run it nothing changes
      http://nameforums.net

      Comment


      • #4
        You need to run this as many times as it takes to repair all errors. If the db is in real bad shape, this may take some time. Hopefully it's not too damaged to be fixed. Otherwise you will need to restore a backup.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          i tried to repair it about 20 times and this is what it says:
          http://nameforums.net/repair.htm

          there is nothing i can do besides restore the database? the latest backup i have is from june 20th
          http://nameforums.net

          Comment


          • #6
            Error code 28: No space left on device

            One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

            Note in order for repair to fix the table it first must make a backup of it. Therefore the server needs to have enough space (probably in it's tmp partition) to hold a backup of this table. In general the server needs to have 2.5 -3 times the amount of free space as the largest table. Obviously the larger the table, the more space required.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              ok, but now I cant even log into the admincp
              http://nameforums.net

              Comment


              • #8
                You still need to follow the instructions in post #6. After space is freed up, you can repair the tables in phpMyAdmin.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  it was actually the /var partition that was full, its now down to 85% but it was enough to repair the forum, thanks!
                  http://nameforums.net

                  Comment

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