Geeklog Forums

getting occasional SQL errors that appear related to the sp & filemgmt plugins. any idea what's happening here?

Mon Apr 12 17:32:47 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 'Conner%' OR sp_content like 'Flannery O'Conner%' OR sp_content . SQL in question: SELECT *,UNIX_TIMESTAMP(sp_date) as day FROM gl_staticpage WHERE (sp_php != '1' AND((sp_content like '%Flannery O'Conner%' OR sp_content like 'Flannery O'Conner%' OR sp_content like '%Flannery O'Conner' OR (sp_title like '%Flannery O'Conner%' OR sp_title like 'Flannery O'Conner%' OR sp_title like '%Flannery O'Conner')) ORDER BY sp_date desc

Mon Apr 12 19:02:54 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 '' at line 1. SQL in question: SELECT pid, title FROM gl_filemgmt_category WHERE cid=

Mon Apr 12 19:03:04 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 '' at line 1. SQL in question: SELECT pid, title FROM gl_filemgmt_category WHERE cid=

Mon Apr 12 19:03:21 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 '' at line 1. SQL in question: SELECT pid, title FROM gl_filemgmt_category WHERE cid= Mon Apr 12 19:03: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 '' at line 1. SQL in question: SELECT pid, title FROM gl_filemgmt_category WHERE cid=

Mon Apr 12 19:03:25 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 '' at line 1. SQL in question: SELECT pid, title FROM gl_filemgmt_category WHERE cid=