With debug on I wonder, if I get the error 500 there are no statements written to screen.
Yes I have tested with activ cache and with deactivated cache... same results=500.
What I don't understand: I' refresh for example the main site... 10 times it returns in some seconds (<3seconds) but then some returns after 10 seconds with error 500. The next refresh return the site under 3 seconds and so on. You can test it with my site.
first some good news: I think I have found a reason for error 500. I have reloaded an db backup which is 2 month old. After I have done this I couldn't reproduce ther error 500 as described above.
The bad news is, this won't help you... I think.
But I give another try. I wonder about the size of old backup.sql The newest backup.sql has a size around 4mb. The backup.sql I have restored has a size of 10mb and is 2 month of administration behind. In this time I have around 100 uinque visitors a day. The only reason for this 6mb data missing I found is a deleted email log in this time. I have looked into the newset db and there are no email log entries in there but I have got a lot emails about validation, new users etc. So I have tested to send some emails. The emails are sent but no entries will be seen in the admin interface email log. Then I have looked into the db directly via myphpadmin, there are only 2 line in table *_email but I have sent around 10 emails. There's something going wrong. If this is the resoan for error 500 I don't really know, but I will help you to find it out. At the moment googlebot is crawling my site and I think I will be back in serps in some weeks.
Email logs are automatically deleted after a selected number of days now, didn't used to be -- the old way of keeping them forever, in fact, caused slowness and potential 500 errors.
After restoring the old database, I can't reproduce the error 500. At the moment I'm happy googlebot is crawling my site without errors, and I hope to be back in serps in the next days or weeks.
If it only happened to guests or googlebot, are you sure you weren't using a load control mechanism like rejecting guests/spiders when the load is above a certain level (Admin -> Settings -> System)?
Both fields for load management are empty. But I described above in this tread I've got a lot of errors 500 while logged on as my admin user.
What's about my idee with the deletion of the email log? Could it be some impact with some users having the option active to get emails by all new catalog enries?
An email can cause a 500 error if its malformed, like not having a "to" address (but that's checked for by WSN), or maybe having some sort of illegal character. Are you using MIME formating.
The email table can play a role because it contains emails not yet sent as well as those sent -- the actual log of emails already sent can't play any role though.
Comments on Server 500 Error
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
Hi Paul,
I insert some Link... something normal.
With debug on I wonder, if I get the error 500 there are no statements written to screen.
Yes I have tested with activ cache and with deactivated cache... same results=500.
What I don't understand: I' refresh for example the main site... 10 times it returns in some seconds (<3seconds) but then some returns after 10 seconds with error 500. The next refresh return the site under 3 seconds and so on. You can test it with my site.
Regards,
Frank
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
here are some more tests:
mysql 5.0 => error 500
delete all notifies => error 500
delete all tags => error 500
But as described before... some pages are shown as soon as possible, but sometimes one page gets error 500
Is it possible to do a trace, so I can see whats running till the point of error 500?
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
Hi Paul,
first some good news: I think I have found a reason for error 500. I have reloaded an db backup which is 2 month old. After I have done this I couldn't reproduce ther error 500 as described above.
The bad news is, this won't help you... I think.
But I give another try. I wonder about the size of old backup.sql The newest backup.sql has a size around 4mb. The backup.sql I have restored has a size of 10mb and is 2 month of administration behind. In this time I have around 100 uinque visitors a day. The only reason for this 6mb data missing I found is a deleted email log in this time. I have looked into the newset db and there are no email log entries in there but I have got a lot emails about validation, new users etc. So I have tested to send some emails. The emails are sent but no entries will be seen in the admin interface email log. Then I have looked into the db directly via myphpadmin, there are only 2 line in table *_email but I have sent around 10 emails. There's something going wrong. If this is the resoan for error 500 I don't really know, but I will help you to find it out. At the moment googlebot is crawling my site and I think I will be back in serps in some weeks.
Regards,
Frank
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Email logs are automatically deleted after a selected number of days now, didn't used to be -- the old way of keeping them forever, in fact, caused slowness and potential 500 errors.
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
yes, but it seems that after deleteting them all, the error 500 comes. And something goes wrong after that, because no email is written to the log.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I don't see how deleting anything can cause a 500 error.
If you can actually reproduce this, then send me access to your server and the steps to make it happen and I can step through the files.
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
After restoring the old database, I can't reproduce the error 500. At the moment I'm happy googlebot is crawling my site without errors, and I hope to be back in serps in the next days or weeks.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If it only happened to guests or googlebot, are you sure you weren't using a load control mechanism like rejecting guests/spiders when the load is above a certain level (Admin -> Settings -> System)?
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
Both fields for load management are empty. But I described above in this tread I've got a lot of errors 500 while logged on as my admin user.
What's about my idee with the deletion of the email log? Could it be some impact with some users having the option active to get emails by all new catalog enries?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
An email can cause a 500 error if its malformed, like not having a "to" address (but that's checked for by WSN), or maybe having some sort of illegal character. Are you using MIME formating.
The email table can play a role because it contains emails not yet sent as well as those sent -- the actual log of emails already sent can't play any role though.
Forum Regular
Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany
Total Topics: 33
Total Comments: 106
I'm using plain text. After reading your post I remember I have seen one user account without having an email address.