Posted on: 06/13/04 07:21pm
By: jason559
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?
Odd Error only for me?
Posted on: 06/14/04 02:24pm
By: Dirk
[QUOTE BY= jason559] 'Incoming LIMIT 100' at line 1[/QUOTE]
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
Odd Error only for me?
Posted on: 06/14/04 04:49pm
By: Anonymous (jason559)
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.
Odd Error only for me?
Posted on: 06/14/04 04:59pm
By: Dirk
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
Odd Error only for me?
Posted on: 06/14/04 05:02pm
By: jason559
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.
Odd Error only for me?
Posted on: 06/14/04 05:15pm
By: Dirk
[QUOTE BY= jason559] When I click on any story that is what appears, in it's entirety.[/QUOTE]
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
Odd Error only for me?
Posted on: 06/14/04 10:20pm
By: jason559
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