FUDforum: Bug Reports » SQL Syntax problem

Home » FUDforum Development » Bug Reports » SQL Syntax problem

Show: Today's Messages :: Polls :: Message Navigator

SQL Syntax problem [message #20037]

Wed, 22 September 2004 20:54

rwest

Messages: 24
Registered: March 2002

Karma: 0

Junior Member

I have upgraded some time ago, but this was only just recently brought to my attention.

When users try to attach a file to their post, they are greeted wtih an error. Sad

When I look in the log, I see:
) 1064: 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 'AND id NOT IN(7))' at line 1
Query: DELETE FROM fud25_attach WHERE message_id=178 AND id NOT IN( AND id NOT IN(7))
Server Version: 4.0.21-standard

In looking a bit closer, you can see the error.. It's "AND id NOT IN( AND id NOT IN(7))". For some reason, it is repeating the "AND id NOT IN" part twice..

Is this a known problem, or is it an install issue on my end?

Report message to a moderator