Announcement

Collapse
No announcement yet.

error message

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

  • error message

    when I try to reply to a post on my board, I get this error message

    Database error in vBulletin 2.3.0:
    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1014,228991,0),(652,228991,0),(112,228991,0)
    mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Sunday 31st of August 2003 09:20:19 PM
    Script: http://www.afterabortion.com/forums/forums/newreply.php
    Referer:

    and when I try to do a new post, i get

    Database error in vBulletin 2.3.0:
    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1014,228997,1)
    mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Sunday 31st of August 2003 09:25:50 PM
    Script: http://www.afterabortion.com/forums/.../newthread.php
    Referer:

    any ideas?

  • #2
    Find your vB zip file, extract repair.php (from the extras folder) and upload it to your forums root folder. Run it in a browser like this:
    http://www.afterabortion.com/forums/repair.php
    and follow the onscreen instructions.

    Comment


    • #3
      I still get an error message -

      I ran it per the instructions, first I ran

      repair.php?html=1&check=1
      and got the error message below,
      then I did

      repair.php?check=1&iterations=4&forum=vbdatabase

      and got the same message below -
      There seems to have been a slight problem with the PASS Support Boards database.
      Please try again by pressing the refresh button in your browser.

      An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.


      We apologise for any inconvenience.

      Comment


      • #4
        Try moving repair.php to your admin directory and doing it from there.

        Comment


        • #5
          oh CRAP - i just noticed this..

          i have vb 2.3.0, but didnt have the zip file anymore due to a crash, so I went and downloaded the newest vb zip, and it's repair php for 2.3.2 - could that be the problem? what do I do now?

          Comment


          • #6
            so should i try it with the repair for 2.3.2?

            I

            just saw your message to move it to admin and try again - will that be okay, using the repair.php for 2.3.2 ?

            Comment


            • #7
              Yup, it hasn't changed for a while.

              Comment


              • #8
                I still get the same error message

                here's what I was doing - I called the url in my browser:


                first
                http://www.afterabortion.com/forums/admin/repair.php?html=1&check=1

                and got the same error message as before, then ran

                http://www.afterabortion.com/forums/...rum=vbdatabase

                and again the same message...
                next step?
                Last edited by jilly; Mon 1st Sep '03, 6:50pm.

                Comment


                • #9
                  View the source of the error page and post what it says here.

                  Comment


                  • #10
                    source code of error page

                    <head><title>PASS Support Boards Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

                    <!-- Database error in vBulletin Control Panel 2.3.0:

                    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
                    mysql error: Can't open file: 'userfield.MYD'. (errno: 145)

                    mysql error number: 1016

                    Date: Monday 01st of September 2003 11:38:51 PM
                    Script: http://www.afterabortion.com/forums/...rum=vbdatabase
                    Referer:
                    -->

                    </table></td></tr></table></form>
                    <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the PASS Support Boards database.</b><br>
                    Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head>

                    Comment


                    • #11
                      Often the user and userfield tables can't be fixed with repair.php. You'll need to run this query in phpMyAdmin:

                      REPAIR TABLE userfield;
                      Last edited by Steve Machol; Mon 1st Sep '03, 8:24pm.
                      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


                      • #12
                        ok, will try to get my web support to do that..

                        i don't know how to do php other than just vbulletin stuff I can call in my browser - so I pass that along to my web host guy, and see if he can run it for me - is there anything else I need to tell him to do?

                        Comment


                        • #13
                          Yeah, just note my edited query:

                          REPAIR TABLE userfield;
                          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


                          • #14
                            what is the possibility this was sabotage?

                            I've had some problems lately with disgruntled members, and just people that dont like my site in general because it is a controversial topic - I am just wondering what the odds are that a problem like this was caused externally?

                            PS - running that query DID fix the problem - thanks all

                            Comment


                            • #15
                              There is very little chnace of this problem being caused by external forces.

                              Comment

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