Database error with cron.php

  • Resolved aceone999

    (@aceone999)


    4 years, 10 months ago

    I get this once a day with cron. All plugins and wordpress are up to date on there latest stable releases. 

    WordPress-database-error Unknown column 'expiration' in 'where clause' for query DELETE FROM wp_yith_wcwl WHERE wishlist_id IN ( SELECT ID FROM wp_yith_wcwl_lists WHERE expiration < NOW() and user_id IS NULL ) von do_action_ref_array('yith_wcwl_delete_expired_wishlists'), WP_Hook->do_action, WP_Hook->apply_filters, YITH_WCWL_Cron->delete_expired_wishlists, WC_Data_Store->__call, YITH_WCWL_Wishlist_Data_Store->delete_expired
WordPress-database-error Unknown column 'expiration' in 'where clause' for query DELETE FROM wp_yith_wcwl_lists WHERE expiration < NOW() and user_id IS NULL von do_action_ref_array('yith_wcwl_delete_expired_wishlists'), WP_Hook->do_action, WP_Hook->apply_filters, YITH_WCWL_Cron->delete_expired_wishlists, WC_Data_Store->__call, YITH_WCWL_Wishlist_Data_Store->delete_expired
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author YITHEMES

    (@yithemes)

    It seems that for some reason db structure of wishlist table wasn’t correctly updated on your installation after upgrade to version 3.0

    My suggestion here is to repeat automatic update procedure
    In order to do so, just update yith_wcwl_db_version option to value 2.0.0 and refresh your admin dashboard

    You can update option value directly from WP admin, if you’re logged in as admin, by visiting /wp-admin/options.php page

    Thread Starter aceone999

    (@aceone999)

    Thx, that solved it.

    Plugin Author YITHEMES

    (@yithemes)

    You are welcome!

    We are doing our best to improve our plugins. Our target is to develop and release the best free plugins for WooCommerce, but to achieve this we need your help. Please leave a good review to support us and help our growth ??

    Did you mean 3.0.0? I tried this but got an error: 

    WordPress database error: [Incorrect index name "]
ALTER TABLE wp_yith_wcwl ADD KEY (prod_id)

    (backticks omitted…)

    It then reverted back to the previous setting.

    • This reply was modified 4 years, 10 months ago by beezwings.
    • This reply was modified 4 years, 10 months ago by beezwings.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database error with cron.php’ is closed to new replies.