Posted on: 11/02/03 05:44pm
By: jnordquist
Still having comments problems and can't find a solution.
A user tries to leave a comment on a story. It works, they post it.
Nothing shows up on submissions.
If I go to MySql (phpMyAdmin) I do find the comment.
Nothing, however, shows in comment submission and the only way I can get the comment to show is to manually enter it using phpMyAdmin.
Re:Comments, revisited
Posted on: 11/03/03 02:06pm
By: Dirk
[QUOTE BY= jnordquist] A user tries to leave a comment on a story. It works, they post it.
Nothing shows up on submissions.[/QUOTE]
Not sure what you expect. Comments are posted directly, they are not going into a submission queue.
bye, Dirk
Re:Comments, revisited
Posted on: 11/04/03 01:34pm
By: jnordquist
But they're not going anywhere else either. Just into the database, but not displayed in geeklog.
Re:Comments, revisited
Posted on: 11/04/03 02:02pm
By: Dirk
I see.
Hmm, not sure how that could happen. Are we talking about http://KenoshaOnline.net (which, btw, you spelled wrong in your profile)? I see comments there ...
bye, Dirk
Re:Comments, revisited
Posted on: 11/04/03 02:15pm
By: jnordquist
Yes, the comments are either admin comments or ones I had to go through myPHPadmin to include.
Thanks
Re:Comments, revisited
Posted on: 11/04/03 02:22pm
By: Turias
I'm confused. You say the comment doesn't show up on the page, but does show up in phpMyAdmin if a user submits a comment. But then you say that the comment will show up on the webpage if you enter it manually through phpMyAdmin.
But you just said it already is in phpMyAdmin. So, how are you entering it if it is already there? There must be something different between the entry in the database that is entered automatically and the one you are entering manually.
Re:Comments, revisited
Posted on: 11/04/03 02:43pm
By: jnordquist
It is confusing. If an anonymous user leaves a comment , the comment will not show up in GL. If I look at the GL stats I see that Anonymous left the comment. I can not see the comment anywhere though.
At this point, I use phpMyAdmin to view the geeklog database (comments table) I can see the comment. Not within GL though.
Admin comments work.
Re:Comments, revisited
Posted on: 11/04/03 02:50pm
By: Turias
Could you show us two example entries in the actual database? I would like to see:
1. An anonymous comment not displaying itself on the webpage
2. An admin-posted comment that does display on the webpage.
Re:Comments, revisited
Posted on: 11/04/03 03:14pm
By: jnordquist
Now I'm real confused. For at least a week this situation plagued me. Now it's working and I cannot duplicate the error.
Here is an older entry though:
DID NOT WORK
INSERT INTO `gl_comments` VALUES (37, 'article', '20030711004643287', '2003-10-23 12:19:48', 'Some Words by George Carlin', 'this all you got!!!!!!!!!1', 0, 0, 0, 1);
WORKED
INSERT INTO `gl_comments` VALUES (45, 'article', '20031020184341254', '2003-11-02 17:29:09', 'Palestinian woman held in Kenosha County', 'I agree. The republic has always stood for protecting individuals not detention and exile. There is very little information available on Lina Daqa. All calls I\'ve made to determine her current status have been met with "we cannot confirm or deny..." The only thing I did get was a confirmation that she is still in custody and is awaiting a November 7th hearing in Chicago. There could be more than meets the eye here, but if there were, you can be sure the government would be telling us.<p>---<br>---John Nordquistjohn.nordquist@kenosha.ws', 0, 0, 44, 2);