User Error: MySQL Error

reneesanguinetti

Hello, I'm using:
Zenphoto version 1.4.3.4 [11003] (Official build)
Current gallery theme: zpFocus_v1.4.3
I've been receiving these warnings in my Debug Log:

{Sun, 11 Nov 2012 08:10:47 GMT}
Backtrace: USER ERROR: MySQL Error: Zenphoto received the error User xxxxx already has more than 'max_user_connections' active connections when connecting to the database server. in /home6/advertk3/public_html/zp-core/functions-basic.php on line 922
trigger_error called
from zp_error (functions-basic.php [922])
from db_connect (functions-db-MySQL.php [25])
from require_once (functions-basic.php [144])
from require_once (functions.php [18])
from c.php [9]
{Sun, 11 Nov 2012 08:10:47 GMT}
Backtrace: USER ERROR: MySQL Error: Zenphoto received the error User xxxxx already has more than 'max_user_connections' active connections when connecting to the database server. in /home6/advertk3/public_html/zp-core/functions-basic.php on line 922
trigger_error called
from zp_error (functions-basic.php [922])
from db_connect (functions-db-MySQL.php [25])
from require_once (functions-basic.php [144])
from require_once (functions.php [18])
from require_once (template-functions.php [10])
from index.php [6]
I contacted my host and they asked how many users were logged in. I am the only user and only log in at one location. That is about all they suggested. So, I thought you may have more of an explanation for the warnings. Thank-you! Renee

sbillard

I assume that there are no other errors in the ZP logs. Check your server cgi logs for errors. My best guess is that some images are causing PHP faults and that the mySql connections are not being cleaned up properly.

reneesanguinetti

Hello,
This is in my server log:
[11-Nov-2012 13:51:24 UTC] PHP Warning: Invalid argument supplied for foreach() in /home6/advertk3/public_html/zp-core/class-rss.php on line 1028

And this is in the ZP Debug log:
{Sun, 11 Nov 2012 17:22:50 GMT}
Backtrace: NOTICE: Undefined variable: firstPageImages in /home6/advertk3/public_html/themes/zpfocus/search.php on line 126
include called
from index.php [92]
{Sun, 11 Nov 2012 17:29:26 GMT}
Backtrace: WARNING: Invalid argument supplied for foreach() in /home6/advertk3/public_html/zp-core/class-rss.php on line 1028
RSS->printRSSfeed called
from index.php [18]
I also contacted my host again and all they said was "Once you find and resolve the error, your site should be able to work again just fine"

acrylian

You should be able to delete the firstPageImages variable from the theme page as noted. I think that is a leftover from older Zenphoto versions. I mean I did mention that to gjr the theme's authors a while back.

Regarding the rss error.. There is a feed called but no items delivered. Please try the trunk.