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

mholt · 10-26-2005, 08:12 PM

Hi,

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

Quote:

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:

PHP Code:

  $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

mholt · 10-28-2005, 03:59 PM

*cough cough*

Okay I found a way around it, nevermind.

10-28-2005, 03:59 PM	#2 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	cough cough Okay I found a way around it, nevermind. __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)