I use 1.6.5 version. first admin panel is very slow to open.and I can not add new pages, all modules can not work. when I click "pages", it show as below debug info:
Debug: (2.2E-5) - (1327920)
loading smarty
Debug: (0.003276) - (1764960)
loading adodb
Debug: (0.004297) - (1904760)
loading page functions
Debug: (0.006407) - (2186488)
loading content functions
Debug: (0.008289) - (2503192)
loading pageinfo functions
Debug: (0.008702) - (2557768)
loading translation functions
Debug: (0.009057) - (2586520)
loading events functions
Debug: (0.00997) - (2719840)
loading php4 entity decode functions
Debug: (0.011422) - (3050848)
done loading files
Debug: (0.019793) - (4159728)
(mysql): SET NAMES 'utf8'
Error (0):
Debug: (0.020106) - (4187888)
(mysql): SELECT sitepref_name, sitepref_value from dataherb_siteprefs
Error (0):
Debug: (0.022268) - (4327224)
(mysql): SELECT * FROM dataherb_userplugins
Error (0):
Debug: (0.034653) - (5343544)
(mysql): SELECT * FROM dataherb_modules WHERE active = 1 ORDER by module_name
Error (0):
Debug display of 'End of include':(0.048797) - (8009232)
Debug: (0.059521) - (7980784)
Session found. Moving on...
Debug: (0.059566) - (7980784)
Session found. Moving on...
Debug: (0.157169) - (9887184)
Session found. Moving on...
Debug: (0.157528) - (9891904)
(mysql): SELECT preference, value FROM dataherb_userprefs WHERE user_id = '1'
Error (0):
Debug: (0.157663) - (9892784)
Session found. Moving on...
Debug: (0.158856) - (10057296)
Session found. Moving on...
Debug: (0.159902) - (10181904)
(mysql): SELECT ug.user_id FROM dataherb_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1
Error (0):
Debug: (0.16007) - (10186032)
(mysql): SELECT DISTINCT permission_name FROM dataherb_user_groups ug INNER JOIN dataherb_group_perms gp ON gp.group_id = ug.group_id INNER JOIN dataherb_permissions p ON p.permission_id = gp.permission_id INNER JOIN dataherb_groups gr ON gr.group_id = ug.group_id WHERE ug.user_id = '1' AND gr.active = 1
Error (0):
Debug: (0.16104) - (10276200)
Session found. Moving on...
Debug: (0.161614) - (10317512)
Session found. Moving on...
Debug: (0.162035) - (10330712)
Session found. Moving on...
Debug: (0.162506) - (10350872)
Session found. Moving on...
Debug: (0.163435) - (10419024)
Session found. Moving on...
Debug: (0.163836) - (10427336)
Session found. Moving on...
Debug: (0.16421) - (10438120)
Session found. Moving on...
Debug: (0.16456) - (10446168)
Session found. Moving on...
Debug: (0.166147) - (10610696)
(mysql): SELECT htmlblob_id FROM dataherb_additional_htmlblob_users WHERE user_id = '1'
Error (0):
Debug: (0.166288) - (10612560)
(mysql): SELECT group_id FROM dataherb_user_groups WHERE user_id = '1'
Error (0):
Debug: (0.166426) - (10613512)
(mysql): SELECT htmlblob_id FROM dataherb_additional_htmlblob_users WHERE user_id IN (-1)
Error (0):
Debug: (0.166582) - (10613720)
(mysql): SELECT content_id FROM dataherb_content WHERE owner_id = '1'
Error (0):
Debug: (0.166808) - (10615240)
(mysql): SELECT user_id,content_id FROM dataherb_additional_users
Error (0):
Debug: (0.17033) - (10758008)
Session found. Moving on...
Debug: (0.18182) - (10759984)
(mysql): SELECT count(news_id) FROM dataherb_module_news n
WHERE status != 'published'
AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2009-09-25 10:02:19'))
Error (0):
Debug: (0.182144) - (10761552)
(mysql): SELECT version from dataherb_version
Error (0):
Debug: (45.838572) - (11195912)
(mysql): SELECT sitepref_value from dataherb_siteprefs WHERE sitepref_name = 'cms_is_uptodate'
Error (2006): MySQL server has gone away
Debug: (45.83867) - (11196408)
(mysql): INSERT INTO dataherb_siteprefs (sitepref_name, sitepref_value) VALUES ('cms_is_uptodate', '0')
Error (2006): MySQL server has gone away
Debug: (45.838832) - (11196808)
(mysql): SELECT sitepref_value from dataherb_siteprefs WHERE sitepref_name = 'lastcmsversioncheck'
Error (2006): MySQL server has gone away
Debug: (45.838898) - (11197248)
(mysql): INSERT INTO dataherb_siteprefs (sitepref_name, sitepref_value) VALUES ('lastcmsversioncheck', '1253937595')
Error (2006): MySQL server has gone away
Debug: (45.839912) - (11252912)
(mysql): SELECT bookmark_id, user_id, title, url FROM dataherb_admin_bookmarks WHERE user_id = '1' ORDER BY title
Error (2006): MySQL server has gone away
Debug display of 'Start Loading Hierarchy Manager':(46.516448) - (11190736)
Debug display of 'Load Content Operations':(46.516499) - (11190736)
Debug display of 'End Load Content Operations':(46.522858) - (12036064)
Debug display of 'starting tree':(46.522892) - (12037048)
Debug: (46.524688) - (12261144)
(mysql): SELECT id_hierarchy FROM dataherb_content ORDER BY hierarchy
Error (2006): MySQL server has gone away
Debug display of 'Start Loading Children into Tree':(46.524761) - (12262112)
Debug display of 'End Loading Children into Tree':(46.524797) - (12264016)
Debug: (46.524817) - (12264248)
Serializing...
Debug display of 'ending tree':(47.081155) - (12265032)
Debug display of 'End Loading Hierarchy Manager':(47.081228) - (12265032)
Debug: (47.085913) - (12362840)
Session found. Moving on...
Debug: (47.085959) - (12363464)
Session found. Moving on...
when just enter admin panel, it shows below debug info:
ebug: (3.8E-5) - (891552)
loading smarty
Debug: (0.004033) - (1328824)
loading adodb
Debug: (0.005062) - (1468584)
loading page functions
Debug: (0.007493) - (1751312)
loading content functions
Debug: (0.009544) - (2067928)
loading pageinfo functions
Debug: (0.009974) - (2122448)
loading translation functions
Debug: (0.010283) - (2151080)
loading events functions
Debug: (0.011259) - (2284576)
loading php4 entity decode functions
Debug: (0.012678) - (2615432)
done loading files
Debug: (0.022835) - (3724936)
(mysql): SET NAMES 'utf8'
Error (0):
Debug: (0.023147) - (3752960)
(mysql): SELECT sitepref_name, sitepref_value from dataherb_siteprefs
Error (0):
Debug: (0.025678) - (3892064)
(mysql): SELECT * FROM dataherb_userplugins
Error (0):
Debug: (0.037671) - (4908440)
(mysql): SELECT * FROM dataherb_modules WHERE active = 1 ORDER by module_name
Error (0):
Debug display of 'End of include':(0.050792) - (7574400)
Debug: (0.05087) - (7508080)
Session found. Moving on...
Debug: (0.05505) - (8168912)
Session found. Moving on...
Debug: (0.055282) - (8175024)
(mysql): SELECT preference, value FROM dataherb_userprefs WHERE user_id = '1'
Error (0):
Debug: (0.055391) - (8176888)
Session found. Moving on...
Debug: (0.056368) - (8341648)
Session found. Moving on...
Debug: (0.057388) - (8467032)
(mysql): SELECT ug.user_id FROM dataherb_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1
Error (0):
Debug: (0.057538) - (8471040)
(mysql): SELECT DISTINCT permission_name FROM dataherb_user_groups ug INNER JOIN dataherb_group_perms gp ON gp.group_id = ug.group_id INNER JOIN dataherb_permissions p ON p.permission_id = gp.permission_id INNER JOIN dataherb_groups gr ON gr.group_id = ug.group_id WHERE ug.user_id = '1' AND gr.active = 1
Error (0):
Debug: (0.05852) - (8561600)
Session found. Moving on...
Debug: (0.059108) - (8602160)
Session found. Moving on...
Debug: (0.059506) - (8615384)
Session found. Moving on...
Debug: (0.059965) - (8634896)
Session found. Moving on...
Debug: (0.060846) - (8701472)
Session found. Moving on...
Debug: (0.061226) - (8710128)
Session found. Moving on...
Debug: (0.061597) - (8720712)
Session found. Moving on...
Debug: (0.061941) - (8728752)
Session found. Moving on...
Debug: (0.063515) - (8893344)
(mysql): SELECT htmlblob_id FROM dataherb_additional_htmlblob_users WHERE user_id = '1'
Error (0):
Debug: (0.063643) - (8895176)
(mysql): SELECT group_id FROM dataherb_user_groups WHERE user_id = '1'
Error (0):
Debug: (0.063763) - (8896128)
(mysql): SELECT htmlblob_id FROM dataherb_additional_htmlblob_users WHERE user_id IN (-1)
Error (0):
Debug: (0.0639) - (8896336)
(mysql): SELECT content_id FROM dataherb_content WHERE owner_id = '1'
Error (0):
Debug: (0.064096) - (8897520)
(mysql): SELECT user_id,content_id FROM dataherb_additional_users
Error (0):
Debug: (0.067241) - (9040744)
Session found. Moving on...
Debug: (0.067693) - (9042728)
(mysql): SELECT count(news_id) FROM dataherb_module_news n
WHERE status != 'published'
AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2009-09-25 10:12:07'))
Error (0):
Debug: (0.067901) - (9044264)
(mysql): SELECT version from dataherb_version
Error (0):
Debug: (45.719927) - (9478392)
(mysql): SELECT sitepref_value from dataherb_siteprefs WHERE sitepref_name = 'cms_is_uptodate'
Error (2006): MySQL server has gone away
Debug: (45.720032) - (9478888)
(mysql): INSERT INTO dataherb_siteprefs (sitepref_name, sitepref_value) VALUES ('cms_is_uptodate', '0')
Error (2006): MySQL server has gone away
Debug: (45.72017) - (9479288)
(mysql): SELECT sitepref_value from dataherb_siteprefs WHERE sitepref_name = 'lastcmsversioncheck'
Error (2006): MySQL server has gone away
Debug: (45.720237) - (9479728)
(mysql): INSERT INTO dataherb_siteprefs (sitepref_name, sitepref_value) VALUES ('lastcmsversioncheck', '1253937595')
Error (2006): MySQL server has gone away
Debug: (45.721221) - (9535512)
(mysql): SELECT bookmark_id, user_id, title, url FROM dataherb_admin_bookmarks WHERE user_id = '1' ORDER BY title
Error (2006): MySQL server has gone away
Debug: (45.721392) - (9473192)
(mysql): SELECT bookmark_id, user_id, title, url FROM dataherb_admin_bookmarks WHERE user_id = '1' ORDER BY title
Error (2006): MySQL server has gone away
I can use the admin well before the dns outage, after that, It can not work well, I waited several days to see if it can be solved, but it didn't. I haven't used cms made simple for long time -- about 2 months or so, and don't know how to deal with such problems. I reinstalled version 1.6.5 and 1.6.4 for several times and didn't confront problem in installation. But the admin panel still can not work normally.
admin panel can not work
Re: admin panel can not work
Can you please provide system information? Also is it only the admin that is slow or is the whole site slow.
Jeff
Jeff
Re: admin panel can not work
only admin section are slow, website are ok.
And I noticed that there are some error in mysql, such as:
(mysql): INSERT INTO dataherb_siteprefs (sitepref_name, sitepref_value) VALUES ('cms_is_uptodate', '0')
Error (2006): MySQL server has gone away
but the dataherb_siteprefs table exists in my database. I don't know how to correct it.
Any ideas?
And I noticed that there are some error in mysql, such as:
(mysql): INSERT INTO dataherb_siteprefs (sitepref_name, sitepref_value) VALUES ('cms_is_uptodate', '0')
Error (2006): MySQL server has gone away
but the dataherb_siteprefs table exists in my database. I don't know how to correct it.
Any ideas?
Re: admin panel can not work
It is a problem with your database connection timing out, ie hosting issue. Please contact your hosting provider for support.
Re: admin panel can not work
Thank you, Jeff! I will contact my hosting provider for support to see if the problem will be resolved.
