What does this mean?

[jas1159]

Hi, i am looking for some advice :)

I keep getting thousands of emails from my forum reporting errors. it seems to be related to users or guests but i am a novice so would appreciate a steer int he right direction.

Any help you can offer will be greatly appreciated. Here are the error messages.

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT catid, styleid, title, title_clean, description, description_clean, parent, hasimages, active, membercat, parentlist, catimage, imagecount, postcount, catuserid, useroptions, lastimageid, lastimagetitle, lastimageuserid, lastimageusername, lastimagedateline, lastpostid, lastpostuserid, lastpostusername, lastpostimagetitle, lastpostdateline, styleoverride
FROM ppgal_categories
ORDER BY displayorder ASC;

MySQL Error : Unknown column 'title_clean' in 'field list'
Error Number : 1054
Request Date : Sunday, October 4th 2009 @ 07:16:11 PM
Error Date : Sunday, October 4th 2009 @ 07:16:11 PM
Script : http://www.swcruise.com/forum3.6.8/gallery/index.php?c=4
Referrer :
IP Address : 74.6.18.222
Username : Unregistered
Classname : vB_Database
MySQL Version :

----------------------------------------------------------------------------------------------------------------

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE ppgal_user
SET ppicount = ppicount+1, lastimageid=803, lastimagetitle='R32', lastimagedate='1254687340'
WHERE userid = '3085';

MySQL Error : Table 'swcruise_forum3x8.ppgal_user' doesn't exist
Error Number : 1146
Request Date : Sunday, October 4th 2009 @ 09:15:38 PM
Error Date : Sunday, October 4th 2009 @ 09:15:40 PM
Script : http://www.swcruise.com/forum3.6.8/gallery/upload.php
Referrer : http://www.swcruise.com/forum3.6.8/gallery/browseimages.php?ltr=H&c=2
IP Address : 91.108.88.150
Username : henrys r32
Classname : vB_Database
MySQL Version :

[James Birkett]

Error 1: The column " title_clean"doesn't exist in "field list"

Error 2: The table "swcruise_forum3x8.ppgal_user" doesn't exist.

[Lynne]

It looks to me like maybe you installed some mods, then disabled/deleted them but didn't remove the files you uploaded for the mod from the server. When you go to uninstall a mod, you should always go back and reread the install instructions and make sure to remove any files, or template edits, that the modification asked you to do during the install process.

[jas1159]

Thanks guys that would make sense..

Can you offer any suggestions as to how i can remove these mods now without knowing what they were?

It seems to be refering to VBgallery and i do use photopost Vb gallery? :s

[Lynne]

If you think those may be the modifications, then go find the modification for download and read the install (or uninstall) instructions for them.