Title: WordPress database errors
Last modified: May 5, 2018

---

# WordPress database errors

 *  Resolved [shadyr](https://wordpress.org/support/users/shadyr/)
 * (@shadyr)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-errors-6/)
 * Hi,
    I would very much like to try your plugin, but after activation I get blank
   page and these errors. Any idea what could cause this? Many thanks. Radim
 * WordPress database error: [Table ‘wp_atum_order_items’ already exists]
    RENAME
   TABLE wp_atum_log_items TO wp_atum_order_items, wp_atum_log_itemmeta TO wp_atum_order_itemmeta;
 * WordPress database error: [Unknown column ‘log_item_id’ in ‘wp_atum_order_items’]
   
   ALTER TABLE wp_atum_order_items CHANGE `log_item_id` `order_item_id` BIGINT UNSIGNED
   NOT NULL AUTO_INCREMENT;
 * WordPress database error: [Unknown column ‘log_item_name’ in ‘wp_atum_order_items’]
   
   ALTER TABLE wp_atum_order_items CHANGE `log_item_name` `order_item_name` TEXT
   NOT NULL;
 * WordPress database error: [Unknown column ‘log_item_type’ in ‘wp_atum_order_items’]
   
   ALTER TABLE wp_atum_order_items CHANGE `log_item_type` `order_item_type` varchar(
   200) NOT NULL DEFAULT ”;
 * WordPress database error: [Unknown column ‘log_id’ in ‘wp_atum_order_items’]
   
   ALTER TABLE wp_atum_order_items CHANGE `log_id` `order_id` BIGINT UNSIGNED NOT
   NULL;
 * WordPress database error: [Unknown column ‘log_item_id’ in ‘wp_atum_order_itemmeta’]
   
   ALTER TABLE wp_atum_order_itemmeta CHANGE `log_item_id` `order_item_id` BIGINT
   UNSIGNED NOT NULL;
 * WordPress database error: [Can’t DROP ‘log_item_id’; check that column/key exists]
   
   ALTER TABLE wp_atum_order_itemmeta DROP KEY `log_item_id`, ADD KEY order_item_id(
   order_item_id);
 * Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate
   25166600 bytes) in /home/…/wp-includes/wp-db.php on line 1889

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

 *  Plugin Author [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * (@stockmanagementlabs)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-errors-6/#post-10251844)
 * Hi shadyr,
 * Thank you very much for the post.Sorry you have issue, however, I am sure we 
   can get this solved very quick.
 * Would you be so kind to give me all the details of your plugin versions, pls?
 * Id like to know the WP, WC, ATUM version you have installed and of course I really
   need to know your PHP version.
 * Thank you,
 * Pavel
 *  Plugin Author [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * (@stockmanagementlabs)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-errors-6/#post-10265721)
 * Hi Shadyr,
 * Do you still need help on this?
 * Pavel
 *  Thread Starter [shadyr](https://wordpress.org/support/users/shadyr/)
 * (@shadyr)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-errors-6/#post-10279776)
 * Hi Pavel,
 * I am sorry, I always miss emails from WordPress forums.
 * WP 4.9.5
    WC 3.3.4 ATUM 1.4.5 PHP 7.0.30-1~dotdeb+8.1
 * I tried to install and activate again and got the errors I sent before and also
   these:
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   SELECT option_value FROM wp_options WHERE option_name = ‘wppfm_feed_queue’ LIMIT
   1
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES (‘
   wppfm_feed_queue’, ‘a:0:{}’, ‘no’) ON DUPLICATE KEY UPDATE `option_name` = VALUES(`
   option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`
   autoload`)
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   SELECT option_value FROM wp_options WHERE option_name = ‘wppfm_background_process_is_running’
   LIMIT 1
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES (‘
   wppfm_background_process_is_running’, ‘false’, ‘no’) ON DUPLICATE KEY UPDATE `
   option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`),`
   autoload` = VALUES(`autoload`)
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   DELETE FROM wp_options WHERE option_name LIKE ‘%_batch_%’
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 
   THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN`
   type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END 
   AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters`
   WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP`
   WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP`
   WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE`
   type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER 
   BY `typeSort` ASC, `id` DESC
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 
   THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN`
   type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END 
   AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters`
   WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP`
   WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP`
   WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE`
   type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER 
   BY `typeSort` ASC, `id` DESC
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 
   THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN`
   type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END 
   AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters`
   WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP`
   WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP`
   WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE`
   type` IN (1, 8, 9, 2, 5, 6) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP())
   ORDER BY `typeSort` ASC, `id` DESC
 * WordPress database error: [Commands out of sync; you can’t run this command now]
   
   SELECT *, CASE WHEN `type` = 3 THEN 0 WHEN `type` = 4 THEN 1 WHEN `type` = 7 
   THEN 2 WHEN `type` = 6 THEN 3 WHEN `type` = 5 THEN 4 WHEN `type` = 9 THEN 5 WHEN`
   type` = 8 THEN 6 WHEN `type` = 2 THEN 7 WHEN `type` = 1 THEN 8 ELSE 9999 END 
   AS `typeSort`, CASE WHEN `type` = 3 THEN `parameters` WHEN `type` = 4 THEN `parameters`
   WHEN `type` = 1 THEN `IP` WHEN `type` = 9 THEN `IP` WHEN `type` = 5 THEN `IP`
   WHEN `type` = 6 THEN `IP` WHEN `type` = 7 THEN `IP` WHEN `type` = 2 THEN `IP`
   WHEN `type` = 8 THEN `IP` ELSE 9999 END AS `detailSort` FROM `wp_wfBlocks7` WHERE`
   type` IN (7) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER 
   BY `typeSort` ASC, `id` DESC
 * Radim
 *  Plugin Author [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * (@stockmanagementlabs)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-errors-6/#post-10284060)
 * Hi Shadir,
 * These error are site specific and only you are experiencing them.
 * We can try to help but need you to open a support ticket. This issue is unresolvable
   on WP forum I am afraid.
 * Stock Central – Help – Open Support ticket
 * Pavel

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

The topic ‘WordPress database errors’ is closed to new replies.

 * ![](https://ps.w.org/atum-stock-manager-for-woocommerce/assets/icon.svg?rev=1634692)
 * [ATUM WooCommerce Inventory Management and Stock Tracking](https://wordpress.org/plugins/atum-stock-manager-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/atum-stock-manager-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/atum-stock-manager-for-woocommerce/reviews/)

## Tags

 * [database errors](https://wordpress.org/support/topic-tag/database-errors/)
 * [fatal error](https://wordpress.org/support/topic-tag/fatal-error/)
 * [unknown column](https://wordpress.org/support/topic-tag/unknown-column/)

 * 4 replies
 * 2 participants
 * Last reply from: [Stock Management Labs](https://wordpress.org/support/users/stockmanagementlabs/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-errors-6/#post-10284060)
 * Status: resolved