Welcome to Geeklog, Anonymous Monday, March 10 2025 @ 09:43 pm EDT
Geeklog Forums
sql error
Status: offline
Imaginate
Forum User
Chatty
Registered: 12/03/03
Posts: 41
Hi the site is www.whitfield.tk
This is the SQL error im getting. Any thoghts on how to correct it?
Thu May 20 18:32:59 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 'slog') AND (perm_anon >= 2)' at line 1. SQL in question: SELECT count(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date = 2)
This is the SQL error im getting. Any thoghts on how to correct it?
Thu May 20 18:32:59 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 'slog') AND (perm_anon >= 2)' at line 1. SQL in question: SELECT count(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date = 2)
11
15
Quote
Status: offline
Imaginate
Forum User
Chatty
Registered: 12/03/03
Posts: 41
I found it... the client was adding a new topic and called a topic id geeklog didnt like the apostrophe so it crashed... changed it back in phpadmin , all fixed now.. hope that can help someone else if you hit an sql error that crashes your site.
Garnet
Garnet
11
11
Quote
All times are EDT. The time is now 09:43 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