vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Database errors - Invalid SQL - HELP (https://vborg.vbsupport.ru/showthread.php?t=322565)

Jonm 05-07-2016 07:11 PM

Database errors - Invalid SQL - HELP
 
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...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

Quote:

Originally Posted by Dave (Post 2570583)
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/showthrea...73#post2570973


All times are GMT. The time now is 02:02 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01004 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete