PDA

View Full Version : New Post Error


JD210
01-16-2005, 08:31 PM
On both the vbadvanced portal, and on the welcome panel, where it lists the link for New Posts, I get the following error whenever I click on the link to show new posts. This doesn't happen if there are no new posts, but if there are new posts, then the below error shows up. Any ideas as to how to fix this. The link to my boards is: Vast Frontier (http://www.gothicgaming.com/forum/portal.php?)
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline,
thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid, thread.threaddesc
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM vb3thread AS thread
LEFT JOIN vb3user AS user ON(user.userid = thread.postuserid)
LEFT JOIN vb3subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
LEFT JOIN vb3post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(19, 18)
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 '.userid AS postuserid
, NOT ISNULL(subscribethread.subscrib

mysql error number: 1064

Marco van Herwaarden
01-17-2005, 03:19 AM
add a "," before user.userid:
, user.userid AS postuserid

JD210
01-17-2005, 06:23 PM
Where do I put it? Where do I find that phrase to add the "," to, and if it is MySQL, how do I edit it to add that?

Marco van Herwaarden
01-17-2005, 08:28 PM
Well i don't know which script generates this error, you should be able to tell us. I think you just installed some hack, best is to ask in the support thread of that hack, and not in the general php/sql section.