Database error after uninstalling some mod :(

[dj_melayu]

Originally Posted by GearTripper

if you view the source code of the error page, you will be able to see the specific DB error message.

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_showthread AS phrasegroup_showthread,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
language.phrasegroup_profilefield AS phrasegroup_profilefield,
language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
language.phrasegroup_autopm_title AS phrasegroup_autopm_title,
language.phrasegroup_autopm_text AS phrasegroup_autopm_text,
language.phrasegroup_photoplog AS phrasegroup_photoplog,
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
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 = 5;

MySQL Error : Unknown column 'language.phrasegroup_posting' in 'field list'
Error Number : 1054
Date : Thursday, March 22nd 2007 @ 05:37:48 PM
Script : http://www.myforum.org/showthread.php?t=1833
Referrer :
IP Address : **********
Username :
Classname : vB_Database

Yeah, you're right, this is the database error details. I'm really nooby And Didn't know how to solve this. Really need ya help.

Thanks a lot guys..You're very helpfull community. I've restore by old db and this thread shall be close. Thanks and have a good day