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.

---

John Nordquist,
Applications Specialist, medical Technologies

Not sure what you expect. Comments are posted directly, they are not going into a submission queue.

bye, Dirk

But they're not going anywhere else either. Just into the database, but not displayed in geeklog.

---

John Nordquist,
Applications Specialist, medical Technologies

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

Yes, the comments are either admin comments or ones I had to go through myPHPadmin to include.

Thanks

---

John Nordquist,
Applications Specialist, medical Technologies

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.

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.

---

John Nordquist,
Applications Specialist, medical Technologies

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.

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);

---

John Nordquist,
Applications Specialist, medical Technologies