Hi all, I've started to get a 500 error on a well-established blog (over 7000 entries) when I click on the link to list entries in the control panel. It only occurs on this blog, and not the smaller blog I just started.
Any ideas? This an MT issue, database issue, host issue? I'm not even sure where to begin. I can go through the entries one-by-one by clicking an entry in blog overview and working backwards, but this is obviously problematic if I ever have to edit or delete entry...6000 for instance. I'd also like to correct it if there's some sort of creeping error.
Many thanks.
Log's not telling me much other than:
Premature end of script headers: /home/solomon/public_html/cgi-bin/mt/mt.cgi
...btw
Full Version: 500 Errors When Trying To List Entries
Have you changed the number of rows you're wanting to display per page on the Entries or any other screen within the installation? The number of entries which will be displayed per page, via the Entries listing, is determined by the display options set via the 'Show Display Options' link on that page (which defaults to 20 rows). Entries are then paginated with the same number of entries per page. If this value is quite high, it is possible that you are seeing an error after doing so because your server has insufficient resources to allow all of the entries to be accessed in the database, and the results displayed. If you are not currently able to view the Entries screen, and thus access the 'Show Display Options' link, and need to change the amount of rows shown at once, you will need to delete the 'mt_list_pref' cookie set for your site (this stores that information), which will return you to the default options.
If not, then you'll want to check with your webhost for any additional information they can provide about the error you're seeing (such as memory limits/restrictions, change they've made). You should also back up your database and export entries, etc, in case you have some corrupted data in your database.
If not, then you'll want to check with your webhost for any additional information they can provide about the error you're seeing (such as memory limits/restrictions, change they've made). You should also back up your database and export entries, etc, in case you have some corrupted data in your database.
QUOTE (sarah @ Jul 1 2007, 11:13 PM) 
Have you changed the number of rows you're wanting to display per page on the Entries or any other screen within the installation? The number of entries which will be displayed per page, via the Entries listing, is determined by the display options set via the 'Show Display Options' link on that page (which defaults to 20 rows). Entries are then paginated with the same number of entries per page. If this value is quite high, it is possible that you are seeing an error after doing so because your server has insufficient resources to allow all of the entries to be accessed in the database, and the results displayed. If you are not currently able to view the Entries screen, and thus access the 'Show Display Options' link, and need to change the amount of rows shown at once, you will need to delete the 'mt_list_pref' cookie set for your site (this stores that information), which will return you to the default options.
If not, then you'll want to check with your webhost for any additional information they can provide about the error you're seeing (such as memory limits/restrictions, change they've made). You should also back up your database and export entries, etc, in case you have some corrupted data in your database.
If not, then you'll want to check with your webhost for any additional information they can provide about the error you're seeing (such as memory limits/restrictions, change they've made). You should also back up your database and export entries, etc, in case you have some corrupted data in your database.
You got it exactly right. I did indeed choose to show all rows -- I think in another blog -- and I didn't realize it would carry through between them. I just set it back down to 125 rows and all is well.
Thanks very much!! Well done.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.