SQL errors!

[CosmicBlend]

When i changed cmps_index.php over to index.php and let my users on it. I get the following errors when users browse it, but when i browse it i dont get an email with the following errors. What can fix this problem?


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, forum.title AS forumtitle
, post.pagetext AS preview

FROM thread as thread

LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE open <> '10' AND thread.visible = 1 Array AND deletionlog.primaryid IS NULL
ORDER BY thread.dateline DESC
LIMIT 5

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 'Array AND deletionlog.primaryid IS NULL
ORDER BY thread.dateline DESC
LIMI' at line 13

mysql error number: 1064

[CosmicBlend]

It seems only to happen with select users.. i cant figure this problem out.

[mr.ciuk]

http://www.vbadvanced.com/forum/showthread.php?t=4936

and problem will be kill !!!!!

Bye bye !!!

[CosmicBlend]

thanks

[CosmicBlend]

ok im still having the problem... whats wrong?

[Brian]

If you apply the fix posted here it should take care of the problem.
http://www.vbadvanced.com/forum/show...97&postcount=7

[CosmicBlend]

I did try that fix and some users are getting errors still.. its not constant just select users.

[Brian]

Are they getting the exact same error?

[CosmicBlend]

yeah every user gets the exact same error, but only certain users get it. It doesnt seem to be a specific usergroup either.. just random users.

[Brian]

I'm not entirely sure what would be causing that then. If you'd like to submit a support ticket though I'll be glad to take a look.