Announcement

Collapse
No announcement yet.

Database Errors

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

  • Dj Smuggla
    replied
    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...

    Leave a comment:


  • TheNewOne
    replied
    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.

    Leave a comment:


  • Wayne Luke
    replied
    http://php.about.com/od/mysqladminis...pair_mysql.htm

    Leave a comment:


  • Dj Smuggla
    replied
    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"

    Leave a comment:


  • Lynne
    replied
    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.

    Leave a comment:


  • Dj Smuggla
    started a topic Database Errors

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X