patayintattoo
New Member
Hello - I have been trying to update my markup formula for my woocommerce/wordpress shop with the Alidrop ship plugin. I am using the standard woocomerce store template and everything was working fine until today.
I have decided to add a new formula for a new collection I wanted to add to my store. I did this by adding the new formula, indicating the category it will impact, then saving it. After I saved it I attempted to add the product to test if the formula was working. Upon importing the product to the specific category I found the formula did not apply. This prompted me to return to the prices setting to hit "update prices". Since then (several hours ago) the status bar has barely moved and now has froozen with NaN% appearing rather than a number. Now
In addition, all of a sudden an error code is appearing on the top all my pages. I firmly believe this app has somehow created an error and I am a lost in how to fix it. Help please, anyone!!
This is the error msg appearing at the top of each of my pages:
WordPress database error: [Table 'xm_options' is marked as crashed and should be repaired]
SELECT option_value FROM xm_options WHERE option_name = 'cron' LIMIT 1
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652237;a:1:{s:20:\"jetpack_v2_heartbeat\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652237;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652238;a:1:{s:17:\"jetpack_sync_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:21:\"jetpack_sync_interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:300;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652239;a:1:{s:22:\"jetpack_sync_full_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:21:\"jetpack_sync_interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:300;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652779;a:1:{s:20:\"jp_sitemap_cron_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"sitemap-interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:32:\"wc_connect_fetch_service_schemas\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:26:\"action_scheduler_run_queue\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:12:\"every_minute\";s:4:\"args\";a:0:{}s:8:\"interval\";i:60;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:34:\"wp_privacy_delete_old_export_files\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
I have decided to add a new formula for a new collection I wanted to add to my store. I did this by adding the new formula, indicating the category it will impact, then saving it. After I saved it I attempted to add the product to test if the formula was working. Upon importing the product to the specific category I found the formula did not apply. This prompted me to return to the prices setting to hit "update prices". Since then (several hours ago) the status bar has barely moved and now has froozen with NaN% appearing rather than a number. Now
In addition, all of a sudden an error code is appearing on the top all my pages. I firmly believe this app has somehow created an error and I am a lost in how to fix it. Help please, anyone!!
This is the error msg appearing at the top of each of my pages:
WordPress database error: [Table 'xm_options' is marked as crashed and should be repaired]
SELECT option_value FROM xm_options WHERE option_name = 'cron' LIMIT 1
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652237;a:1:{s:20:\"jetpack_v2_heartbeat\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652237;a:1:{s:20:\"jetpack_clean_nonces\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652238;a:1:{s:17:\"jetpack_sync_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:21:\"jetpack_sync_interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:300;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652239;a:1:{s:22:\"jetpack_sync_full_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:21:\"jetpack_sync_interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:300;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652779;a:1:{s:20:\"jp_sitemap_cron_hook\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"sitemap-interval\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:32:\"wc_connect_fetch_service_schemas\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:26:\"action_scheduler_run_queue\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:12:\"every_minute\";s:4:\"args\";a:0:{}s:8:\"interval\";i:60;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:34:\"wp_privacy_delete_old_export_files\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
WordPress database error: [Duplicate entry 'cron' for key 'option_name']
INSERT INTO `xm_options` (`option_name`, `option_value`, `autoload`) VALUES ('cron', 'a:2:{i:1553652240;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)