Title: Database error with cron.php
Last modified: January 1, 2020

---

# Database error with cron.php

 *  Resolved [aceone999](https://wordpress.org/support/users/aceone999/)
 * (@aceone999)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/database-error-with-cron-php/)
 * 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](https://wordpress.org/support/users/yithemes/)
 * (@yithemes)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/database-error-with-cron-php/#post-12303650)
 * 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](https://wordpress.org/support/users/aceone999/)
 * (@aceone999)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/database-error-with-cron-php/#post-12303774)
 * Thx, that solved it.
 *  Plugin Author [YITHEMES](https://wordpress.org/support/users/yithemes/)
 * (@yithemes)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/database-error-with-cron-php/#post-12303791)
 * 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](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/reviews/)
   to support us and help our growth 🙂
 *  [beezwings](https://wordpress.org/support/users/beezwings/)
 * (@beezwings)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-with-cron-php/#post-12324814)
 * 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 6 years, 4 months ago by [beezwings](https://wordpress.org/support/users/beezwings/).
    -  This reply was modified 6 years, 4 months ago by [beezwings](https://wordpress.org/support/users/beezwings/).

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

The topic ‘Database error with cron.php’ is closed to new replies.

 * ![](https://ps.w.org/yith-woocommerce-wishlist/assets/icon-128x128.gif?rev=3129302)
 * [YITH WooCommerce Wishlist](https://wordpress.org/plugins/yith-woocommerce-wishlist/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/yith-woocommerce-wishlist/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/)
 * [Active Topics](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/yith-woocommerce-wishlist/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [beezwings](https://wordpress.org/support/users/beezwings/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/database-error-with-cron-php/#post-12324814)
 * Status: resolved