PDA

View Full Version : HELP!! Invalid SQL. How to fix this?


nyunyu
04-25-2009, 05:17 PM
I just noticed that this came in my email but was tagged as junk by gmail.

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_local_links AS phrasegroup_local_links,
phrasegroup_threadmanage AS phrasegroup_threadmanage,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_timezone AS phrasegroup_timezone,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_local_links' in 'field list'
Error Number : 1054
Request Date : Saturday, April 25th 2009 @ 11:38:05 AM
Error Date : Saturday, April 25th 2009 @ 11:38:05 AM
Script : http://www.animeheist.com/forum/local_links.php?catid=18&linkid=160
Referrer :
IP Address : xx.xxx.142.151
Username :
Classname : vB_Database
MySQL Version :


What does it means?
The IP are changing on each email I received though. I assume that is the IP of my forum user.

Biker_GA
04-25-2009, 05:20 PM
It means, most likely, you have a plugin that was installed incorrectly. Disable all your plugins, then activate one by one until you get that error again. That will be the offending plugin.

nyunyu
04-25-2009, 05:33 PM
Oh, in that case I think I know just the right plugin that need to be turned off.

Looks like the plugin which I've uninstall before (link and download manager) did not completely uninstalled.
Anyone can advise how to remove this mod completely?

Lynne
04-25-2009, 06:40 PM
Look at the install instructions and undo everything it says to do - including removing any files it asked you to upload.

nyunyu
04-25-2009, 06:48 PM
Thanks Lynne,

I'll try removing everything.