Announcement

Collapse
No announcement yet.

Database Errors

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

  • Database Errors

    Hi i just tried going on my site, but it's showing a database error. It's not showing any info for the error.

    I went to my email account and saw a lot of emails saying database error.

    This was the first one:
    Code:
    Database error in vBulletin 3.8.6:
    
    Invalid SQL:
    SELECT count(*) as num,floor((1315353599-post.dateline)/86400) as  day FROM post AS post LEFT JOIN thread AS thread on  post.threadid=thread.threadid LEFT JOIN forum AS forum on  thread.forumid=forum.forumid WHERE ((forum.options&4096))AND(post.userid=13484)AND(post.dateline>=1312934400) GROUP BY day ORDER BY day;
    
    MySQL Error   : Lost connection to MySQL server during query
    Error Number  : 2013
    Request Date  : Tuesday, September 6th 2011 @ 05:15:51 PM
    Error Date    : Tuesday, September 6th 2011 @ 05:15:53 PM
    Script        :
    Referrer      :
    IP Address    : 180.76.5.91
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    A few like this:

    Code:
    Database error in vBulletin 3.8.6:
    
    Invalid SQL:
    
                            SELECT * FROM user FORCE INDEX (lastactivity)
                            WHERE lastactivity > 1315353600 ORDER BY username;
    
    MySQL Error   : Table './hhd_ddforum/user' is marked as crashed and should be repaired
    Error Number  : 145
    Request Date  : Tuesday, September 6th 2011 @ 05:33:11 PM
    Error Date    : Tuesday, September 6th 2011 @ 05:33:11 PM
    Script        : 
    Referrer      :
    IP Address    : 220.181.108.176
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    And this:
    Code:
    Database error in vBulletin 3.8.6:
    
    Invalid SQL:
    SELECT userid, usergroupid, membergroupids, infractiongroupids, username, password, salt FROM user WHERE username = 'framinoky';
    
    MySQL Error   : Table './hhd_ddforum/user' is marked as crashed and should be repaired
    Error Number  : 145
    Request Date  : Tuesday, September 6th 2011 @ 05:33:45 PM
    Error Date    : Tuesday, September 6th 2011 @ 05:33:45 PM
    Script        : 
    com/login.php
    Referrer      :
    IP Address    : 74.53.190.130
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    When i go to the acp to repair the table again it just says database error.

    Does anyone know how i can fix this issue? It was working fine earlyer.

  • #2
    Your user table needs to be repaired. Since you won't be able to do this from the admincp, you will need to either ask your host, or do it via phpMyAdmin.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      Thanks for your quick reply Lynne

      How do i repair a table in phpMyAdmin?

      I logged in to phpMyAdmin, clicked the database, then clicked on the user table & clicked the Operations tab but i cant see a option for Repair Table.

      Is it the same as Flush the table (FLUSH), because thats all i see under "Table maintenance"

      Comment


      • #4
        http://php.about.com/od/mysqladminis...pair_mysql.htm
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          1. Login to phpMyAdmin
          2. Choose the affected database. If you only have one database, it should choose it by default so you don't need to do anything.
          3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
          4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose "Repair Table"
          This should fix your table, and let you access it again.

          Comment


          • #6
            Thanks a lot guys for your fast replys, i was pulling my hair out trying to fix this...

            Now that it is fixed... it's a good idea to make that database backup!
            Your not wrong there m8...

            Comment

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