Page 1 of 1

[SOLVED] Need help: Admin->Content->Pages does not show anything anymore

Posted: Sat Apr 18, 2009 7:29 am
by OlafNoehring
Hi

everything was fine until suddenly yesterday. I admit installing some things, but I can not explain this problem - so I am seeking your help:
When I go to Admin -> Content and want to list all my pages (-> Pages) ( http://..../admin/listcontent.php?_s_=4255789a) this (nothing!) shows up (as fas as I could see the rest of the admin and the page(s) themselves are just working fine!):
Image

Thanks already
--
* together for better software *
* http://www.team-noehring.de *

Re: Need help: Admin->Content->Pages does not show anything anymore

Posted: Sat Apr 18, 2009 8:09 am
by OlafNoehring
Hi

additional information: When I switc on "debug" (in config.php) - it works - when I turn debug off again - it does not work anymore!

Olaf

--
* together for better software *
* http://www.team-noehring.de *

Re: Need help: Admin->Content->Pages does not show anything anymore

Posted: Sat Apr 18, 2009 8:22 am
by OlafNoehring
Hi

simillar problem at
http://forum.cmsmadesimple.org/index.ph ... 869.0.html

But I can not solve mine the way described there.

Last server access log from when debug=true:
81.173.253.140 - olaf [18/Apr/2009:10:25:39 +0200] "GET /php/cmsmadesimple/admin/themes/default/images/icons/system/contractall.gif HTTP/1.1" 304 - "http://www.team-noehring.de/php/cmsmade ... _=4255789a" "Opera/10.00 (Windows NT 5.1; U; en) Presto/2.2.0"
Last server access log from when debug=false:
81.173.253.140 - - [18/Apr/2009:10:32:20 +0200] "GET /favicon.ico HTTP/1.1" 304 - "http://www.team-noehring.de/php/cmsmade ... _=4255789a" "Opera/10.00 (Windows NT 5.1; U; en) Presto/2.2.0"
- it's like cmsms simply stops requesting the page!


This btw is the complete output of the debug=true when I go to Admin->Content->Pages
Debug: (3.7999999999982E-5) - (758368)
loading smarty
Debug: (0.004123) - (1020624)
loading adodb
Debug: (0.0057459999999999) - (1105908)
loading page functions
Debug: (0.0088419999999999) - (1271176)
loading content functions
Debug: (0.012052) - (1480120)
loading pageinfo functions
Debug: (0.012757) - (1509340)
loading translation functions
Debug: (0.013275) - (1528092)
loading events functions
Debug: (0.014578) - (1612264)
loading php4 entity decode functions
Debug: (0.01674) - (1816340)
done loading files
Debug: (0.035859) - (2514120)

(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs
Error (0):
Debug: (0.041347) - (2612756)

(mysql): SELECT * FROM cms_userplugins
Error (0):
Debug: (0,077635) - (3405788)

(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name
Error (0):
Debug: (0,143683) - (6620368)
Session found.  Moving on...
Debug display of 'End of include':(0,166536) - (7843664)
Debug: (0,16743) - (7824180)
Session found.  Moving on...
Debug: (0,167483) - (7824180)
Session found.  Moving on...
Debug: (0,178233) - (8504632)
Session found.  Moving on...
Debug: (0,178751) - (8507952)

(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'
Error (0):
Debug: (0,178906) - (8509128)
Session found.  Moving on...
Debug: (0,180337) - (8600112)
Session found.  Moving on...
Debug: (0,18262) - (8677228)

(mysql): SELECT ug.user_id FROM cms_user_groups ug
                     WHERE ug.user_id = '1' AND ug.group_id = 1
Error (0):
Debug: (0,183162) - (8679836)

(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id INNER JOIN cms_groups gr ON gr.group_id = ug.group_id WHERE ug.user_id = '1' AND gr.active = 1
Error (0):
Debug: (0,186055) - (8698892)
Session found.  Moving on...
Debug: (0,189583) - (8725940)
Session found.  Moving on...
Debug: (0,189957) - (8734172)
Session found.  Moving on...
Debug: (0,190217) - (8734472)
Session found.  Moving on...
Debug: (0,193753) - (8753492)
Session found.  Moving on...
Debug: (0,194104) - (8753664)
Session found.  Moving on...
Debug: (0,202811) - (8858252)
Session found.  Moving on...
Debug: (0,203061) - (8858356)
Session found.  Moving on...
Debug: (0,205741) - (8869144)
Session found.  Moving on...
Debug: (0,211029) - (8888664)
Session found.  Moving on...
Debug: (0,211288) - (8888916)
Session found.  Moving on...
Debug: (0,211655) - (8890764)
Session found.  Moving on...
Debug: (0,214087) - (8899288)
Session found.  Moving on...
Debug: (0,221599) - (9010924)

(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'
Error (0):
Debug: (0,221971) - (9012636)

(mysql): SELECT group_id FROM cms_user_groups WHERE user_id = '1'
Error (0):
Debug: (0,222267) - (9013344)

(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id IN (-1)
Error (0):
Debug: (0,223056) - (9013672)

(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'
Error (0):
Debug: (0,224328) - (9020948)

(mysql): SELECT user_id,content_id FROM cms_additional_users
Error (0):
Debug: (0,231589) - (9129520)
Session found.  Moving on...
Debug: (0,232682) - (9130700)

(mysql): SELECT count(news_id) FROM cms_module_news n
                   WHERE status != 'published'
                     AND (( IFNULL(end_time, '1970-01-01 01:00:01')  = '1970-01-01 01:00:01') OR (end_time > '2009-04-18 10:25:31'))
Error (0):
Debug: (0,233301) - (9130856)

(mysql): SELECT version from cms_version
Error (0):
Debug: (0,235466) - (9162816)

(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title
Error (0):
Debug display of 'Start Loading Hierarchy Manager':(0,236063) - (9126300)
Debug display of 'Load Content Operations':(0,236093) - (9126300)
Debug display of 'End Load Content Operations':(0,24241) - (9531976)
Debug display of 'starting tree':(0,242473) - (9532240)
Debug: (0,245885) - (9666076)

(mysql): SELECT id_hierarchy FROM cms_content ORDER BY hierarchy
Error (0):
Debug display of 'Start Loading Children into Tree':(0,246843) - (9682880)
Debug display of 'End Loading Children into Tree':(0,252091) - (9916452)
Debug: (0,252133) - (9916604)
Serializing...
Debug: (0,254726) - (9962604)

(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy
Error (0):
Debug display of 'ending tree':(0,259319) - (10200848)
Debug display of 'End Loading Hierarchy Manager':(0,259385) - (10199948)
Debug: (0,266624) - (10216984)
Session found.  Moving on...
Debug: (0,266691) - (10216984)
Session found.  Moving on...
Debug: (0,270823) - (10297844)

(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '53'
Error (0):
Debug: (0,271405) - (10302936)

(mysql): SELECT username, password, active, first_name, last_name, admin_access, email FROM cms_users WHERE user_id = '1'
Error (0):
Debug: (0,272678) - (10306592)

(mysql): SELECT * FROM cms_content WHERE parent_id = '70' ORDER BY hierarchy
Error (0):
Debug: (0,275096) - (10371708)

(mysql): SELECT * FROM cms_content WHERE parent_id = '140' ORDER BY hierarchy
Error (0):
Debug: (0,282961) - (10468236)

(mysql): SELECT * FROM cms_content WHERE parent_id = '151' ORDER BY hierarchy
Error (0):
Debug: (0,28537) - (10490384)

(mysql): SELECT * FROM cms_content WHERE parent_id = '72' ORDER BY hierarchy
Error (0):
Debug: (0,289971) - (10554140)

(mysql): SELECT * FROM cms_content WHERE parent_id = '69' ORDER BY hierarchy
Error (0):
Debug: (0,291921) - (10617424)

(mysql): SELECT * FROM cms_content WHERE parent_id = '183' ORDER BY hierarchy
Error (0):
Debug: (0,293529) - (10632956)

(mysql): SELECT * FROM cms_content WHERE parent_id = '119' ORDER BY hierarchy
Error (0):
Debug: (0,299111) - (10719412)

(mysql): SELECT * FROM cms_content WHERE parent_id = '122' ORDER BY hierarchy
Error (0):
Debug: (0,304268) - (10784968)

(mysql): SELECT * FROM cms_content WHERE parent_id = '121' ORDER BY hierarchy
Error (0):
Debug: (0,313555) - (11041524)

(mysql): SELECT * FROM cms_content WHERE parent_id = '134' ORDER BY hierarchy
Error (0):
Debug: (0,320311) - (11104160)

(mysql): SELECT * FROM cms_content WHERE parent_id = '156' ORDER BY hierarchy
Error (0):
Debug: (0,32443) - (11131596)

(mysql): SELECT * FROM cms_content WHERE parent_id = '194' ORDER BY hierarchy
Error (0):
Debug: (0,328303) - (11155984)

(mysql): SELECT * FROM cms_content WHERE parent_id = '120' ORDER BY hierarchy
Error (0):
Debug: (0,342396) - (11355040)

(mysql): SELECT * FROM cms_content WHERE parent_id = '173' ORDER BY hierarchy
Error (0):
Debug: (0,346126) - (11396676)

(mysql): SELECT * FROM cms_content WHERE parent_id = '80' ORDER BY hierarchy
Error (0):
Debug: (0,349712) - (11534220)

(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '16'
Error (0):
Debug: (0,351421) - (11551432)

(mysql): SELECT * FROM cms_content WHERE parent_id = '15' ORDER BY hierarchy
Error (0):
Debug: (0,352653) - (11571112)

(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '17'
Error (0):
Debug: (0,354192) - (11584952)

(mysql): SELECT * FROM cms_content WHERE parent_id = '219' ORDER BY hierarchy
Error (0):
Olaf

Re: Need help: Admin->Content->Pages does not show anything anymore

Posted: Sat Apr 18, 2009 8:40 am
by OlafNoehring
Hi

well, I was able to increase PHP memory to 32 MB - now everything works again.

(See similar post on http://forum.cmsmadesimple.org/index.ph ... 869.0.html )

Thx anyways
Olaf
--
* together for better software *
* http://www.team-noehring.de *

Re: [SOLVED] Need help: Admin->Content->Pages does not show anything anymore

Posted: Sat Apr 18, 2009 10:15 pm
by Dr.CSS
Please don't post these things twice, now I have to go back and delete that post and mine under it...