error, and page won't load

william

first see error at the end of the page, then the whole crm is down, only show below message:

Type: E_USER_ERROR (256)
Message: mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE("SET NAMES "utf8"")
File: /hermes/bosoraweb151/b1089/glo.******001/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 '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") ", "/hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1226, "User '******' has exceeded the 'max_questions' resource (current value: 75000)", "SET NAMES \"utf8\"", false, Object (ADODB_mysqlt), "SET NAMES \"utf8\"", false, "mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") "))

File: /hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") ", 256)

File: /hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb.inc.php
line 1071
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1226, "User '******' has exceeded the 'max_questions' resource (current value: 75000)", "SET NAMES \"utf8\"", false, "Object (ADODB_mysqlt)")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb.inc.php
line 1046
function called: _Execute("SET NAMES \"utf8\"", false)

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/database.php
line 48
function called: Execute("SET NAMES \"utf8\"")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/database.php
line 969
function called: Connect()

File: /hermes/bosoraweb151/b1089/glo.******001/crm/index.php
line 33
function called: require_once("/hermes/bosoraweb151/b1089/glo.******001/crm/include/database.php")

ajb

As you can see you've got some query limits on mysql server. EPESI is rather sql intensive, as it manages a lot of data and metadata (like edit history, login audit, etc)
1. You have to increase the limit.
2. You can limit record's indexing per hour in data/config.php -- maybe it'll help somehow, but it depends on what causes the issue.

define('RB_INDEXER_LIMIT_QUERIES', 10000);

Regards,
Adam

william

got it, thank you.

william

RECEIVED BELOW AGAIN, AFTER DONE THE CONFIG FILE, AND RE-INSTALL THE CRM.
AFTER IMPORT 9000 CUSTOMER LEADS

==========================================



Type: E_USER_ERROR (256)

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

File: /hermes/bosoraweb151/b1089/glo.******001/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 '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") ", "/hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1226, "User '******' has exceeded the 'max_questions' resource (current value: 75000)", "SET NAMES \"utf8\"", false, Object (ADODB_mysqlt), "SET NAMES \"utf8\"", false, "mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") "))

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

    line 77

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

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

    line 1071

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

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

    line 1046

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

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

    line 48

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

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

    line 969

    function called: Connect()

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include.php

    line 22

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

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

    line 18

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

________________________________________

________________________________________

Type: E_USER_ERROR (256)

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

File: /hermes/bosoraweb151/b1089/glo.******001/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 '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") ", "/hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1226, "User '******' has exceeded the 'max_questions' resource (current value: 75000)", "SET NAMES \"utf8\"", false, Object (ADODB_mysqlt), "SET NAMES \"utf8\"", false, "mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SET NAMES \"utf8\"\") "))

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

    line 77

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

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

    line 1071

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

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

    line 1046

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

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

    line 48

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

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

    line 969

    function called: Connect()

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include.php

    line 22

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

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

    line 18

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

________________________________________

________________________________________

Type: E_USER_ERROR (256)

Message: mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE("SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15") 

File: /hermes/bosoraweb151/b1089/glo.******001/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 '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15\") ", "/hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1226, "User '******' has exceeded the 'max_questions' resource (current value: 75000)", "SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15", false, Object (ADODB_mysqlt), "SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15", false, "mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15\") "))

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

    line 77

    function called: trigger_error("mysqlt error: [1226: User '******' has exceeded the 'max_questions' resource (current value: 75000)] in EXECUTE(\"SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15\") ", 256)

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

    line 1071

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1226, "User '******' has exceeded the 'max_questions' resource (current value: 75000)", "SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15", false, "Object (ADODB_mysqlt)")

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

    line 1027

    function called: _Execute("SELECT company_id FROM company_recent WHERE user_id = 1 ORDER BY visited_on DESC LIMIT 15")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/libs/adodb/drivers/adodb-mysql.inc.php

    line 591

    function called: Execute("SELECT company_id FROM company_recent WHERE user_id = ? ORDER BY visited_on DESC LIMIT 15", Array (1))

[PHP core called function]

    function called: SelectLimit("SELECT company_id FROM company_recent WHERE user_id = ? ORDER BY visited_on DESC", "15", -1, Array (1))

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

    line 454

    function called: call_user_func_array(Array (Object (ADODB_mysqlt), "SelectLimit"), Array ("SELECT company_id FROM company_recent WHERE user_id = ? ORDER BY visited_on DESC", "15", -1, Array (#1)))

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1106

    function called: SelectLimit("SELECT company_id FROM company_recent WHERE user_id = %d ORDER BY visited_on DESC", "15", -1, Array ("1"))

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 1000

    function called: add_recent_entry("company", "1", "216")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Utils/RecordBrowser/object_wrapper/Recordset.php

    line 258

    function called: new_record("company", Array ("Don Bowlin Llc", "8019442366", "0", "8876 S Sheffield Way", "", "Sandy", "US", "UT", "84093"))

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Premium/Import/Temp/Worksheet.php

    line 467

    function called: new_record(Array ("Don Bowlin Llc", "8019442366", "0", "8876 S Sheffield Way", "", "Sandy", "US", "UT", "84093"))

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Premium/Import/Import_0.php

    line 159

    function called: import()

[PHP core called function]

    function called: worksheets()

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/module.php

    line 842

    function called: call_user_func_array(Array (Object (Premium_Import), "worksheets"), Array ())

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/module.php

    line 773

    function called: get_html_of_module("Object (Premium_Import)", null, "admin")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/module.php

    line 946

    function called: display_module("\"Object (Premium_Import)\"", null, "admin")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Base/Admin/Admin_0.php

    line 31

    function called: pack_module("Premium_Import", null, "admin")

[PHP core called function]

    function called: body()

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/module.php

    line 853

    function called: call_user_func_array(Array (Object (Base_Admin), "body"), Array ())

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/module.php

    line 773

    function called: get_html_of_module(Object (Base_Admin), null, null)

File: /hermes/bosoraweb151/b1089/glo.******001/crm/modules/Base/Box/Box_0.php

    line 151

    function called: display_module("Object (Base_Admin)")

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/epesi.php

    line 241

    function called: body()

File: /hermes/bosoraweb151/b1089/glo.******001/crm/include/epesi.php

    line 286

    function called: go(Object (Base_Box))

File: /hermes/bosoraweb151/b1089/glo.******001/crm/process.php

    line 35

    function called: process("__action_module__=%2FBase_Box%7C0%2FBase_Admin%7Cmain_0%2FPremium_Import%7C0&%2FBase_Box%7C0%2FBase_Admin%7Cmain_0%2FPremium_Import%7C0_action=process_queue", false)

ajb

Some caps lock issues? Maybe use another keyboard.

If you have reinstalled you have a new config.php file. Have you put that limit config param again?

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

Help Me! | Download from SourceForge