mysql error number: 1146

  • Time
  • Show
Clear All
new posts
  • Bass Cadet
    • Mar 2003
    • 72

    mysql error number: 1146

    My host, recently restored a database for me to fix your copyright information and when they did so I started getting this error:

    Invalid SQL: 
    		userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
    		IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    			language.phrasegroup_holiday AS phrasegroup_holiday,
    			language.phrasegroup_global AS phrasegroup_global,
    			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
    		INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
    		INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
    		WHERE user.userid = 1
    mysql error: Table 'midsouth_sunshine.user' doesn't exist
    mysql error number: 1146

    After submitting a trouble ticket to you guys I was told they user table didn't exist. Well after 5 days of bouncing emails back with my provider ( I was told their backup was no good. Actually better yet here's the email I got from them...

    Sorry for late reply. We have the backup from November/12, do you want us to restore it for you?. If you want we can copy into your home directory as well. Please let us know.

    Best Regards,
    David Kathiramalai


    I have restored this database, you may need to reassign the user its permissions on it before it can acccess it.
    Julian Villan

    The user table here is gone, we may need to recreate from backup here.
    Wish to proceed?

    Warm regards,
    Joe S.


    After multiple attempts to restore the database backup, it appears that the data required is not actually present within the backup or is beyond restoreable. Unfortunately this means you will need to restore this database from your own local backup.
    Let us know if we can assist you with anything further.
    Beau Henderson


    Neither the daily nor the weekly backup archives appear to contain a "user" or "users" table.
    Could this table have been called something else?
    Unfortunately we do not have any older backups available.
    Vince Stratful

    . . .

    So is there ANYTHING you guys can recommend because my 5 year old website, members... donating members... everyone, everything is gone and I'm really upset, esp with Site5.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    If the backup is incomplete then I'm afraid the only option is to use one that is complete.
    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.


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