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`)
 

Attachments

  • Screen Shot 2019-03-26 at 10.04.12 PM.png
    Screen Shot 2019-03-26 at 10.04.12 PM.png
    1.5 MB · Views: 12
  • Screen Shot 2019-03-26 at 9.43.11 PM.png
    Screen Shot 2019-03-26 at 9.43.11 PM.png
    257.2 KB · Views: 12
  • Screen Shot 2019-03-26 at 9.43.06 PM.png
    Screen Shot 2019-03-26 at 9.43.06 PM.png
    7.8 KB · Views: 9

Mar

Moderator
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.
This is mixed up. Do you mean you are using Alidropship Woo plugin?

I firmly believe this app has somehow created an error and I am a lost in how to fix it. Help please, anyone!!
What app is this?
 

patayintattoo

New Member
Hi Mar - I have a woocommerce store template for my wordpress site. And I also have the alidrop ship plugin. Everything works fine until I attempt to change my markup forumla. That is when I the status bar freezes when I attempt to update prices. In addition, code is appear on the top of my page. This suddenly appear immediately after I attempted to change my markup formula.

Some back story, this is my second time having this experience. The first time was resolved through the help of this community, however when I attempted to change my formula again, I have encountered this current problem.
 
Top