Welcome to Geeklog Thursday, January 23 2020 @ 10:16 pm EST

Geeklog Forums

Odd Error only for me?


Status: offline

jason559

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

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

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

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

jason559

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

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

jason559

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

All times are EST. The time is now 10:16 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