Status: offline

jason559

Forum User
Regular Poster
Registered: 03/31/03
Posts: 83
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?

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Quote by jason559: 'Incoming LIMIT 100' at line 1

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

jason559

Anonymous
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.

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
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

Status: offline

jason559

Forum User
Regular Poster
Registered: 03/31/03
Posts: 83
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.

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Quote by jason559: When I click on any story that is what appears, in it's entirety.

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

Status: offline

jason559

Forum User
Regular Poster
Registered: 03/31/03
Posts: 83
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