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.

Kemahiran: MySQL, PHP, Wordpress

Lihat lagi: 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

Tentang Majikan:
( 19 ulasan ) Avon, United States

ID Projek: #17281995

Dianugerahkan kepada:


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 Lagi

$55 USD dalam 2 hari
(489 Ulasan)

70 pekerja bebas membida secara purata $160 untuk pekerjaan ini


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] Lagi

$170 USD dalam 4 hari
(977 Ulasan)

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 Lagi

$77 USD dalam 2 hari
(609 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(434 Ulasan)

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 Lagi

$213 USD dalam 3 hari
(244 Ulasan)

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 dalam sehari
(392 Ulasan)

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 Lagi

$388 USD dalam 3 hari
(226 Ulasan)
$222 USD dalam 3 hari
(147 Ulasan)

//** 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 Lagi

$180 USD dalam 2 hari
(308 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(113 Ulasan)
$155 USD dalam 3 hari
(205 Ulasan)

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 Lagi

$333 USD dalam 5 hari
(3752 Ulasan)

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 dalam 3 hari
(189 Ulasan)

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 Lagi

$166 USD dalam 3 hari
(248 Ulasan)

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] Lagi

$150 USD dalam sehari
(96 Ulasan)
$155 USD dalam 3 hari
(75 Ulasan)

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 dalam 10 hari
(203 Ulasan)
$155 USD dalam 3 hari
(67 Ulasan)

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 Lagi

$30 USD dalam sehari
(132 Ulasan)

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 dalam 3 hari
(123 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(132 Ulasan)