Welcome to Geeklog, Anonymous Friday, December 06 2024 @ 06:44 am EST
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)
9
14
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
8
9
Quote
All times are EST. The time is now 06:44 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