Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
C
Core
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 920
    • Issues 920
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
  • Development
  • Core
  • Issues
  • #978

Closed
Open
Opened May 21, 2019 by justinfreeman (Agileware)@justinfreeman🚴🏿Developer

CiviCRM 5.13.4 - Specified key was too long; max key length is 767 bytes

Since CiviCRM 5.13.4 the following error is being reported on standard CPanel, Plesk and CentOS 6, CentOS 7 hosts using MariaDB 10.1.

May 20 10:26:22 [info] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(255))) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC ENGINE=INNODB [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
[type] => DB_Error
[user_info] => CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(255))) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC ENGINE=INNODB [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(255))) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC ENGINE=INNODB [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]"]

)

May 20 10:26:22 [info] $backTrace = #0 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE) #1 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #3 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #4 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", "DB_Error", TRUE) #5 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7)) #6 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", "1071 ** Specified key was too long; max key length is 767 bytes") #7 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError() #8 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #9 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #10 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #11 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #12 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", TRUE) #13 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php(914): CRM_Core_DAO::executeQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #14 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component.php(55): CRM_Utils_Check_Component_Env->checkMysqlUtf8mb4() #15 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check.php(209): CRM_Utils_Check_Component->checkAll() #16 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/api/v3/System.php(153): CRM_Utils_Check::checkAll() #17 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_system_check((Array:3)) #18 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #19 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9)) #20 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("System", "check", (Array:3), NULL) #21 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/REST.php(316): civicrm_api("System", "check", (Array:3)) #22 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Utils/REST.php(566): CRM_Utils_REST::process((Array:3), (Array:3)) #23 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(277): CRM_Utils_REST::ajax() #24 /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:12)) #25 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #26 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3)) #27 /var/www/vhosts/websiteorgau.org.au/httpdocs/includes/menu.inc(527): civicrm_invoke("ajax", "rest") #28 (closed) /var/www/vhosts/websiteorgau.org.au/httpdocs/index.php(21): menu_execute_active_handler() #29 (closed) {main}

And another example.

May 21 11:40:13 [info] $backTrace = #0 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE) #1 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4 _test (id VARCHAR(255), PRIMARY KEY(id(...") #3 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "CREATE TEMPORARY TABLE civicrm_utf8mb4_t est (id VARCHAR(255), PRIMARY KEY(id(...") #4 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "CREATE TEMPORARY TA BLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", "DB_Error", TRUE) #5 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7)) #6 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, "CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), P RIMARY KEY(id(...", "1071 ** Specified key was too long; max key length is 767 bytes") #7 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError() #8 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id( ...") #9 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(.. .") #10 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY (id(...") #11 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #12 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...", TR UE) #13 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php(914): CRM_Core_DAO::executeQuery("CREATE TEMPORARY TABLE civicrm_utf8mb4_test (id VARCHAR(255), PRIMARY KEY(id(...") #14 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check/Component.php(55): CRM_Utils_Check_Component_Env->checkMysqlUtf8mb4() #15 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check.php(209): CRM_Utils_Check_Component->checkAll() #16 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Utils/Check.php(93): CRM_Utils_Check::checkAll() #17 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Page.php(218): CRM_Utils_Check->showPeriodicAlerts() #18 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Contact/Page/DashBoard.php(69): CRM_Core_Page->run() #19 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Contact_Page_DashBoard->run((Array:1), NULL) #20 /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:13)) #21 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:1)) #22 (closed) /var/www/vhosts/websiteorgau/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:1)) #23 (closed) /var/www/vhosts/websiteorgau/httpdocs/includes/menu.inc(527): civicrm_invoke() #24 /var/www/vhosts/websiteorgau/httpdocs/index.php(21): menu_execute_active_handler() #25 (closed) {main}

Agileware Ref: CIVICRM-1213

Edited May 21, 2019 by justinfreeman (Agileware)
To upload designs, you'll need to enable LFS and have admin enable hashed storage. More information
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: dev/core#978