Fatal error: Uncaught exception 'ADODB_Exception' User 'xxxx' has exceeded the 'max_questions'

Permalink
Hey, I am new to concrete5 and apologize if I have posted in the wrong section. I am also a beginning, yet eager learner of php/sql and would appreciate any assistance given to point me in the right direction.

I have a Concrete5 website the throws the following error from time to time. (Attached below). Here is some info about the site & host:

Concrete5 version: 5.6.3.2
Hosting - Fatcow
# concrete5 Version
5.6.3.2

# concrete5 Packages
Dojo Page Filter Pro (2.3), Page Auto Redirect (2.0), Page password (1.1.4), Presence Church Theme (1.4.0), Pro Blog (12.4.4), Pro Events (11.1.0), Pro Forms (7.5.8), Pro Media (7.5.0).

# concrete5 Overrides
languages/sv_SE, languages/ar, languages/cs_CZ, languages/da_DK, languages/de_DE, languages/el_GR, languages/es_AR, languages/es_ES, languages/es_MX, languages/es_PE, languages/fa_IR, languages/fi_FI, languages/fr_FR, languages/it_IT, languages/ja_JP, languages/nb_NO, languages/nl_NL, languages/pt_PT, languages/ro_RO, languages/ru_RU, languages/sk_SK, languages/sl_SI, languages/tr_TR, languages/vi_VN, languages/zh_TW

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off

# Server Software
Apache/2

# Server API
cgi-fcgi

# PHP Version
5.5.22

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, pspell, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 120
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 256M
post_max_size - 20M
sql.safe_mode - Off
upload_max_filesize - 20M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200


____________
ERROR (User name and site name have been replaced by "xxxx"):

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1226: User ‘XXX’ has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE("SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=SCHEMA()") ' in /hermes/walnaweb01a/b1012/moo.xxxxxx/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /hermes/walnaweb01a/b1012/moo.xxxxx/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1226, 'User ‘xxxxx’ h...', 'SELECT TABLE_NA...', false, Object(ADODB_mysqlt)) #1 /hermes/walnaweb01a/b1012/moo.xxxx/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('SELECT TABLE_NA...', false) #2 /hermes/walnaweb01a/b1012/moo.xxxxx/concrete/libraries/3rdparty/adodb/adodb.inc.php(2334): ADOConnection->Execute('SELECT TABLE_NA...') #3 /hermes/walnaweb01a/b1012/moo.xxxxxx/concre in /hermes/walnaweb01a/b1012/moo.xxxxxx/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

1 Attachment

 
rritz replied on at Permalink Reply
rritz
My guess is that this is to do with your mysql settings

If you go to phpmyadmin of your db --> users --> user xxx who encountered the error --> Edit priviledges
you'll see if there are any resource limits

in shared hosting you don't get access to this, so you will have to ask your hosting company about raising or lifting limits.

Caching everything might also help to keep queries low.
valleysea replied on at Permalink Reply
Thanks for the reply. I will check that out first. I appreciate the help.
CMSDeveloper replied on at Permalink Best Answer Reply
CMSDeveloper
Hello,

The adodb 3rdparty libraries are updated in v5.6.3.5


.
valleysea replied on at Permalink Reply
Thank you for your reply. I will try the update today and post my results.

Thanks again, the assistance is appreciated.
valleysea replied on at Permalink Reply
I did the update and so far so good! Thanks again for the responses.