Page 1 of 1

Problems with new comments

Posted: Tue Jun 06, 2006 1:50 pm
by cybermat
Hi,

i moved my blog to a new provider, and after a few problems in the beginning, now it works so far. There is only one bad error, that i dont't understand. When i comment an entry, i recivieve the notification per mail, i see the article with the message: "Kommentar wurde hinzugefügt." (comment added) but there is no comment.
When i check the database there are no new sets in the comments table, but the counter for the comments of the entry counts up. i get no error messages, which can help finding the problem.
Another behavior that i can recognize, is an "Error 500" from the apache.

I don't know, what's so different between the to webspaces, that the first works fine, and the other not.
The only difference i know is the php-Version:
old: 5.1.4, works fine
new: 4.4.2, get errors

Any ideas?

Thanks,

Mat

Re: Problems with new comments

Posted: Tue Jun 06, 2006 2:06 pm
by garvinhicking
Hi!

An error 500 from the webserver means some specific errors that need to be investigated. Please ask your system provider to check the apache error and php error logfiles for more information on that specific error.

Best regards,
Garvin

Posted: Wed Jun 07, 2006 4:22 pm
by cybermat
My Provider cant't help me. They say, they don't log such errors. :(

I've searched a long time and noticed:

* I only get the server-Error when i try to comment, and have a cookie from my old installation (s9y on my old webspace, from which i moved) on my pc. In that case, i don't see the captchas, when i post a comment (but they are configured!). I receive the mail about the new comment, but since that moment i get the server error, when i try to whatch that entry in my browser. No new record in the comment table.

* When i delete the cookies from my pc and try to comment an entry, i see the captchas and after entering them, i get the message, that my comment has been saved, but there's no new comment! No new set in the comments table. Also in that case i receive an notification email about a new comment. But now, i get no Server-Error!

* When i have a cookie from my blog on the old webspace and turn the captchas off in the new installation, i also get no errors, but no comment will be saved.

So, i only get the error with an old cookie and captchas on, but in no case the commnet will be saved in the db. I don't even get an sql-error-msg.

The support of my hoster gave me the advice, that the error could come from a long runningtime or too high memory requirement of the script. i don't believe this. They also wrote, that the error could be caused of a script, that have no return value. Could this be a reason, when i can't enter captchas although they are configured?

Perhaps anyone has an idea....

Thanks,

mat

Posted: Wed Jun 07, 2006 6:58 pm
by garvinhicking
Hi!

Wow, what kind of crap provider is that that's not logging errors? :-)

About the captchas: For logged-in authors they are now hidden by default. You might want to temporarily remove your spamblock plugin and see if comment submission works then. And you might want to enable the loggin to file or database of the spamblock plugin and then see if maybe your comment is getting blocked.

A "500 Server error" can mean so many things, but it usually hints at server errors. Ask your provider if they're running mod_security or something like that.

Which s9y version are you using?

regards,
Garvin

Posted: Thu Jun 08, 2006 10:20 am
by cybermat
Yes, i can't believe this, too.

I've tried a view things and got an SQL-Error at last. Because of this error i recognized, that there are no autoincement fields in the tables that uses autoincrement ids. Don't ask me why. When i made the export from my old db i choosed "add autoincement-value".

I added autoincement manually to those tables which use them and now all works fine. Could this be a mySQL-Bug in the Export functionality?

Posted: Thu Jun 08, 2006 12:15 pm
by garvinhicking
Hi!

Good catch :)

Checking the "add autoincrement" value only addsthe current value of autoincrement keysto the export, but NOT the keys themselves. So it seems this property got lost in your export...

Bestregards,
Garvin