Hello,
Zenphoto version 1.4.3.1 [10646] (Official build)
Current gallery theme: zpFocus v_1.4.3
For the past 2 days I have been experiencing difficulties when trying to edit albums and images. When I try to view an album or it's images, the edit page takes 10 to 15 minutes to load or sometimes truncates. (viewing and saving). The other features of the admin seem to respond normally. I tried selecting a single image for the albums instead of random and also set the image page to display only 5 images. That doesn't help. My host said their are no issues with the server and suggested I use their check and repair feature for my sql database and the optimize feature in phpmyadmin. I used those and everything checked out OK. I even re-run setup.
I haven't made any changes recently and the only errors in the logs are:
{Tue, 30 Oct 2012 16:37:04 GMT}
Backtrace: NOTICE: Undefined variable: firstPageImages in /home6/advertk3/public_html/themes/zpfocus/search.php on line 126
include called
from index.php [92]
{Tue, 30 Oct 2012 16:49:58 GMT}
Backtrace: WARNING: Invalid argument supplied for foreach() in /home6/advertk3/public_html/zp-core/class-rss.php on line 1021
RSS->printRSSfeed called
from index.php [18]
I'm not sure of why I get these warnings because I haven't changed anything.
Any suggestions of how to fix the warnings and the admin edit would be greatly appreciated.
Thank-you! Renee
Comments
Second error is probably from a request for an invalid RSS feed.
Neither are from the back-end, so not the issue with the slow load.
When this failure happens, how much, if any, of the page gets displayed? If something is displayed, is it all at once or spread out over the time the page is loading?
Can you capture the HTML while the page is still loading? It may help in figuring out where the slow-down comes from. Maybe posts the last 20 or so lines. Be sure to enclose with the back-tick character so it is listed as code. Otherwise the html will be executed and we won't see anything.
Or capture a truncated page when one occurs.
During the past 24 hours your account has been throttled for a total of 25018.468 seconds. Could this be the reason?
IMHO it is strange that your host has assured you that it is not their issue when this error is present.
The following information is what I learned about CPU Throttling:
Throttling or Suspensions are usually caused by:
Poorly coded Php scripts such as multiple nested loops, or infinite loops.
Themes, Addons, or Plugins (if you just added a new component to your script, you may want to remove it to see if that new component caused your site to suddenly perform slowly)
Queries that return inordinately large dataset results (eg: 100,000 records) in the Response object of a round trip to the server.
Queries that take too long to execute due to heavy aggregation commands like SUM, COUNT over very large datasets without proper indexing.
Queries that are doing complex unoptimized nested Joins.
Queries that execute large batch commands like INSERTS, UPDATES, OR DELETES - these types of sql calls are 10 times more expensive and resource intensive than the SELECT query command.
DDoS Attacks
Any process that uses too much RAM, like a rogue cron job
Too many simultaneous connections like Downloads, FTP, IMAP, or PHP
I contacted my host again and they monitored the site while I was logged in as admin and in the edit mode. They reported PHP spiking and again it took "forever" for the page to load. My PHP version is 5.2.17 and they suggested switching versions. "You might consider enabling php 5.2(fastcgi)" I did this, but it adds the following to my .htaccess file: # Use PHP5CGI as default
AddHandler fcgid-script .php at the very top and I wanted to make sure that there are no conflicts with Zenphoto and this php version. "FastCGI for PHP makes all your PHP applications run through mod_fastcgi instead of mod_suphp. This eliminates the overhead of loading the PHP interpreter on every hit. Since it is always in memory ready for the next hit, the responses will be generated faster." Even if there are no conflicts, it still has not improved the performance.
They also offer:
PHP 5.3 All files with the extension .php will be handled by the PHP 5.3 engine.
Most reliable and compatible version of PHP.
PHP 5.3 (Single php.ini)
Same as PHP 5.3, but all subdirectories will use ~/public_html/php.ini
PHP 5.4
All files with the extension .php will be handled by the PHP 5.4 engine.
Latest version of PHP.
Note: Source Guardian and Zend Guard Loader not currently supported.
PHP 5.4 (Single php.ini)
Same as PHP 5.4, but all subdirectories will use ~/public_html/php.ini
Again, I don't know if any of these versions would help or if they are compatible.
I understand it is not your responsibility to figure this out, but I thought you may have seen this before or have some other suggestions.
I will also upgrade and let you know if that solves anything. But I would like to know if the php version will cause a conflict so I can revert back to the original if necessary.
Again, thank-you for your time! Renee
Do you have the visual album thumb selector disabled and also the thumb display on the album edit main list?
I will upgrade and see what changes.
I upgraded to Zenphoto version 1.4.3.3 [10980] (Official build) and my PHP version to 5.3.17 "Most reliable and compatible version of PHP" according to Bluehost. I was going to use PHP 5.4, but "Note: Source Guardian and Zend Guard Loader not currently supported" at Bluehost.
Even switched browsers.
And these changes didn't help.
MySql version is 5.1.66 the newest they have. PHP memory limit: 128M. My site seems to run fast for the visitor, just the backend editing is so slow. I'm out of ideas. Thank-you! Renee
As well there is a possibility that your host has the PHP XDebug profiler available. That can collect execution statistics for the script but may not account for "wait" times, only for processor execution.