CMS Made Simple Forums

Hi,

When I attempt to load editcontent.php or siteprefs.php in the admin panel (there may be others) web browser never goes beyond "Transferring data from <site>". (it does not time out either).

I can't use debug, as the page never loads and the debug output is appended to it, unless I can have the output saved to a file. I will try just about anything to work out what is going on here so all suggestions are appreciated.

Many Thanks for reading this

--ccuser

##Additional Information

I'm running CMS Made Simple 1.9.4, the first in the 1.9 series to *almost* work for me! I did not have any luck with 1.9, 1.9.1, 1.9.2 or 1.9.3.
I'm using:
PHP: 5.2.6-1+lenny9 with Suhosin-Patch 0.9.6.2 (cgi-fcgi) (built: Aug 4 2010 05:59:13)
Database: MySQL Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2
Web Server: lighttpd-1.4.19 (ssl)

Prior to 1.9.4 (and after 1.8.2) page processing times where around 53 seconds, /lib/class/class.cms_tree_operations.php was being used to build a cms_content_tree of page_alias & content_id on each page load and with ~5000 rows in cms_content (pagelinks and content) this was responsible for about 99% of the page processing time. This no longer seems to happens in 1.9.4 (down to 0.3 seconds) but several parts of the admin panel no longer load.

Ok, I have managed to get a little further with this myself.

I disabled all my modules (sorry, forgot to include a list in my first post) that I could, I can't seem to disable modules with dependants.

editcontent.php does now load, in 44 seconds, looking at the debug log I found ~875 SQL queries between "get all content..." and "end get all content..." all following the pattern "SELECT * FROM cms_content WHERE content_id IN (<list of content id's>)". By running some of the queries myself it looks like the entire cms_content table is being read hierarchy level by hierarchy level (depth first). So the more content pages you have, and the more levels they are on, the longer this function will take to run.

I found the text of the debug messages in /lib/classes/class.contentoperations.inc.php using grep, they are part of &GetAllContent (lines 715-733).

Can anyone shed any light on why this is done when I edit a content page? for example, what's this information used for / why is it needed, would be a great start to understanding this.

My debug log also shows a 15 second gap between checking that I am logged in and getting the properties of the template for the page I wish to edit, but I don't yet know the cause of this. I will try and follow what is going on in the source and add some more debug messages to the suspect parts.

My Debug log from editcontent.php, with most of the repeating queries removed for clarity: http://www.cmsmadesimple.org/pastebin/4282.

My System information: http://www.cmsmadesimple.org/pastebin/4283

Thanks again to everyone reading this