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 07-12-2009, 03:23 AM
Arashdn Arashdn is offline
 
Join Date: Jan 2009
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vBulletin Database Error!

Hello
I have alot of mails in my inbox from my forum they says:
Quote:
Database error in vBulletin 3.8.1: Invalid SQL: SELECT user.*, ufield.*, subscribethread.emailupdate, subscribethread.subscribethreadid FROM subscribethread AS subscribethread INNER JOIN user AS user ON (subscribethread.userid = user.userid) INNER JOIN userfield AS ufield ON (ufield.userid = user.userid) LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE subscribethread.threadid = 1591 AND subscribethread.emailupdate IN (1, 4) AND subscribethread.canview = 1 AND CONCAT(' ', IF(usertextfield.ignorelist IS NULL, '', usertextfield.ignorelist), ' ') NOT LIKE '% 3 %' AND user.usergroupid <> 3 AND ufield.field20 <> '' AND (usergroup.genericoptions & 32); MySQL Error : Unknown column 'ufield.field20' in 'where clause' Error Number : 1054 Request Date : Thursday, July 9th 2009 @ 07:46:34 PM Error Date : Thursday, July 9th 2009 @ 07:46:34 PM Script : http://www.parseforum.com/newreply.p...streply&t=1591 Referrer : http://www.parseforum.com/newreply.p...quote=1&p=7786 IP Address : 78.38.15.2 Username : Tohid Classname : vB_Database MySQL Version :
I`m using vb 3.8.1 pl 1 on a VPS with php 5.2.10 and MySQL 5.0.67
what should I do?
Reply With Quote
  #2  
Old 07-12-2009, 04:04 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is most likely caused by a modification. Try posting a new post (not Quick Reply), and you should see the error, correct?

Disable all your modifications by placing this line at the end of your config.php. The problem should disappear.
PHP Code:
define('DISABLE_HOOKS'true); 
Reply With Quote
  #3  
Old 07-12-2009, 04:31 AM
Arashdn Arashdn is offline
 
Join Date: Jan 2009
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do it disable Plugins & Products I have installed?
Reply With Quote
  #4  
Old 07-12-2009, 04:46 AM
wolfstream wolfstream is offline
 
Join Date: Jan 2003
Location: Iowa
Posts: 382
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Arashdn View Post
Do it disable Plugins & Products I have installed?
Yes, the above will do this, and in this case it is the best way to start debugging your issue
Reply With Quote
  #5  
Old 07-12-2009, 01:47 PM
Arashdn Arashdn is offline
 
Join Date: Jan 2009
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

But i have many plugins and i can`t disable them
Reply With Quote
  #6  
Old 07-12-2009, 01:53 PM
Pokerbanter Pokerbanter is offline
 
Join Date: Dec 2008
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In that case you'll just need to live with the database errors then.

Have the same problem myself and i'm having to do it.

--------------- Added [DATE]1247410853[/DATE] at [TIME]1247410853[/TIME] ---------------

I get this error message:

Internal Server Error, this is an error with your script, check your error log for more information.

Where do I find the error log it speaks of?
Reply With Quote
  #7  
Old 07-12-2009, 02:15 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The error_logs on my server are in a directory called /logs. However, the host could have put them anywhere so if you can't find them, you should ask your host where they are.
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 03:11 AM.


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.03589 seconds
  • Memory Usage 2,213KB
  • Queries Executed 11 (?)
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)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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_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