PDA

View Full Version : Database errors - Invalid SQL - HELP


Jonm
05-07-2016, 07:11 PM
How do you stop this?



Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_garage AS phrasegroup_garage,
phrasegroupinfo AS lang_phrasegroupinfo,
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_garage' in 'field list'
Error Number : 1054
Request Date : Saturday, May 7th 2016 @ 08:53:53 AM
Error Date : Saturday, May 7th 2016 @ 08:53:53 AM
Script : http://www.staffs-vw.co.uk/garage_attachment.php?id=530
Referrer : http://www.staffs-vw.co.uk/staffs-vw-members-rides/11600-mk6-golf-camo.html
IP Address : 173.245.56.160
Username :
Classname : vB_Database_MySQLi
MySQL Version :

Dave
05-07-2016, 07:27 PM
The column phrasegroup_garage does not exist in the language table.
I assume you're using a custom plugin on that page? I guess re-installing it might fix it.

Jonm
05-07-2016, 07:50 PM
I deleted the garage plugin as it was taking up too much space and now I get this email about 7 times per day....

Dave
05-07-2016, 07:53 PM
Did you delete all files on the server that belonged to that plugin? You should delete those as well.
My guess is that bots still crawl those pages which triggers the error.

Jonm
05-11-2016, 08:34 PM
yes, all the folders are empty

Dave
05-11-2016, 08:39 PM
The error happens in the file /garage_attachment.php. Did you delete that file as well?

Jonm
05-17-2016, 06:16 PM
The error happens in the file /garage_attachment.php. Did you delete that file as well?

I have now, found this file in the public folder... thanks for that....



maybe you could look at this thread and lend a hand?

https://vborg.vbsupport.ru/showthread.php?p=2570973#post2570973