Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > vBadvanced CMPS
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
MySQL Error on 3.0.9 Installation Details »»
MySQL Error on 3.0.9 Installation
Version: , by Andrew Andrew is offline
Developer Last Online: Oct 2014 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 09-19-2005 Last Update: Never Installs: 0
 
No support by the author.

A clients site I frequently work on is getting the following error when trying to access the CMPS:
Code:
Database error in vBulletin 3.0.9:

Invalid SQL: 
  		SELECT 
  		
  		thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  		, thread.iconid AS threadiconid, iconpath AS threadiconpath
			,thread.forumid, forum.title AS forumtitle
			, post.pagetext AS preview
			, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
			FROM vb_thread as thread
			LEFT JOIN vb_icon USING (iconid)
			LEFT JOIN vb_forum AS forum ON (thread.forumid = forum.forumid)
			LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN vb_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
			WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN( )  AND deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC 
			LIMIT 10
	
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 deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC

mysql error number: 1064

Date: Sunday 18th of September 2005 09:14:43 PM
Script: http://vincebaby.com/index.php
Referer: 
Username: ShellR
The forums and all other hacks are working fine - Any ideas what could be causing this ?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
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 09:18 PM.


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.03098 seconds
  • Memory Usage 2,188KB
  • Queries Executed 14 (?)
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)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit_onlinestatus
  • (1)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