Page 1 of 1

[solved] Admin panel slow/timeout on local install

Posted: Mon Dec 08, 2008 1:03 pm
by zocor
Hey there,

since upgrading to 1.5.1 I have a a problem on my local test install. Upgrade on my (external) production server worked fine, but on my local (xampp) install the Admin panel takes a minute for each page to load. The site itself runs smoothly.

At first I thought this was a php.ini timeout/memory_limit problem, but I've set timeout to 360 and memory limit to anything up to 256 without any noticeable difference. The same goes for setting the memory limit in the cmsms config.php.

Debug mode indicates that roughly a 60 sec timeout happens here:

Code: Select all

Debug: (0.271437) - (7249920)

<br>
(mysql): SELECT version from cms_version<br>
 Error (0): <br>

Debug: (60.281729) - (7289336)

<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
 Error (0): <br>

Debug: (60.282915) - (7237272)

<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
 Error (0): <br>
I checked the database and compared with my production server but everything in the db is exactly the same in the tables cms_version and cms_admin_bookmarks.

Any ideas? Some Help would be really appreciated.

Re: Admin panel slow/timeout on local install

Posted: Tue Dec 09, 2008 7:20 am
by lakmal777
Hi I have the same issue.... When I click on a page it takes more than 30 sec to load it.   ??? . I think there is nothing wrong with the installation. The CMS tries to connect to outside (internet) which prevent loading fast. Not sure how to resolve it  :o

Re: Admin panel slow/timeout on local install

Posted: Tue Dec 09, 2008 10:39 am
by zocor
Ok, found it. Sometimes life can be so easy.  :)

Just go to the global preferences and set "Check for new CMS versions using this URL:" to "none"

All done.

Best,

Christian

Re: [solved] Admin panel slow/timeout on local install

Posted: Tue Dec 09, 2008 11:10 am
by moorezilla
I had a similar problem. I fixed mine with:
This was all a function of "Check for new CMS versions using this URL:" in the global settings. Once I put "none" in the url field, the delay went away altogether, so I guess this delay was all a function of cmsms not being able to call home and then completing the page build once its attempt to call home timed out.

Re: [solved] Admin panel slow/timeout on local install

Posted: Fri Dec 12, 2008 12:09 pm
by dhso
I also had a similar problem, but I hadn't access to the "Global Settings" Form, this one (and all forms from the "Admin Console") was empty.

The "Admin console" was displaying only the drop-down menus.

I corrected the problem inserting a new value in the site_prefs table:
    sitepref_name = "urlcheckversion"
    sitepref_value = "none"

And it works !

I think that this problem is linked to my internal proxy server which request a user identification when an extranet access is requested.

Re: [solved] Admin panel slow/timeout on local install

Posted: Fri Jan 16, 2009 10:03 pm
by klio
:-) thank you ever so much i've been strugling with this since yesterday....

klio-happy-bunny