{"id":12643875,"date":"2020-04-08T07:07:36","date_gmt":"2020-04-08T07:07:36","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-error-307\/"},"modified":"2020-04-08T07:07:36","modified_gmt":"2020-04-08T07:07:36","slug":"database-error-307","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-error-307\/","title":{"rendered":"database error"},"content":{"rendered":"

I was able to install this plugin. However, the following error was output in the Apache log. How can I work around this problem?<\/p>\n

WordPress database error: Unknown column ‘t.name’ in ‘where clause’ for query UPDATE wp_ab_testing_for_wp_ab_test<\/code> AS t,
\n INNER JOIN wp_posts<\/code> AS p on t.postId = p.ID,
\n SET t.title = CONCAT(‘Test “‘, p.post_title, ‘”‘),
\n WHERE t.name IS NULL made by require_once(‘wp-admin\/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, ABTestingForWP\\\\Installer->runMigrations,<\/p>\n

WordPress database error: Specified key was too long; max key length is 767 bytes for query CREATE TABLE IF NOT EXISTS wp_ab_testing_for_wp_variant_condition<\/code> (,
\n variantId<\/code> varchar(32) NOT NULL DEFAULT ”,,
\n key<\/code> varchar(255) NOT NULL DEFAULT ”,,
\n value<\/code> varchar(255) NOT NULL DEFAULT ”,,
\n PRIMARY KEY (variantId<\/code>, key<\/code>, value<\/code>),
\n ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; made by require_once(‘wp-admin\/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, ABTestingForWP\\\\Installer->runMigrations,<\/em><\/p>\n","protected":false},"template":"","class_list":["post-12643875","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12643875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12643875\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=12643875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}