Error after update

I am working on it. The update will available soon.

I have updated plugin. Can you please test it? Please update me.

Thank you I have updateed but no this has not fixed my issue. ??

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.

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.

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
Site URL: 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: https://example.com
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 2.2.4
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

I have tested with default Storefront theme and no other plugins other than WooCommerce with no luck.

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.

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.

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. ??

I have updated plugin to resolve the issue. Please check it.