Welcome to Geeklog, Anonymous Friday, April 26 2024 @ 02:04 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)

 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
 Quote

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