View Full Version : Updated to 3.0, Pages give me a non valid page specifed message
easyskillz
09-04-2007, 09:24 AM
It just won't display my cmps pages...wierd.
Here is an example :
http://www.maroceve.com/index.php?page=testing
easyskillz
09-04-2007, 10:06 AM
nevermind ...FlashFXP really sucks i dunno why it didn't uploda the file correctly
i used fireftp. but now i have other problems...ill be back with an update
easyskillz
09-04-2007, 10:13 AM
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,
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, thread.lastpostid, pollid, thread.forumid
, thread.iconid AS threadiconid, iconpath AS threadiconpath, post.pagetext AS preview
FROM thread as thread
LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10 AND thread.visible = 1
AND thread.lastpost > 1188051175
AND thread.forumid IN(Array)
ORDER BY thread.dateline DESC
LIMIT 6;
MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Date : Tuesday, September 4th 2007 @ 09:12:59 AM
Script : http://www.maroceve.com/index.php?page=homeve
Referrer : http://www.maroceve.com/index.php?page=Articles
IP Address : 196.217.213.230
Username : Ez
Classname : vb_database
easyskillz
09-04-2007, 10:26 AM
it's one of my modules, i am troubleshooting to see where it s coming from
easyskillz
09-04-2007, 10:51 AM
Allright, came from the news module ...wierd...will see why now.
sorry for this post, u can delete it. thanks
Brian
09-04-2007, 11:19 AM
Looks more like the recent threads module actually...
http://www.vbadvanced.com/forum/showthread.php?t=22043&highlight=database
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.