vb.org Archive - Database error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Database error (https://vborg.vbsupport.ru/showthread.php?t=275398)

RichieBoy67

12-12-2011 11:12 PM

Database error

Hey all, I hope everyone is having a great holiday season.

I am getting some of these lately. Any ideas??

PHP Code:


		
			
Database error in vBulletin 4.1.7:  Invalid SQL:              SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,                           NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,             post.pagetext AS description,             thread.*                                       FROM vb_thread AS thread                          LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid =   AND subscribethread.canview = 1)                                       LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)                                       WHERE thread.threadid = 2127;  MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND subscribethread.canview = 1)                                       LEFT JOIN vb_post AS post ON(post.po' at line 11 Error Number  : 1064

Thanks,
Richie

kh99	12-12-2011 11:58 PM

Well, it looks like it comes from function fetch_threadinfo() in includes/functions.php, and the problem is that $vbulletin->userinfo['userid'] is blank. But that function is called from a lot of places so I have no idea why it would happen.

RichieBoy67

12-13-2011 12:33 AM

Thanks much friend.

Yeah, I know it functions.php but I am still trying to figure out why..It happens when members are in cms and sometimes searching.

kh99	12-13-2011 12:37 AM

Yeah, sorry, I knew that wasn't going to be a lot of help. Maybe someone else will recognize the error.

RichieBoy67

12-13-2011 12:45 AM

haha, oh no, I didn't mean it like that. I really appreciate the reply mate. Thanks for trying.

All times are GMT. The time now is 08:03 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01067 seconds Memory Usage 1,724KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages: