Geeklog Forums

When I use IE on my computer I get this error when trying to view any stories:

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 'Incoming LIMIT 100' at line 1

But, when I use netscape or IE on another computer it works fine. Any suggestions?

Looks like this is coming from a plugin that you've installed on your site. Try disabling them one by one until you find out which one is causing this.

bye, Dirk

I had static pages turned on but that was it. I disabled it, but receive the same error. Very, Very strange. Since it only happens with my particular browser.

Can you quote the complete error message, please? I.e. including the actual SQL request (not only part of it).

There's no field named 'incoming' in Geeklog, so it must be coming from somewhere else, e.g. a plugin or some other add-on that you've installed.

bye, Dirk

I'm unsure how to do that. When I click on any story that is what appears, in it's entirety. If you have any instructions I can follow to provide that information I would certainly.

Hmm, which version of Geeklog is that? It should actually only say "An SQL error has occured - see error.log for details" (or words to that effect) and NOT display the error (or parts of it) in the browser.

Anyway, the complete error message, including the entire SQL statement, should be in Geeklog's error.log file.

bye, Dirk

Mon Jun 14 16:46:41 2004 - 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 'Incoming LIMIT 100' at line 1 SQL in question: SELECT *,unix_timestamp(date) AS nice_date FROM gl_comments WHERE sid = '20040613115036801' AND pid = 0 ORDER BY date Incoming LIMIT 100