Forum Subject: Posting Comments to stories
Posted on: 09/06/03 02:04pm
By: jnordquist
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?
Re:Posting Comments to stories
Posted on: 09/06/03 02:15pm
By: Dirk
Please post the corresponding entry from Geeklog\'s error.log
bye, Dirk
Re:Posting Comments to stories
Posted on: 09/06/03 02:50pm
By: jnordquist
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)
(sorry - the line from WHERE above to end would not paste in this forum editor)
Re:Posting Comments to stories
Posted on: 09/06/03 03:07pm
By: Dirk
[QUOTE BY= jnordquist]DELETE FROM gl_commentspeedlimit[/QUOTE]
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
Re:Posting Comments to stories
Posted on: 09/06/03 04:57pm
By: jnordquist
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)
Re:Posting Comments to stories
Posted on: 09/06/03 05:03pm
By: DTrumbower
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
Re:Posting Comments to stories
Posted on: 09/06/03 05:07pm
By: jnordquist
I don\'t see a centerblock function. no. I do have the tables listed tho.
Re:Posting Comments to stories
Posted on: 09/06/03 05:12pm
By: Dirk
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:
// $Id: comment.php,v 1.44 2003/06/25 08:39:02 dhaun Exp $v 1.38 in that line, then you still have the 1.3.7sr2 version of that file.
bye, DirkRe:Posting Comments to stories
Posted on: 09/06/03 05:26pm
By: jnordquist
// $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() - )
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 1and 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() - )Re:Posting Comments to stories
Posted on: 09/06/03 05:39pm
By: Dirk
[QUOTE BY= jnordquist]and I still get the error:[/QUOTE]
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
Re:Posting Comments to stories
Posted on: 09/06/03 06:17pm
By: jnordquist
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!