• Resolved yhachisu

    (@yhachisu)


    I was able to install this plugin. However, the following error was output in the Apache log. How can I work around this problem?

    WordPress database error: Unknown column ‘t.name’ in ‘where clause’ for query UPDATE wp_ab_testing_for_wp_ab_test AS t,
    INNER JOIN wp_posts AS p on t.postId = p.ID,
    SET t.title = CONCAT(‘Test “‘, p.post_title, ‘”‘),
    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,

    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 (,
    variantId varchar(32) NOT NULL DEFAULT ”,,
    key varchar(255) NOT NULL DEFAULT ”,,
    value varchar(255) NOT NULL DEFAULT ”,,
    PRIMARY KEY (variantId, key, value),
    ) 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,

Viewing 6 replies - 1 through 6 (of 6 total)
  • Anonymous User 16972068

    (@anonymized-16972068)

    @yhachisu That’s not good! I’ll take a look as soon as possible and try to catch this error. Hopefully next tuesday

    Thread Starter yhachisu

    (@yhachisu)

    Thanks for your response! I am looking forward to it.

    Anonymous User 16972068

    (@anonymized-16972068)

    Hi @yhachisu,

    Version 1.18.1 of the plugin just released and it contains a database repair option.

    Go to your wp-admin, look for A/B Testing for WordPress > Advanced Options.

    On this page you’ll find a “Repair database” section. This will try to repair the tables and data around A/B Testing for WordPress.

    Hope this will help.

    Kind regards,
    Gaya Kessler

    Anonymous User 16972068

    (@anonymized-16972068)

    Going to close this issue due to lack of response and seeing it solved the problem for others.

    Thread Starter yhachisu

    (@yhachisu)

    I’m sorry for the late reply.
    I updated it, but I was still unable to add tests.
    This may be because I changed the database settings(encoding and collation) before the update.
    Would you mind waiting for a while to restore the settings and test it?

    Thread Starter yhachisu

    (@yhachisu)

    I tried changing the database settings. The error no longer occurs, but the test is not saved. It may be the influence of other plugins, so I will try variously. Thank you very much.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘database error’ is closed to new replies.