DB Duplicate column name when updates the plugin

  • Resolved TC.K

    (@wp_dummy)


    3 years, 3 months ago

    When I tried to updates the plugin to latest version it cause a lot of problem.

    ]WordPress database error Duplicate column name 'twitter_image_url' for query ALTER TABLE wp_aioseo_posts ADD twitter_image_url text DEFAULT NULL AFTER twitter_image_type 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, AIOSEO\Plugin\Common\Main\Updates->runUpdates, AIOSEO\Plugin\Common\Main\Updates->migrateOgTwitterImageColumns, AIOSEO\Plugin\Common\Utils\Database->execute

WordPress database error Duplicate column name 'twitter_image_url' for query ALTER TABLE wp_aioseo_posts ADD twitter_image_url text DEFAULT NULL AFTER twitter_image_type made by include('fix.php'), require('wp-blog-header.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, AIOSEO\Plugin\Common\Main\Updates->runUpdates, AIOSEO\Plugin\Common\Main\Updates->migrateOgTwitterImageColumns, AIOSEO\Plugin\Common\Utils\Database->execute

 WordPress database error Duplicate column name 'twitter_image_url' for query ALTER TABLE wp_aioseo_posts ADD twitter_image_url text DEFAULT NULL AFTER twitter_image_type made by include('fix.php'), require('wp-blog-header.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, AMP_Validation_Manager::{closure}, AMP_Validation_Callback_Wrapper->__invoke, AIOSEO\Plugin\Common\Main\Updates->runUpdates, AIOSEO\Plugin\Common\Main\Updates->migrateOgTwitterImageColumns, AIOSEO\Plugin\Common\Utils\Database->execute

....

    Apparently the plugin tried to recreate the columns everytime i activate the plugin.

Viewing 4 replies - 1 through 4 (of 4 total)
  • J Burns

    (@subiewrx)

    3 years, 2 months ago

    Hi @wp_dummy,

    I’m sorry you’re experiencing an issue here.

    I have shared the error messages with our Dev team.

    I will reach out to you as soon as I know more.

    Thank you for your patience!

    J Burns

    (@subiewrx)

    3 years, 2 months ago

    Hi @wp_dummy,

    Could you please share what the file “fix.php” is and why you are including it? Can you share its contents?

    Could you try excluding the “fix.php” file and then run the update again to see if it works?

    Curious if you are on a multisite environment?

    Thanks!

    Thread Starter TC.K

    (@wp_dummy)

    3 years, 2 months ago

    the fix.php is to fix whitespaces appeared in the header in the sitemap.

    You can refer to this https://idreeselahi.in/sitemap-error-fixed/

    Thread Starter TC.K

    (@wp_dummy)

    3 years, 2 months ago

    Ok, got it working. It was the fix.php that caused the problem.

    Thanks for the helps.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘DB Duplicate column name when updates the plugin’ is closed to new replies.

Tags