when i add new users

william

now, i have about 15 users, if i want to add more user or delete existing user, my sql will be down, and get below message on my browser, please help.
i have requested server company gives me the highest sql inquiry.



Type: E_USER_ERROR (256)

Message: mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE("SET NAMES "utf8"") 

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE(\"SET NAMES \"utf8\"\") ", "/hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1226, "User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)", "SET NAMES \"utf8\"", false, Object (ADODB_mysqlt), "SET NAMES \"utf8\"", false, "mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE(\"SET NAMES \"utf8\"\") "))

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE(\"SET NAMES \"utf8\"\") ", 256)

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb.inc.php

    line 1071

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1226, "User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)", "SET NAMES \"utf8\"", false, "Object (ADODB_mysqlt)")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb.inc.php

    line 1046

    function called: _Execute("SET NAMES \"utf8\"", false)

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include/database.php

    line 48

    function called: Execute("SET NAMES \"utf8\"")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include/database.php

    line 969

    function called: Connect()

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include.php

    line 22

    function called: require_once("/hermes/bosoraweb151/b1089/glo.xxx/crm/include/database.php")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/modules/Utils/Messenger/refresh.php

    line 18

    function called: require_once("/hermes/bosoraweb151/b1089/glo.xxx/crm/include.php")

Type: E_USER_ERROR (256)

Message: mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE("SELECT name,value FROM variables") 

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE(\"SELECT name,value FROM variables\") ", "/hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1226, "User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)", "SELECT name,value FROM variables", false, Object (ADODB_mysqlt), "SELECT name,value FROM variables", false, "mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE(\"SELECT name,value FROM variables\") "))

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("mysqlt error: [1226: User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)] in EXECUTE(\"SELECT name,value FROM variables\") ", 256)

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb.inc.php

    line 1071

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1226, "User 'xxx' has exceeded the 'max_questions' resource (current value: 150000)", "SELECT name,value FROM variables", false, "Object (ADODB_mysqlt)")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb.inc.php

    line 1027

    function called: _Execute("SELECT name,value FROM variables")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/libs/adodb/adodb.inc.php

    line 1420

    function called: Execute("SELECT name,value FROM variables", Array ())

[PHP core called function]

    function called: GetAssoc("SELECT name,value FROM variables", Array ())

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include/database.php

    line 483

    function called: call_user_func_array(Array (Object (ADODB_mysqlt), "GetAssoc"), Array ("SELECT name,value FROM variables", Array (#0)))

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include/variables.php

    line 18

    function called: GetAssoc("SELECT name,value FROM variables")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include/variables.php

    line 23

    function called: load()

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/include/version.php

    line 9

    function called: get("version")

File: /hermes/bosoraweb151/b1089/glo.xxx/crm/process.php

    line 23

    function called: epesi_requires_update()

william

i have contacted my server company, but they give me below notes, but it doesn't help:

Hariprasad S: There are many possible causes for the 'max_questions' limit get exceeded. Some of them are:
Hariprasad S: - A script is not closing the MySQL connection after accessing the database. In WordPress, such chances are less, however if there is an error in the scripting of a plugin or theme which you're using, then the MySQL connection won't close after querying the database. Hence, please make sure that you close the connection immediately after accessing the database using mysql_close() command from your scripts.
Hariprasad S: - Your scripts or pages are hitting too frequently from a specific IP address through brute force tools or manually or from other websites. You can check raw logs available in the /stats directory or check the Visitor Statistics for such possibilities. Using the .htaccess Hotlink Protection and the .htaccess Block IP Addresses would resolve this issue.
Hariprasad S: - Using a single database for multiple applications or having too many users for a single database. A solution for this is creating separate databases for separate applications as well as having separate users.
Hariprasad S: Additionally, if you get a lot of traffic for your WordPress blog, then I suggest that you use a caching plugin, such as WP-Cache. WP-Cache will make a file copy of a page and serve that up instead of the original page (refreshing it every so often). This not only speeds up your website a lot, but hits to the cached pages make no SQL queries or database hits whatsoever.

ajb

Does it happen only during user add/delete?
It should occur for all users at the same time. Max_questions is a query limit per hour, which gives you about 41 queries per second (with 150000 limit). On a clean EPESI installation, first run has about 160 queries in less than 0.3 second.
Answer is pretty obvious. You have to increase limit or change hosting provider to get rid of the limit. In EPESI is all about data and access - it will use database extensively.

Regards,
Adam

william

now it happen with turning to next page, not just add/delete user.

ajb

So you've got the answer in my previous post. Sorry.

william

thank you.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge