Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2009, 07:43 PM
jas1159 jas1159 is offline
 
Join Date: Nov 2006
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default What does this mean?

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/g.../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/g....php?ltr=H&c=2
IP Address : 91.108.88.150
Username : henrys r32
Classname : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 10-04-2009, 07:50 PM
James Birkett James Birkett is offline
 
Join Date: Jun 2009
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Error 2: The table "swcruise_forum3x8.ppgal_user" doesn't exist.
Reply With Quote
  #3  
Old 10-04-2009, 07:56 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 10-04-2009, 08:03 PM
jas1159 jas1159 is offline
 
Join Date: Nov 2006
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #5  
Old 10-04-2009, 08:17 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:55 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04038 seconds
  • Memory Usage 2,200KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete