PDA

View Full Version : I keep getting "Invalid SQL" errors emailed to me


FLMom
06-16-2006, 01:52 PM
Can someone please explain to me what all of this means? I have gotten several over the last few days and am not sure why. They are being sent to my email address and from what I can see are from a journal, but I deleted all of that a week or so ago, could I have missed something in the uninstall?
Thanks for any help! :)




Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT languageid,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_journalhack AS phrasegroup_journalhack,
phrasegroup_qtodo AS phrasegroup_qtodo,
phrasegroup_global AS phrasegroup_global,
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_journalhack' in 'field list'
Error Number : 1054
Date : Friday, June 16th 2006 @ 06:42:11 AM
Script : http://www.myparentconnection.com/forums/journal.php?do=showjournal&j=5
Referrer :
IP Address : xx.xx.xxx.xxx
Username :
Classname : vb_database

Dan
06-16-2006, 04:19 PM
Is this on vbulletin 3.6? If so go into phpmyadmin and goto the phrasegroup table and drop anything that has journal in it ;) That should fix it (BACK UP FIRST!!!) I used a similar method with another hack that was causing me issues. Might also want to remove the journal.php file.

Paul M
06-16-2006, 04:21 PM
You obviously haven't removed all the journal code either, did it involve any file edits ?

FLMom
06-16-2006, 04:50 PM
No I am not brave enough to upgrade to 3.6 lol

Paul, I have no idea if it had any file edits. I payed someone from here to install it. Seems like I have had nothing but problems with this thing. Would you happen to know where I can look to get rid of all of the files? I thought by clicking "uninstall" that would get rid of everything..guess I was wrong lol

Dan
06-16-2006, 04:52 PM
delete journal.php

FLMom
06-16-2006, 04:54 PM
Thank you Dan :D Will do that now!