Title: Error after update Last modified: June 29, 2017 --- # Error after update * Resolved [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/) * WordPress database error: [Unknown column ‘wp_posts.ID’ in ‘order clause’] * SELECT SQL_CALC_FOUND_ROWS ic452_posts.ID FROM ic452_posts WHERE 1=1 AND ( ic452_posts. ID NOT IN ( SELECT object_id FROM ic452_term_relationships WHERE term_taxonomy_id IN (198) ) ) AND ic452_posts.post_type = ‘product’ AND (ic452_posts.post_status = ‘publish’ OR ic452_posts.post_status = ‘acf-disabled’ OR ic452_posts.post_status = ‘private’) GROUP BY ic452_posts.ID ORDER BY FIELD(wp_posts.ID,’40’) DESC LIMIT 0, 10 * Used to work great but not anymore! All products missing from archive while enabled. Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Author [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/) * (@pmbaldha) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9274314) * I am working on it. The update will available soon. * Plugin Author [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/) * (@pmbaldha) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9274511) * I have updated plugin. Can you please test it? Please update me. * Thread Starter [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9276435) * Thank you I have updateed but no this has not fixed my issue. 🙁 * Thread Starter [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9276468) * It only happens when a post is actually featured, I am not sure if it happened right after update. I have disabled all plugins and using default storefront theme to test. * Plugin Author [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/) * (@pmbaldha) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9277847) * Hello,I have again tested in testing environment and i is working properly. I seems that you have just updated woocommerce, you have not run WooCommerce data update. In admin side,you might be receving notification for woocommerce data update process. If you are still facing issue, please donot hesitate to reply here. I am always happy to help. * Thread Starter [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9283158) * Hi thank you for your reply. The database update was processed and I see no notifications. * It used to work I am not sure when it stopped working it just did all of a sudden. * ### WordPress Environment ### * Home URL: [https://icenta.staging.ateliercloud.co.uk](https://icenta.staging.ateliercloud.co.uk) Site URL: [https://icenta.staging.ateliercloud.co.uk](https://icenta.staging.ateliercloud.co.uk) WC Version: 3.1.0 Log Directory Writable: ✔ WP Version: 4.8 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_GB * ### Server Environment ### * Server Info: Apache PHP Version: 7.0.20 PHP Post Max Size: 100 MB PHP Time Limit: 0 PHP Max Input Vars: 5000 cURL Version: 7.54.0 OpenSSL/1.0.2k * SUHOSIN Installed: – Max Upload Size: 100 MB Default Timezone is UTC: ✔ fsockopen/ cURL: ✔ SoapClient: ❌ Your server does not have the SoapClient class enabled– some gateway plugins which use SOAP may not work as expected. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ * ### Database ### * WC Database Version: 3.1.0 WC Database Prefix: ic452_ woocommerce_sessions: ✔ woocommerce_api_keys: ✔ woocommerce_attribute_taxonomies: ✔ woocommerce_downloadable_product_permissions: ✔ woocommerce_order_items: ✔ woocommerce_order_itemmeta: ✔ woocommerce_tax_rates: ✔ woocommerce_tax_rate_locations: ✔ woocommerce_shipping_zones: ✔ woocommerce_shipping_zone_locations: ✔ woocommerce_shipping_zone_methods: ✔ woocommerce_payment_tokens: ✔ woocommerce_payment_tokenmeta: ✔ MaxMind GeoIP Database: ✔ * ### Security ### * Secure connection (HTTPS): ✔ Hide errors from visitors: ❌Error messages should not be shown to visitors. * ### Active Plugins (24) ### * Advanced Custom Fields PRO: by Elliot Condon – 5.5.14 Contact Form 7 Conditional Fields: by Jules Colle – 1.3.4 Contact Form 7 – Dynamic Text Extension: by Chris Mavricos SevenSpark – 2.0.2.1 * Contact Form 7: by Takayuki Miyoshi – 4.8 Custom Post Type UI: by WebDevStudios– 1.5.4 DHL Express/DHL Paket WooCommerce Shipping with Print Label: by Xadapter– 3.0.6 Get Tweets in PHP: by Netgloo – 1.2 Google Analytics Dashboard for WP ( GADWP): by Alin Marcu – 5.0.1 Regenerate Thumbnails: by Alex Mills (Viper007Bond)– 2.2.6 Relevanssi: by Mikko Saari – 3.5.11 Search & Replace: by Inpsyde GmbH – 3.1.2 Simple 301 Redirects: by Scott Nellé – 1.07 Simple Sitemap: by David Gwyer– 2.1 Opt-In Content Locker: by Halfdata Inc. – 2.62 * UberMenu 3 – The Ultimate WordPress Mega Menu: by Chris Mavricos SevenSpark – 3.2.7 * WooCommerce WorldPay Gateway: by Add On Enterprises (Andrew Benbow) – 3.6.0 WooCommerce Max Quantity: by Isabel Castillo – 1.4.3 WooCommerce Tab Manager: by SkyVerge – 1.8.0 – 1.8.2 is available WooCommerce TM Extra Product Options: by themecomplete – 4.5.3 WooCommerce: by Automattic – 3.1.0 Yoast SEO: by Team Yoast – 4.9 WP-PageNavi: by Lester ‘GaMerZ’ Chan – 2.92 Wordpress user extra fields: by Lagudi Domenico – 9.6 YITH WooCommerce Wishlist Premium: by YITHEMES– 2.1.2 * ### Settings ### * API Enabled: ✔ Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) * Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated- 5 (rated-5) * ### WC Pages ### * Shop base: #4 – /shop/ Basket: #5 – /basket/ Checkout: #6 – /checkout/ My account:# 7 – /my-account/ * ### Theme ### * Name: iCenta 2017 Version: 1.0.0 Author URL: [http://example.com](http://example.com) Child Theme: ✔ Parent Theme Name: Storefront Parent Theme Version: 2.2.4 Parent Theme Author URL: [https://woocommerce.com/](https://woocommerce.com/) WooCommerce Support: ✔ * Thread Starter [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9283164) * I have tested with default Storefront theme and no other plugins other than WooCommerce with no luck. * Plugin Author [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/) * (@pmbaldha) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9284765) * Hi Amazorize, * I have tested with storefront theme also and it is working fine. I would like to clarify that feature products comes first in default sorting. Can you please give me feature products in your site? It will help me to investigate the issue. * Thank You. * Thread Starter [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9304536) * Hi Prashant, yeah we are on default sorting but still getting that error message at the top of the site and no products appearing in archive. * WordPress database error: [Unknown column ‘wp_posts.ID’ in ‘order clause’] SELECT SQL_CALC_FOUND_ROWS ic452_posts.ID FROM ic452_posts WHERE 1=1 AND ( ic452_posts. ID NOT IN ( SELECT object_id FROM ic452_term_relationships WHERE term_taxonomy_id IN (198) ) ) AND ic452_posts.post_type = ‘product’ AND (ic452_posts.post_status = ‘publish’ OR ic452_posts.post_status = ‘acf-disabled’ OR ic452_posts.post_status = ‘private’) GROUP BY ic452_posts.ID ORDER BY FIELD(wp_posts.ID,’3987′,’3979′,’ 40’) DESC, ic452_posts.menu_order ASC, ic452_posts.post_title ASC LIMIT 0, 10 * Any help would be much appreciated! This plugin was super important to us. I am not sure if we made a change that broke it but I have tried disabling all other plugins other than WooCommerce and changing to default theme but still with no luck. * Thread Starter [Adam Greenough](https://wordpress.org/support/users/amazorize/) * (@amazorize) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9304583) * Hi, I did some digging and worked it out. The plugin does not support custom database prefixes! I have just added our own prefix in in place of wp_ in the plugin code but would be great to see this fixed in future release. 🙂 * Plugin Author [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/) * (@pmbaldha) * [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9308966) * I have updated plugin to resolve the issue. Please check it. Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Error after update’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/featured-products-first-for-woocommerce_f4f5f7. svg) * [Featured Products First for WooCommerce - A Extension of WooCommerce (WooCommerce Addon Plugin)](https://wordpress.org/plugins/featured-products-first-for-woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/featured-products-first-for-woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/featured-products-first-for-woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/featured-products-first-for-woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/featured-products-first-for-woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/featured-products-first-for-woocommerce/reviews/) * 11 replies * 2 participants * Last reply from: [Prashant Baldha](https://wordpress.org/support/users/pmbaldha/) * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/error-after-update-101/#post-9308966) * Status: resolved