Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    My website www.customizepsp.co.uk seems to have an unknown database error. Usually when U get a database error it tells me the location of the problem but it isnt this time. Please could someone take a look and post any suggestions? Thanks
    Last edited by se_p800; Thu 19 Jun '08, 12:24pm.

  • #2
    Your page source shows

    <!--
    Database error in vBulletin 3.7.1:

    Invalid SQL:
    SELECT COUNT(*) AS users,MAX(userid) AS max FROM vbuser;

    MySQL Error : Table './customi5_vbforum/vbuser' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Thursday, June 19th 2008 @ 02:42:16 PM
    Error Date : Thursday, June 19th 2008 @ 02:42:16 PM
    Script : http://www.customizepsp.co.uk/
    Referrer : http://www.vbulletin.com/forum/showthread.php?t=276058
    IP Address : XXX
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    -->
    Last edited by rgMM; Thu 19 Jun '08, 2:38pm. Reason: Removed my (Referrer) IP address

    Comment


    • #3
      Probably have to look at the table that it is referencing

      './customi5_vbforum/vbuser' is marked as crashed and should be repaired

      Comment


      • #4
        Thanks for that but I dont know if I can repair it coz I cant acces admin cp due to the error..

        Comment


        • #5
          I am not familiar with that table but in general one option is repair via phpmyadmin if you can

          Comment


          • #6
            Any chance this will get fixed by itself?

            Comment


            • #7
              No.

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

              Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

              If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

              Also please see these instructions for other available methods to repair a database:

              http://dev.mysql.com/doc/refman/5.0/en/repair.html
              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


              • #8
                Originally posted by Steve Machol View Post
                No.

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

                Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

                If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

                Also please see these instructions for other available methods to repair a database:

                http://dev.mysql.com/doc/refman/5.0/en/repair.html
                I use bluehost and I can go on something called phpmyadmin, please can you tell me how I would fix if from there? Thanks

                EDIT: I repaired everything and it now works. Thanks guys!
                Last edited by se_p800; Fri 20 Jun '08, 6:55am.

                Comment


                • #9
                  Please could someone tell me how this could have been caused? Someone said it might have been a hack attempt somethin to do with the SQL?

                  Comment


                  • #10
                    Table corruption is due to server issues. There are many possible causes and no way to know for certain the exact cause.
                    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

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