Freeze window after new page

[Kobes]

Maybe this problem has been discussed earlier, but I couldn't find it on the forum.

Whenever I add a new page which does not have a parent in the menu the cms hangs. The page does showup in the parsed version however. I am able to workaround the problem by manually editing the address bar and entering the usual admin link. I have found this error on two different pc's both running apache (version unknown to me at the moment), and mysql (v4.1.x.x). The version of cmsms I am using is 0.10.4

Does anyone recognise the problem and know a solution?

[Einar]

I might be having the same problem. When creating a new page, the page freezes and then times out after a while with the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in /hsphere/local/home/hoeggen/hoeggenskole.net/lib/classes/class.content.inc.php on line 1236

This is in function SetHierarchyPosition(). This happens both if I choose a parent menu item or none.

I'm running CMSMS v0.9.2, Apache (2.x), PHP v4.4.1 and MySQL (4.x).


Einar

[Einar]

Update:
When adding a page and NOT selecting a parent item, the page eventually shows up in the list of content, but without a menu hierarchy position (i.e. it is listed at the top without a hierarchy id, like "1.2.3"). It is not possible to move the page up or down in the hierarchy (by clicking the up and down arrows). I then get the same error:

Fatal error: Maximum execution time of 30 seconds exceeded in /hsphere/local/home/hoeggen/hoeggenskole.net/lib/classes/class.content.inc.php on line 1236


When adding a page and selecting a parent item, the page does not show up at all in the list of content.


Einar

[Ted]

This is showing up with 0.10.4?  That doesn't sound right at all.  That logic hasn't been changed in 5 months and no one has complained about it before.

[Einar]

I'm running CMSMS 0.9.2. But from what I can see the function SetHierarchyPosition() is unchanged between 0.9.2 and 0.10.4.

wishy, would you expect this problem to go away if I upgrade to 0.10.4?

-Einar

[Einar]

Some more information: This 0.9.2 installation has worked very well, but at some point these errors started showing up. I suspect this is because my provider upgraded one or more of Apache, MySQL, or PHP, or some libraries.

[Ted]

Unfortunately, if the parents or anything get out of sync, SetHierarchyPosition could get a little strange.  If there are any content items that don't have a hierarchy position set, you should probably edit them, change the parent, and hit save.  Then change it back.  That should reset any problems that would be arising.

[Einar]

OK, when looking at table cms_content through phpMyAdmin, I see that most rows have a hierarchy content (e.g. 00006.00001), while a few have no content in this field.

I delete some of them (in cms_content_props as well), and I set a valid hierarchy and parent_id for the rest of them.

All looks OK when listing content in the CMS.

When adding a new page, the same error is still there (but without an explicit error message after 30 secs this time, strange). When looking at table cms_content, I see that the new item does not have a hierarchy value.

Maybe there is some kind of database inconsistency here that I am unable to spot. Maybe I could export the database somehow (it's not very large)? Is that of any help for solving this problem?


-Einar

[Ted]

Yeah, that would be good.  Exporting through phpmyadmin or mysqldump would be good.  Then just email it to me and I'll try to take a look at it today.

[Einar]

OK, I've e-mailed the database dump to you now. Thanks for having a look!

-Einar

[Einar]

Hey wishy, have you had a chance to look at the database dump?

Thanks,
Einar

[Ted]

I missed the fact that you were running 0.9.2.  I'm going to have to install it at some point to do anything.  Time has been pretty limited.  I'll see what I can do.

[Einar]

Thanks, any light on this issue would be greatly appreciated.