• Resolved zebralove

    (@zebralove)


    Starting on July 1st we started seeing the following error in our error log basically every minute.

    WordPress database error Specified key was too long; max key length is 1000 bytes for query CREATE TABLE wpgx_hcaptcha_events ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, source VARCHAR(256) NOT NULL, form_id VARCHAR(20) NOT NULL, ip VARCHAR(39) NOT NULL, user_agent VARCHAR(256) NOT NULL, uuid VARCHAR(36) NOT NULL, error_codes VARCHAR(256) NOT NULL, date_gmt DATETIME NOT NULL, status VARCHAR(20) NOT NULL DEFAULT ‘active’, trashed_at_gmt DATETIME NULL, PRIMARY KEY (id), KEY source (source), KEY form_id (form_id), KEY hcaptcha_id (source, form_id), KEY ip (ip), KEY uuid (uuid), KEY date_gmt (date_gmt), KEY status_date_gmt (status, date_gmt), KEY status_source_form (status, source, form_id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/hcaptcha-for-forms-and-more/hcaptcha.php’), HCaptcha\Main->init, HCaptcha\Main->load, HCaptcha\Migrations\Migrations->__construct, HCaptcha\Migrations\Migrations->init, HCaptcha\Migrations\Migrations->maybe_create_tables, HCaptcha\Admin\Events\Events::create_table, dbDelta

Viewing 1 replies (of 1 total)
  • Plugin Contributor kaggdesign

    (@kaggdesign)

    Hi @zebralove ,

    This issue is related to your database using MariaDB with the outdated MyISAM storage engine. MyISAM has a 1000-byte key length limit, and the current Events table indexes can exceed that limit when utf8mb4 is used.

    We are aware of this issue, and it has already been fixed here.

    The fix will be included in version 5.1.0, which should be released in the next few days. If you would like to test it earlier, you can install v5.1.0-RC4 from here.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.