Announcement

Collapse
No announcement yet.

Need Immediate Help! Forum Down!

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

  • Need Immediate Help! Forum Down!

    Hi:

    I am getting the following error when trying to update thread info in the forum admin:

    Database error in vBulletin Control Panel 2.3.0:
    Invalid SQL: SELECT COUNT(postid) AS posts
    FROM post
    LEFT JOIN thread USING (threadid)
    WHERE userid='999' AND
    forumid IN (0,3,4,5,6,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,23,24,25,26,27,29,30)
    mysql error: Can't open file: 'thread.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Friday 05th of September 2003 10:17:28 AM
    Script: http://www.aquariumpros.com/forums/f...admin/misc.php
    Referer: http://www.aquariumpros.com/forums/admin/misc.php


    and I'm getting these emails:

    Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT * FROM thread WHERE threadid=243

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

    mysql error number: 1016

    Date: Friday 05th of September 2003 10:06:04 AM

    Script: http://www.aquariumpros.com/forums/f...p?threadid=243

    Referer: http://search.yahoo.com/search/msie?...&a=fd&ei=UTF-8

    I am using VB 2.30 with mySQL 2.53
    Last edited by aquariumpro; Fri 5th Sep '03, 7:24am.

  • #2
    your database carshed, youll.. whoa.. old mysql :\

    also this isnt a vb3 problem but a vb2 problem :\

    you need to upload the repair script from the extras folder and run it i belive :\

    Comment


    • #3
      Moved to more appropriate forum...

      Yes, Faranth's answer is correct, you need to upload and run repair.php following the instructions on the screen.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        that mysql is rather old isnt it ? :\

        Comment


        • #5
          Help

          Sorry the sql is 4.014. OK, the repair.php is reporting a problem with the session table:

          The handler for the table doesn't support repair

          Please help. What do I do now?

          Comment


          • #6
            Originally posted by aquariumpro
            Sorry the sql is 4.014. OK, the repair.php is reporting a problem with the session table:

            The handler for the table doesn't support repair

            Please help. What do I do now?
            disregard errors reported by repair.php regarding sessions table as sessions table is HEAP in memory table format and repair.php only works with MYISAM table format which is what format the rest of vB tables are..
            :: 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


            • #7
              Originally posted by eva2000
              disregard errors reported by repair.php regarding sessions table as sessions table is HEAP in memory table format and repair.php only works with MYISAM table format which is what format the rest of vB tables are..
              Yes, but I'm still getting this error now after running repair.php when I try to update the thread info:

              Database error in vBulletin Control Panel 2.3.0:
              Invalid SQL: UPDATE thread SET lastpost=1062630465,replycount=2,postusername='amandalou', postuserid='327', lastposter='amandalou',attach= WHERE threadid=1667
              mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=1667' at line 1
              mysql error number: 1064
              Date: Friday 05th of September 2003 04:22:44 PM
              Script: http://www.aquariumpros.com/forums/f...admin/misc.php
              Referer: http://www.aquariumpros.com/forums/admin/misc.php

              Comment


              • #8
                http://www.vbulletin.com/forum/showp...10&postcount=3 may help.

                Comment


                • #9
                  Originally posted by aquariumpro
                  Yes, but I'm still getting this error now after running repair.php when I try to update the thread info:

                  Database error in vBulletin Control Panel 2.3.0:
                  Invalid SQL: UPDATE thread SET lastpost=1062630465,replycount=2,postusername='amandalou', postuserid='327', lastposter='amandalou',attach= WHERE threadid=1667
                  mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=1667' at line 1
                  mysql error number: 1064
                  Date: Friday 05th of September 2003 04:22:44 PM
                  Script: http://www.aquariumpros.com/forums/f...admin/misc.php
                  Referer: http://www.aquariumpros.com/forums/admin/misc.php
                  try reading this http://www.vbulletin.com/forum/showthread.php?t=69803 and see if the section 2 quick fix works if not you might need to wait for mysql 4.0.15

                  is this corruption always happening ?
                  :: 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


                  • #10
                    Originally posted by eva2000
                    try reading this http://www.vbulletin.com/forum/showthread.php?t=69803 and see if the section 2 quick fix works if not you might need to wait for mysql 4.0.15

                    is this corruption always happening ?
                    No, this is the first time this has ever happened. I did read that post and appreciate it very much. However, I am not very good at mysql and am quite frustrated.

                    Comment


                    • #11
                      you could try running the repair a gain a few more times

                      Comment

                      Loading...
                      Working...
                      X