vBadvanced Forums  
Go Back   vBadvanced Forums > vBadvanced Products > vBadvanced CMPS > vBa CMPS v3.0 Support > Troubleshooting & Problems

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2007, 05:59 PM
ludachris ludachris is offline
Senior Member
 
Join Date: Oct 2005
Posts: 184
Default Just upgraded and am getting this error

This is happening for one of my pages... not the main index page, but one of the sub pages. I've disabled custom modules.
Code:
Database error in vBulletin 3.6.8:

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.forumid
				, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed, post.pagetext AS preview
				FROM thread as thread
				 LEFT JOIN post AS post ON (post.postid = thread.firstpostid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
				WHERE open != 10 AND thread.visible = 1
				
				
				AND thread.forumid IN(Array)
				
				ORDER BY lastpost DESC
				LIMIT 10;

MySQL Error  : Unknown column 'Array' in 'where clause'
Error Number : 1054

Last edited by ludachris; 10-18-2007 at 06:04 PM.
Reply With Quote
  #2  
Old 10-18-2007, 06:12 PM
ludachris ludachris is offline
Senior Member
 
Join Date: Oct 2005
Posts: 184
Default Re: Just upgraded and am getting this error

Actually, I found the module that was breaking it. Thing is, in the diagnostics tool it shows the file as being okay. ????
Reply With Quote
  #3  
Old 10-18-2007, 06:24 PM
ludachris ludachris is offline
Senior Member
 
Join Date: Oct 2005
Posts: 184
Default Re: Just upgraded and am getting this error

Got it fixed, but still strange that the diagnostics showed the file as okay.
Reply With Quote
  #4  
Old 10-18-2007, 07:23 PM
Brian's Avatar
Brian Brian is offline
Administrator
 
Join Date: Jan 2004
Location: Georgia, USA
Posts: 34,240
Default Re: Just upgraded and am getting this error

Was this from the default recent threads module? Was it a copy, or was there anything else unusual about it?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
upgraded and now get Database error plz help Essex-Poker.co.uk Troubleshooting & Problems 2 05-31-2007 02:17 AM
Upgraded to 3.5 - get fatal error message HormZ Troubleshooting & Problems 1 10-21-2005 10:09 AM
I upgraded but got this error threatrr Troubleshooting & Problems 2 09-18-2005 09:16 AM
Upgraded vB, error in vBa Caiman Troubleshooting & Problems 8 08-05-2005 03:20 PM
Upgraded VB and vBa, error on main page vtrac Troubleshooting & Problems 2 07-31-2005 03:13 PM


All times are GMT -4. The time now is 11:57 AM.

Forums Powered by vBulletin, Copyright ©2000-2009, Jelsoft Enterprises Ltd.
Please note that vBadvanced is in no way affiliated with Jelsoft Enterprises Ltd, nor will Jelsoft be able to provide any support for our products.