Announcement

Collapse
No announcement yet.

4.1.10 Database Error

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

  • Wayne Luke
    replied
    Table is marked as crashed and should be repaired. Since it is the user table, you'll need to repair it in phpMyAdmin or contact your hosting provider.

    Leave a comment:


  • Kremechoco
    replied
    Oh. Checked the email. This is what I'm getting:

    Code:
    Invalid SQL:
    
            SELECT 
                userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
                IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                language.phrasegroup_global AS phrasegroup_global,
                language.phrasegroup_dbtech_vbshout AS phrasegroup_dbtech_vbshout,
                language.phrasegroup_user AS phrasegroup_user,
                language.phrasegroup_posting AS phrasegroup_posting,
                language.phrasegroup_album AS phrasegroup_album,
                language.phrasegroup_messaging AS phrasegroup_messaging,
                language.phrasegroupinfo AS lang_phrasegroupinfo,
                language.options AS lang_options,
                language.languagecode AS lang_code,
                language.charset AS lang_charset,
                language.locale AS lang_locale,
                language.imagesoverride AS lang_imagesoverride,
                language.dateoverride AS lang_dateoverride,
                language.timeoverride AS lang_timeoverride,
                language.registereddateoverride AS lang_registereddateoverride,
                language.calformat1override AS lang_calformat1override,
                language.calformat2override AS lang_calformat2override,
                language.logdateoverride AS lang_logdateoverride,
                language.decimalsep AS lang_decimalsep,
                language.thousandsep AS lang_thousandsep
    
            FROM user AS user
            LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
            LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
    
            WHERE user.userid = 20;
    
    MySQL Error   : Table './Censored**/user' is marked as crashed and should be repaired
    Error Number  : 145
    Request Date  : Wednesday, February 8th 2012 @ 09:10:21 PM
    Error Date    : Wednesday, February 8th 2012 @ 09:10:21 PM
    Script        : http://censored/vbshout.php
    Referrer      : http://censored**.net/
    IP Address    : censored
    Username      : 
    Classname     : vB_Database
    MySQL Version :
    My whole user table is crashed...?
    Is there no way to fix this?

    Leave a comment:


  • beishe8
    replied
    Your host might be able to help.

    Leave a comment:


  • Wayne Luke
    replied
    If you're technical email is filled out in the config.php file, you should get an email with the database error. Unfortunately, there is no way to tell you how to resolve the issue without seeing what the error is.

    Leave a comment:


  • Kremechoco
    replied
    Originally posted by beishe8 View Post
    Isn't it the MySQL server causing problems ?
    That's what I assume it could be. But how would I go about and fix this?

    Leave a comment:


  • beishe8
    replied
    Isn't it the MySQL server causing problems ?

    Leave a comment:


  • Kremechoco
    started a topic [Forum] 4.1.10 Database Error

    4.1.10 Database Error

    My forum was running just fine a few minutes ago, then suddenly I'm getting database error. I've checked the page source and there's nothing that shows an error.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X