WordPress database errors

  • Resolved shadyr

    (@shadyr)


    7 years, 10 months ago

    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

    (@stockmanagementlabs)

    7 years, 10 months ago

    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

    (@stockmanagementlabs)

    7 years, 10 months ago

    Hi Shadyr,

    Do you still need help on this?

    Pavel

    Thread Starter shadyr

    (@shadyr)

    7 years, 10 months ago

    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

    (@stockmanagementlabs)

    7 years, 10 months ago

    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.