Database error after uninstalling some mod :(

[dj_melayu]

Hi guys, I am really need ya help regarding to my problem posted here.

Your immediate attention is highly appreciated since the Author of this hack was last taken action on 17. April 2006 For your information this thread is supported but I wonder why he don't support his mod

Best Regards & Sorry for posting in the wrong sections

[upirate]

not only its the wrong section. thats an inppropriate title for a post. Everyone needs help.

[dj_melayu]

Can you give a positive feedback? I really need help

[SCRIPT3R]

the mod is tagged as Supported so why not just email/PM the mod creator? An additional note... why would you install a hack that has not yet been released for the current version of vB without the hack authors notation that it will work? Guess you learned your lesson huh?

[dj_melayu]

Originally Posted by GearTripper

the mod is tagged as Supported so why not just email/PM the mod creator? An additional note... why would you install a hack that has not yet been released for the current version of vB without the hack authors notation that it will work? Guess you learned your lesson huh?

I don't know whether it is compatible with 3.6 version. But mine working fine on after I decided to uninstall that mod and install mod compatible with 3.6 version. Yeah, I know I just learned someting but could ya guys just help me fix this problem?

Can I just remove the table for plugins?If yes, what is the name for plugins table? For your information,I didnt backup my db for today since it just 2.30am here. My last backup was did yesterday on 11pm (Thursday). I don't want to lose my new members, new thread/post and so on.
I know I'll losing it if I restore by backup.Please help me

Thanks for your help

[SCRIPT3R]

i'm not familiar with that particular hack... but the uninstall features should automatically remove all tables created during the install process. empty tables shouldn't really even hurt your DB if they still exists. if it's a plugin, you could disable all plugins so your board runs and then remove/reinstall them one by one as needed. what is the specific error message you're getting?

[dj_melayu]

I didnt give me any specific message.It just a database error page. For your info, I've disabled plugin tru config.php but still I couldn't login to my ACP.

Thanks Man, thanks for your help

[SCRIPT3R]

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

[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