vBadvanced Forums  
Go Back   vBadvanced Forums > vBadvanced Products > vBadvanced CMPS > vBa CMPS v3.0 Support > "How Do I..." Questions

Reply
 
Thread Tools Display Modes
  #1  
Old 08-15-2007, 03:37 AM
Lighthousedude Lighthousedude is offline
Junior Member
 
Join Date: Feb 2007
Posts: 3
Default DATEBASE ERROR!! On New Upgrade!

Well I Was Only Upgrading To The Latest CMPS and I Got A DateBase Error On My Site.


Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, threadid, firstpostid FROM thread AS thread
WHERE visible = 1 AND open != 10 AND thread.forumid IN(Array)

ORDER BY sticky DESC,dateline DESC
LIMIT 6;

MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Date : Wednesday, August 15th 2007 @ 03:30:29 AM
Script : http://www.vmkisland.com/
Referrer :
IP Address : Username :
Classname : vb_database
I Backed Everything Up But Now My Homepage Is Empty

Last edited by Lighthousedude; 08-15-2007 at 04:00 AM.
Reply With Quote
  #2  
Old 08-15-2007, 09:41 AM
Brian's Avatar
Brian Brian is offline
Administrator
 
Join Date: Jan 2004
Location: Georgia, USA
Posts: 34,240
Default Re: DATEBASE ERROR!! On New Upgrade!

http://www.vbadvanced.com/forum/show...light=database
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
3.6.1 upgrade error chorton58 Troubleshooting & Problems 0 09-30-2006 02:39 PM
DB Error after upgrade! HELP! yannisc Troubleshooting & Problems 1 09-15-2006 02:12 PM
Got an error after upgrade... titodj Troubleshooting & Problems 1 02-23-2006 12:08 AM
Upgrade Error am-fs Troubleshooting & Problems 1 10-29-2005 09:24 PM
Got error after upgrade to 1.0.1 coolman Troubleshooting / "How do I..." Questions 2 01-31-2005 12:58 PM


All times are GMT -4. The time now is 02:25 PM.

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.