Hi
I have a site hosted at Site5 that has been up and running for approximately 6 months. The site is for a running event and I have some custom db-tables to manage entries to the race. All results from previous years are stored in one table and I use a custom snippet to retrieve these results together with personal data from the user profiles. Each year is shown on a different resource via the same snippet and a parameter which tells the snippet what year to retrieve.
For some days ago, I found out that some of the resources gave a 404-error. It seems to be the resources that retrieves the most amount of rows from the database that has stopped working.
My error log is empty, at least from things that can be related to this.
Together with the support from Site5 we have increased the max_execution_time, max_input_time and memory_limit in php.ini with no luck. In the server error log, this message is shown: Premature end of script headers: index.php
I tried to upgrade modx from 2.2.0pl2 advanced to 2.2.2pl advanced to see if that helped. In the setup-process, after the configuration check in the beginning, I got the same error (404). I couldn't go through with the upgrade the normal way. By manually extracting the core.transport.zip and then run the CLI-advanced upgrade I managed to finish the upgrade. This did not solve the problem.
A live page that doesn't work is
http://www.prinsensminne.se/efter-loppet/resultat/resultat-2009.html and a page that should work is
http://www.prinsensminne.se/efter-loppet/resultat/resultat-2006.html.
PHP version: 5.3.8
MySQL version: 5.1.62-rel13.3-log
MySQL client API version: 5.0.96
Does anyone have any ideas where I should troubleshoot this? The snippet itself can most certain be more optimized but it has worked before and I haven't changed it for quite some time and as I said, I got the same problem with the modx setup script.
Best regards
Kristoffer
[ed. note: Kristoffer last edited this post 14 years, 4 months ago.]
