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
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
Thanks for the reply. I will check that out first. I appreciate the help.
Hello,
The adodb 3rdparty libraries are updated in v5.6.3.5
.
The adodb 3rdparty libraries are updated in v5.6.3.5
.
Thank you for your reply. I will try the update today and post my results.
Thanks again, the assistance is appreciated.
Thanks again, the assistance is appreciated.
I did the update and so far so good! Thanks again for the responses.
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.