[geeklog-users] An SQL error has occured

Chris Besignano chrisbesignano at sympatico.ca
Thu Feb 26 10:06:53 EST 2004


Hello,

I am runnning geeklog 1.3.8-lsr4 on linux. I attempted to add a new 
topic, but left a space in the topic id. Now I get this SQL error and 
cannot access any part of the site. What can I do to recover from this? 
Below is a section of my error log.


Thu Feb 26 09:51:31 2004 - 1064: You have an error in your SQL syntax 
near 'Journal')' at line 1. SQL in question: SELECT count(*) AS count 
FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW()) AND (tid = 
'Chris'Journal')
Thu Feb 26 09:51:46 2004 - 1064: You have an error in your SQL syntax 
near 'Journal')' at line 1. SQL in question: SELECT count(*) AS count 
FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW()) AND (tid = 
'Chris'Journal')
Thu Feb 26 09:51:52 2004 - 1064: You have an error in your SQL syntax 
near 'Journal')' at line 1. SQL in question: SELECT count(*) AS count 
FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW()) AND (tid = 
'Chris'Journal')
Thu Feb 26 09:51:56 2004 - 1064: You have an error in your SQL syntax 
near 'Journal')' at line 1. SQL in question: SELECT count(*) AS count 
FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW()) AND (tid = 
'Chris'Journal')




More information about the geeklog-users mailing list