Conversation
supportHi, I’m getting this error after updating the plugin to its last version Error while upgrading a database: Duplicate column name ‘note_context’ There is a way to fix this error? Or at least delete any shopMagic data in the db and restart with a fresh install of the plugin? Thanks This topic was modified 2 weeks, 2 days ago by Carloalberto Fornea .
Hi, @carletto0282 Thank you for contacting us. Could you please provide the following information? Current version of the ShopMagic plugin WordPress version WooCommerce version PHP version Also, please go to WooCommerce → Status → Logs and check whether there are any errors related to our plugin or database updates. If you find any relevant log entries, please send their contents in your reply. Additionally, could you confirm whether the issue still occurs after performing a manual reinstallation/update of the plugin? This information will help us better identify the source of the problem. Thank you!
Hi @carletto0282 As we haven’t got any replies, I’m marking this topic as resolved for now.
Just to confirm i am also getting this error Here is error in log files on server, mod_fcgid: stderr: WordPress database error Table ‘wp_zqyuf.wp_shopmagic_automation_outcome_logs’ doesn’t exist for query SHOW COLUMNS FROM wp_shopmagic_automation_outcome_logs WHERE Field = ‘note_context’; made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, ShopMagicVendor\\WPDesk\\Plugin\\Flow\\PluginBootstrap::ShopMagicVendor\\WPDesk\\Plugin\\Flow\\{closure}, ShopMagicVendor\\WPDesk\\Plugin\\Flow\\Initialization\\Simple\\SimpleFreeStrategy->run_init, ShopMagicVendor\\WPDesk\\Plugin\\Flow\\Initialization\\Simple\\SimpleFreeStrategy->init_plugin, WPDesk\\ShopMagic\\Plugin->init, ShopMagicVendor\\WPDesk\\Migrations\\WpdbMigrator->migrate, ShopMagicVendor\\WPDesk\\Migrations\\WpdbMigrator->do_migrate, WPDesk\\ShopMagic\\migrations\\Version_42->up mod_fcgid: stderr: PHP Warning: Error while upgrading a database: Duplicate column name 'note_context' in /httpdocs/wp-content/plugins/shopmagic-for-woocommerce/vendor_prefixed/wpdesk/wp-migrations/src/WpdbMigrator.php on line 104 (removed some of the above link) PHP 8.3.31 WP 6.9.4 Lates version of shopmagic 4.8.3
Hi, @carletto0282 Thank you for contacting us. Could you please provide the following information? Current version of the ShopMagic plugin WordPress version WooCommerce version PHP version Also, please go to WooCommerce → Status → Logs and check whether there are any errors related to our plugin or database updates. If you find any relevant log entries, please send their contents in your reply. Additionally, could you confirm whether the issue still occurs after performing a manual reinstallation/update of the plugin? This information will help us better identify the source of the problem. Thank you!
Hi @carletto0282 As we haven’t got any replies, I’m marking this topic as resolved for now.
Just to confirm i am also getting this error Here is error in log files on server, mod_fcgid: stderr: WordPress database error Table ‘wp_zqyuf.wp_shopmagic_automation_outcome_logs’ doesn’t exist for query SHOW COLUMNS FROM wp_shopmagic_automation_outcome_logs WHERE Field = ‘note_context’; made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, ShopMagicVendor\\WPDesk\\Plugin\\Flow\\PluginBootstrap::ShopMagicVendor\\WPDesk\\Plugin\\Flow\\{closure}, ShopMagicVendor\\WPDesk\\Plugin\\Flow\\Initialization\\Simple\\SimpleFreeStrategy->run_init, ShopMagicVendor\\WPDesk\\Plugin\\Flow\\Initialization\\Simple\\SimpleFreeStrategy->init_plugin, WPDesk\\ShopMagic\\Plugin->init, ShopMagicVendor\\WPDesk\\Migrations\\WpdbMigrator->migrate, ShopMagicVendor\\WPDesk\\Migrations\\WpdbMigrator->do_migrate, WPDesk\\ShopMagic\\migrations\\Version_42->up mod_fcgid: stderr: PHP Warning: Error while upgrading a database: Duplicate column name 'note_context' in /httpdocs/wp-content/plugins/shopmagic-for-woocommerce/vendor_prefixed/wpdesk/wp-migrations/src/WpdbMigrator.php on line 104 (removed some of the above link) PHP 8.3.31 WP 6.9.4 Lates version of shopmagic 4.8.3