Database error

[Khan_]

first of all apologize for posting in this forum .. i dont know where to look for support and create a topic ..

My webhost moved the server and restored on different server ..and now after moving to new server it gives database error ..site dosent loads and i have no idea what to do .can someone please help me with it .. i dont want to loose my 13k members and everything .. please help.

[borbole]

What is the exact db error you get?

P.s. Check the config.php file and make sure that the db infos in there match those of the db in the new server.

[Marco van Herwaarden]

Please provide the full database error as given in the pagesource of the error page or in your email.

[Khan_]

i got error email like over 1500 ... which one should i give out ..

the latest email ..

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_holiday AS phrasegroup_holiday,
                       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 = 3186;

MySQL Error   : Table 'champ_site.user' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, February 17th 2010 @ 04:27:09 PM
Error Date    : Wednesday, February 17th 2010 @ 04:27:09 PM
Script        : http://www.wrestlingconcepts.com/
Referrer      :
IP Address    : 109.96.188.93
Username      :
Classname     : vB_Database
MySQL Version :

and another one

Database error in vBulletin 3.8.2:

Invalid SQL:

                               SELECT *
                               FROM session
                               WHERE userid = 0
                                       AND host = '189.187.55.187'
                                       AND idhash = '08c475b42ddc9d99006a9f28c61fb43a'
                               LIMIT 1;

MySQL Error   : Table 'champ_site.session' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, February 17th 2010 @ 04:28:32 PM
Error Date    : Wednesday, February 17th 2010 @ 04:28:32 PM
Script        : http://wrestlingconcepts.com/
Referrer      : http://www.google.it/search?hl=en&q=wrestling+concepts&btnG=B%FAsqueda+e+Google&meta=
IP Address    : 189.187.55.187
Username      :
Classname     : vB_Database
MySQL Version :

i copy pasted this from my email .. im getting like hundreds of these error emails everytime i refresh my email inbox.

[borbole]

From the errors you posted it seems as if the restore of the db was not done properly as you are missing some db tables (user and session tables).

[Khan_]

what do i do now ...

[borbole]

Tell your host to make a proper restore of the db.

Do you have a backup copy of the db? Try this first, login to the phpmyadmin and check the db tables, if more tables are missing. Then pull them out of the db backup copy (the missing tables) and restore them. That is the easiest and quickest way. That should get your forum back up and running. If the other tables have been restored properly, that is.

Personally, I am surprised that your host did such a messy restore. Any host worth its salt shouldn''t have caused such a problem.

[Xencored]

Did you do a full restore


Table 'champ_site.session' doesn't exist is missing somekind of addon maybe

Find your Config.php
Edit it after the <?php add

PHP Code:

define('DISABLE_HOOKS', true); 


save it and see if you can get on your site with addons disabled

[Marco van Herwaarden]

This is about default tables and has nothing to do with a modification so disabling those will not make a difference.

Originally Posted by Animemike

Did you do a full restore


Table 'champ_site.session' doesn't exist is missing somekind of addon maybe

Find your Config.php
Edit it after the <?php add

PHP Code:

define('DISABLE_HOOKS', true); 


save it and see if you can get on your site with addons disabled

[Marco van Herwaarden]

To troubleshoot this first use a tool like phpMyAdmin to inspect the database the host created for you.

Are the tables there? If not, then the restore was not successfull and you would need to get back to your host. If still available, compair the database to your old database.

If the tables exist are they maybe using a table-prefix and you have uploaded a fresh config.php without a prefix. If so, set the correct prefix in your config.php.