It's 10 PM and I'm debugging this 1,032 line file ...

[user-7256]

Hi,

I'm REALLYYYY tired right now and THIS error won't go away:

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 ') AS isRead FROM vdn1_messages WHERE ID_MSG IN (2) ORDER BY ID_
File: ****
Line: 676

Now, this is the query that's causing this:

$messages_request = db_query("
			SELECT
				ID_MSG, icon, subject, posterTime, posterIP, ID_MEMBER, modifiedTime, modifiedName, body,
				smileysEnabled, posterName, posterEmail, topicSolved, (GREATEST(posterTime, modifiedTime) > $topicinfo[logTime]) AS isRead FROM {$db_prefix}messages WHERE ID_MSG IN (" . implode(',', $messages) . ") ORDER BY ID_MSG" . (empty($options['view_newest_first']) ? '' : ' DESC'), __FILE__, __LINE__);

Anything wrong with this query that is causing this? I've been working on it for an hour now

Thanks,
-Matt

 

[user-7256]

*cough cough*

Okay I found a way around it, nevermind.