Fix a WooCommerce Wordpress MySQL corruption

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 (

SELECT object_id

FROM wp_term_relationships

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.

Skills: MySQL, PHP, WordPress

See more: repair broken wordpress install, how to fix broken wordpress theme, wordpress repair service, define('wp_allow_repair' true) not working, wordpress repair files, reinstall wordpress without losing content, wordpress database repair plugin, wordpress repair plugin, wordpress site book this project 6 days, 16 hours left OPEN Bids 137 Avg Bid (AUD) $1051 Project Budget (AUD) $750 - $15, fix wordpress database corruption, wordpress mysql corruption issues, fix corrupt database mysql, mysql database design project visual studio 2008, import wordpress mysql, memory leak wordpress mysql, install wordpress mysql, wordpress mysql import, fix broken wordpress, transferring ownership wordpress mysql database, mysql php simple project

About the Employer:
( 19 reviews ) Avon, United States

Project ID: #17281995

Awarded to:


Hello. Wordpress expert ready to help you with SQL fix. I have more 7 years of Wordpress development experience and more 400 good reviews so all will be done with best quality. Free bugfinxing support. We can alway More

$55 USD in 2 days
(489 Reviews)

70 freelancers are bidding on average $160 for this job


Dear Inndesign. I have experienced with woocommerce, webhook I'm #1 WordPress Vietnam in here.. Our WordPress's projects: [login to view URL] Our latest United States's projects: [login to view URL] More

$170 USD in 4 days
(977 Reviews)

I have a solution : if you can try. if not then let me try on your server. replace this line ORDER BY wp_postmeta.meta_value+0 DESC with ORDER BY wp_postmeta.meta_value +0 DESC also you need to include o More

$77 USD in 2 days
(609 Reviews)

Hi there, Good to see your posting on freelancer... I have a huge experience in PHP, CSS, HTML, Bootstrap, java script, Java query and Woocommerce etc… I read your description in depth... open your message box with More

$250 USD in 3 days
(434 Reviews)

Hi Sir, I am experienced web developer and programmer; I can get rid of this thing for you in no time and provide you the best solution and fix [login to view URL] we chat so we can move on as soon as you share more details and More

$213 USD in 3 days
(244 Reviews)

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.

$100 USD in 1 day
(392 Reviews)

Hello there, Thank you for sharing good information. I understood your requirement and all is clear to me. I am able to fulfill your all requirements. I have got more than 7 years’ experience in developing and d More

$388 USD in 3 days
(226 Reviews)
$222 USD in 3 days
(147 Reviews)

//** READY TO START RIGHT AWAY **// With the reference of your description I would like to inform you that we are the most eligible freelancer here with whom you can discuss this project. After our discussion I am s More

$180 USD in 2 days
(308 Reviews)

Hello, Sir, Meet Experienced Website Designer and Developer, I have in more then 11 years experience. I am ready to start your project right away. I promise you will get good and quality work from me. I'm much interes More

$155 USD in 3 days
(113 Reviews)
$155 USD in 3 days
(205 Reviews)

Hello there, I am ready to start with you project right now. You can check my previous reviews. I have 1000s of satisfied clients and that speak for itself. Lets talk in Private messages and discuss the details. Look More

$333 USD in 5 days
(3752 Reviews)

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.

$200 USD in 3 days
(189 Reviews)

Hi, I am interested to go with this project as I have gone through with your requirement that you need some changes in the website. Please send me an URL of your website. Please have a look at my some the previo More

$166 USD in 3 days
(248 Reviews)

Hello Greeting Of the day!! I can help you for sure to Fix a WooCommerce Wordpress MySQL corruption Let’s discuss a little My web and mobile portfolio [login to view URL] More

$150 USD in 1 day
(96 Reviews)
$155 USD in 3 days
(75 Reviews)

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.

$200 USD in 10 days
(203 Reviews)
$155 USD in 3 days
(67 Reviews)

Hi, My work experience as shown in my profile have helped me develop mastery in Website design & development. From your brief, I noticed that you need to Fix a WooCommerce Wordpress MySQL corruption Please ha More

$30 USD in 1 day
(132 Reviews)

hello sir i know mysql database i am able to do this work you will satisfy with my work i can do this work asap this simple work for me thank you

$88 USD in 3 days
(123 Reviews)

Hi there I read the job description with interest. Now I am using godaddy and aws hosting . I have skills in HTML5 / CSS3, PHP, javaScpript/ JQuery, PhotoShop and other programming languages and software. I'll More

$155 USD in 3 days
(132 Reviews)