Geeklog Forums

I've seen lots of topics regarding this error (or very similar to it) but I still haven't seen a fix posted.

I'm getting this error when I try to look at submitted stories:

1064: You have an error in your SQL syntax near 'where ID=1036780369' at line 1

This is happening on moderation.php. The error log shows this message:

Tue Nov 12 01:40:39 2002 - 1064: You have an error in your SQL syntax near 'where ID=1036780369' at line 1 SQL in question: SELECT Category FROM where ID=1036780369

which looks to ME like it's missing the "FROM" info.

Looking through moderation.php I think that this is the pertinent code:

$sql = "SELECT sid AS id,title,UNIX_TIMESTAMP(date) AS day,tid FROM {$_TABLES['storysubmission']} ORDER BY date ASC";

Which looks like it has the "FROM" info {$_TABLES['storysubmission']}.

Any ideas?

Thanks!
Scott