error message

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jilly
    Senior Member
    • Apr 2001
    • 1235
    • 3.7.x
    #1

    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?
    Tags: None
    • tubedogg
      Senior Member
      • Feb 2001
      • 13602
      #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:
      Oops! We ran into some problems.
      http://www.afterabortion.com/forums/repair.php

      and follow the onscreen instructions.

        Comment

        • jilly
          Senior Member
          • Apr 2001
          • 1235
          • 3.7.x
          #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

            • tubedogg
              Senior Member
              • Feb 2001
              • 13602
              #4
              Try moving repair.php to your admin directory and doing it from there.

                Comment

                • jilly
                  Senior Member
                  • Apr 2001
                  • 1235
                  • 3.7.x
                  #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

                    • jilly
                      Senior Member
                      • Apr 2001
                      • 1235
                      • 3.7.x
                      #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

                        • tubedogg
                          Senior Member
                          • Feb 2001
                          • 13602
                          #7
                          Yup, it hasn't changed for a while.

                            Comment

                            • jilly
                              Senior Member
                              • Apr 2001
                              • 1235
                              • 3.7.x
                              #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 1 Sep '03, 6:50pm.

                                Comment

                                • tubedogg
                                  Senior Member
                                  • Feb 2001
                                  • 13602
                                  #9
                                  View the source of the error page and post what it says here.

                                    Comment

                                    • jilly
                                      Senior Member
                                      • Apr 2001
                                      • 1235
                                      • 3.7.x
                                      #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

                                        • Steve Machol
                                          Former Customer Support Manager
                                          • Jul 2000
                                          • 154488
                                          #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 1 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

                                            • jilly
                                              Senior Member
                                              • Apr 2001
                                              • 1235
                                              • 3.7.x
                                              #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

                                                • Steve Machol
                                                  Former Customer Support Manager
                                                  • Jul 2000
                                                  • 154488
                                                  #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

                                                    • jilly
                                                      Senior Member
                                                      • Apr 2001
                                                      • 1235
                                                      • 3.7.x
                                                      #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

                                                        • tubedogg
                                                          Senior Member
                                                          • Feb 2001
                                                          • 13602
                                                          #15
                                                          There is very little chnace of this problem being caused by external forces.

                                                            Comment

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