This project requires a very skilled LAMP developer who knows MySQL and database functions. No less than an expert is required, were the problem stumps other developers.
Here is part of the error code:
[02-Jul-2018 09:52:35 UTC] WordPress database error Unknown column 'wp_postmeta.meta_value' in 'order clause' for query SELECT SQL_CALC_FOUND_ROWS [login to view URL] FROM wp_posts LEFT JOIN wp_term_relationships ON ([login to view URL] = wp_term_relationships.object_id) WHERE 1=1 AND (
[login to view URL] NOT IN (
WHERE term_taxonomy_id IN (298)
wp_term_relationships.term_taxonomy_id IN (58)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') GROUP BY [login to view URL] ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 16 made by require('[login to view URL]'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
The code includes data from the wp_posts table which is trying to ORDER BY data from the wp_postmeta table. This may be the problem. We doubt this is coming from WordPress Core, therefore a plugin is hooking a callback into one of the WP_Query hooks. Something about that filter is broken and it is adding that wp_postmeta.meta_value bit indiscriminately.
We not only need to define the problem, but also provide a solution to the plugin developer for quick remedy. Since we have a clone of this site on another server, running the exact same theme, we are confident it is either due to a plugin or some type of database corruption. As it is, the shopping cart works fine and transaction continue without a problem. But this error may have disabled the Netmatter webhook and API to Brightpearl a couple times to date, disabling the trigger to feed data to the Woocommerce mothercloud.
A skilled developer will be able to fix this quickly. Absurd bids will be deleted immediately. Past projects proving the ability to troubleshoot MySQL effectively is essential.
70 freelancers are bidding on average $160 for this job
HI me as web developer and expert in woo-commerce error solve or debugging work.I love to do solve the issues in websites related to functional [login to view URL] you allow me then I can work for you.
Hi, I can Fix a WooCommerce Wordpress MySQL corruption for you according to your needs. Please share the complete details with me and let's get started. Open the chat window for more details.
sir we checked your project description and we can solve this problem for you .But we need cpanel and wp admin acess also we need seprate api and webhook so we can see what is the problem for this.