Welcome to Geeklog, Anonymous Tuesday, October 04 2022 @ 07:17 am EDT

Geeklog Forums

1064 Error after successful install (again)?


Status: offline

davethegeek

Forum User
Newbie
Registered: 10/12/03
Posts: 3
Sorry for the 2 posts - not sure what happened to the first one. After a successful install, I am getting errors when loading the main geeklog page (i.e. geeklog.mydomain.com), and a peek at 'error.log' shows the following:

Sun Oct 12 14:51:39 2003 - 1064: You have an error in your SQL syntax near '= gl_comments.sid) AND (gl_stories.perm_anon >= 2) AND (gl_stories.draft_flag = ' at line 1 SQL in question: SELECT DISTINCT count(*) AS dups, type, question, gl_stories.title, gl_stories.sid, qid, max(gl_comments.date) as lastdate FROM gl_comments LEFT JOIN gl_stories ON ((.sid = gl_comments.sid) AND (gl_stories.perm_anon >= 2) AND (gl_stories.draft_flag = 0) AND (tid IN ('General','GeekLog'))) LEFT JOIN gl_pollquestions ON ((qid = gl_comments.sid) A
ND (gl_pollquestions.perm_anon >= 2)) WHERE (gl_comments.date >= (DATE_SUB(NOW(), INTERVAL 172800 SECOND))) AND ((((gl_stories.perm_anon IS NOT NULL))) OR (((gl_pollquestions.perm_anon IS NOT NULL)))) GROUP BY gl_comments.sid ORDER BY 7 DESC LIMIT 15

Anyone have any ideas? Many thanks.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
See this thread. Still not sure why and when that happens, though Confused

bye, Dirk
 Quote

Status: offline

davethegeek

Forum User
Newbie
Registered: 10/12/03
Posts: 3
Thanks for the link - fresh copy of the lib-common.php did not help. FWIW, I am also using Mac OS X (server version), which has MySQL v 3.23.53 installed.
 Quote

All times are EDT. The time is now 07:17 am.

  • 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