Geeklog Forums

I got an email from a perturbed user: \"Want to know why no one adds comments to your stories? BECAUSE THE COMMENTS DON\'T WORK!!! Sheeesh!\" Doh! He\'s right. When clicking on Post a Comment, (on my site: kenoshaonline.net) I get: 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 Any clues?

---

John Nordquist,
Applications Specialist, medical Technologies

Please post the corresponding entry from Geeklog\'s error.log bye, Dirk

Sat Sep 6 13:49:18 2003 - 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: DELETE FROM gl_commentspeedlimit WHERE date "lessthan" unix_timestamp "open parenthesis" "close parenthesis"

(sorry - the line from WHERE above to end would not paste in this forum editor)

---

John Nordquist,
Applications Specialist, medical Technologies

Is this is a 1.3.8 or 1.3.8-1 install, upgraded from 1.3.7 or earlier? The gl_commentspeedlimit table was replaced by gl_speedlimit in 1.3.8 and it seems you did not replace all the files with the 1.3.8 versions (specifically, the comment.php). bye, Dirk

I downloaded 1.3.8-1 and ran the install and selected the UPGRADE option, and got the success page, but the version check still says: The current version of Geeklog is 1.3.8-1 but it seems you are running Geeklog 1.3.7sr2 and comments still don\'t work (with the same error)

---

John Nordquist,
Applications Specialist, medical Technologies

The version number is in the config.php. So if you upgraded and didn\'t change your config.php, that is why the version is different. Do you have the centerblock functionality? Major change in 1.3.8. Standard tables for base install. 1.3.8-1 gl_access gl_article_images gl_blocks gl_commentcodes gl_commentmodes gl_comments gl_cookiecodes gl_dateformats gl_events gl_eventsubmission gl_featurecodes gl_features gl_frontpagecodes gl_group_assignments gl_groups gl_links gl_linksubmission gl_maillist gl_personal_events gl_plugins gl_pollanswers gl_pollquestions gl_pollvoters gl_postmodes gl_sessions gl_sortcodes gl_speedlimit gl_staticpage gl_statuscodes gl_stories gl_storysubmission gl_topics gl_tzcodes gl_usercomment gl_userindex gl_userinfo gl_userprefs gl_users gl_vars

I don\'t see a centerblock function. no. I do have the tables listed tho.

---

John Nordquist,
Applications Specialist, medical Technologies

As I said, I think you didn't upload a few of the 1.3.8-1 files when you upgraded. comment.php, for example, should have this Id line for the 1.3.8-1 version: If, however, it says v 1.38 in that line, then you still have the 1.3.7sr2 version of that file. bye, Dirk

// $Id: comment.php,v 1.44 2003/06/25 08:39:02 dhaun Exp $

it is the correct version. and I still get the error:

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

and the error.log entry:

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: DELETE FROM gl_speedlimit WHERE (type = 'comment' AND (date < unix_timestamp() - )

---

John Nordquist,
Applications Specialist, medical Technologies

No, it\'s another error now (note the table name: gl_speedlimit instead of gl_commentspeedlimit). Hmm, seems like the \'commentspeedlimit\' setting in your config.php is missing (or is empty). Please check $_CONF[\'commentspeedlimit\'] bye, Dirk

You\'re the greatest. Thanks. It was the config.php somehow the commentspeed line was split into 2 lines. Rejoined it and it works. Thanks a million!

---

John Nordquist,
Applications Specialist, medical Technologies