Welcome to Geeklog, Anonymous Saturday, March 02 2024 @ 10:31 pm EST

Geeklog Forums

1064 error


Status: offline

ScottMcW

Forum User
Chatty
Registered: 09/22/02
Posts: 42
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

 Quote

All times are EST. The time is now 10:31 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content