Welcome to Geeklog, Anonymous Thursday, July 18 2024 @ 10:26 pm EDT

Geeklog Forums

An SQL error occured


Status: offline

trip

Forum User
Junior
Registered: 10/08/03
Posts: 25
confused
OK, I spent a long time working this install. I get to the final page, and I thought I beat the boss, but it's kicking my butt on the second level.

I get to the admin page, I change my password, I can even change my account settings, but once I go to the root level of the geeklog site online, i get "An SQL error has occured. PLease see errorlog for details."

Here are the details:
Mon Jul 19 01:37:23 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 '= gl_comments.sid) AND (gl_stories.draft_flag = 0) AND (tid IN . 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.draft_flag = 0) AND (tid IN ('GeekLog','General'))) LEFT JOIN gl_pollquestions ON ((qid = gl_comments.sid)) WHERE (gl_comments.date >= (DATE_SUB(NOW(), INTERVAL 172800 SECOND))) AND ((((gl_stories.owner_id IS NOT NULL AND gl_stories.perm_owner IS NOT NULL) OR (gl_stories.group_id IS NOT NULL AND gl_stories.perm_group IS NOT NULL) OR (gl_stories.perm_members IS NOT NULL))) OR (((gl_pollquestions.owner_id IS NOT NULL AND gl_pollquestions.perm_owner IS NOT NULL) OR (gl_pollquestions.group_id IS NOT NULL AND gl_pollquestions.perm_group IS NOT NULL) OR (gl_pollquestions.perm_members IS NOT NULL)))) GROUP BY gl_comments.sid ORDER BY 7 DESC LIMIT 15


This is a fresh install as well

Running OS X 10.3.4 server, using it's distributed mysql and php, installed phpmyadmin 2.5.3 running MySQL 4.0.18.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Is this on MacOS X (Server)? If so, see here for one of the previous discussions.

bye, Dirk
 Quote

Status: offline

trip

Forum User
Junior
Registered: 10/08/03
Posts: 25
happy
Well that worked!
Thanks.

FYI, it was a clean install of 1.3.9sr1.
 Quote

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