vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   vBulletin Database Error! (https://vborg.vbsupport.ru/showthread.php?t=218416)

Arashdn 07-12-2009 03:23 AM
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?

Dismounted 07-12-2009 04:04 AM
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); 

Arashdn 07-12-2009 04:31 AM
Do it disable Plugins & Products I have installed?

wolfstream 07-12-2009 04:46 AM
Quote:
Originally Posted by Arashdn (Post 1847302)
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

Arashdn 07-12-2009 01:47 PM
But i have many plugins and i can`t disable them

Pokerbanter 07-12-2009 01:53 PM
In that case you'll just need to live with the database errors then. :rolleyes:

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?

Lynne 07-12-2009 02:15 PM
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.


All times are GMT. The time now is 11:23 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.01035 seconds
  • Memory Usage 1,726KB
  • 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_php_printable
  • (2)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