Find Jobs
Hire Freelancers

Fix a WooCommerce Wordpress MySQL corruption

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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) ) AND 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.
Project ID: 17281995

About the project

68 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 always make deal on price. Tnx, and hope to hear you soon.
$55 USD in 2 days
4.9 (553 reviews)
8.0
8.0
68 freelancers are bidding on average $159 USD for this job
User Avatar
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 one of your meta key in your where condition as well. Still you get any error then you have to provide me access of your query and phpmyadmin to execute this query.
$77 USD in 2 days
4.9 (757 reviews)
8.8
8.8
User Avatar
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 designing websites in LAMP environment and would love to join your project. I have developed front-end and back-end using PHP/MYSQL. I am interested in your project and will like to discuss budget later. I have a lot of experience and knowledge in Wordpress Theme Development, Theme Customization, Custom Plugin Development, CMS Development, Website Development, Data Migration, Multisite Development, PSD to WordPress, WordPress Hosting, SEO Plugins for WordPress, WordPress Blog Development, WooCommerce WordPress Theme Development and so on... -Responsible for creating and developing user-friendly, customer-centric and stable SEO friendly website. -Most people like my work experience I GUARANTEE their sites to be mobile compatible & SEO friendly & I help my client how to manage sites. I am ready to work with you right away, Please let me know when we can discuss further detail over chat here. Looking for your response. Warm Regards, Sonali R.
$388 USD in 3 days
4.9 (257 reviews)
8.4
8.4
User Avatar
//** 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 sure you will love to work with us. We’ve built websites for several brands around the world with great success, and are quite excited to get to work on yours.
$180 USD in 2 days
4.9 (402 reviews)
8.1
8.1
User Avatar
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. Looking forward to working with you. Thank you.
$333 USD in 5 days
4.9 (3791 reviews)
7.6
7.6
User Avatar
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
4.8 (251 reviews)
7.4
7.4
User Avatar
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 be happy to work on your project I have a good experience in this job. if you award me, I will fix your website. I am available at full time and can start immediately. If you award me, I can complete quickly. Best Regard. Thanks.
$155 USD in 3 days
4.9 (226 reviews)
7.1
7.1
User Avatar
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
4.9 (206 reviews)
7.3
7.3
User Avatar
Hi. How are you? I saw your descript about project carefull and i'm very interesting your project. Owing to my rich experience to build many woocommerce websites by using wordpress, i can do this project perfectly. I have many top skills like CSS,HTML ,PHP , BOOTSTRAP,JAVASCRIPT,AJAX and so on. And then ,if you would like to aggree with me , i do my best. Thanks. ***&*&*
$155 USD in 3 days
5.0 (42 reviews)
6.7
6.7
User Avatar
Hello I am a professional WordPress and woo commerce developer so I can Fix a WooCommerce Wordpress MySQL corruption very easily. Thanks
$155 USD in 3 days
4.9 (156 reviews)
6.9
6.9
User Avatar
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
4.9 (177 reviews)
6.8
6.8
User Avatar
hello sir i am expert in MySQL, PHP, WordPress i am able to do this work you will satisfy with my work i can do this work asap thank you
$111 USD in 1 day
4.9 (233 reviews)
6.9
6.9
User Avatar
Hello, Hope you are doing well .. !!! I would like to assist you !! I can fix the issue. Can you please send me the website URL & the FTP login so that I can fix the issue. I have extensive experience of 8+ years in this field with the team of expert designer and developer which can provide you best and timely services and I have worked on more than 250+ websites. I highly value professionalism and strictly accountable to represent my client brand and I believe in long term relation. I am totally comfortable with the Audio/Video call. Please feel free to get back to me with any further questions you might have. Thanks. Abbas
$277 USD in 3 days
4.8 (125 reviews)
6.9
6.9
User Avatar
Fix a WooCommerce Wordpress MySQL corruption Hi sir/madam, I am an expert web programmer with more than 6 years’ experience in latest web development technologies.
$124 USD in 3 days
5.0 (35 reviews)
6.4
6.4
User Avatar
Hello, I have read your JD and I can do this. I have a team who are working in MySQL, PHP, WordPress more than the 4 years. Please drop me a massage for further discussion. Regards, Pinki.
$155 USD in 3 days
4.7 (75 reviews)
6.3
6.3
User Avatar
Hi there, Wishes :) I am an experienced LAMP developer with high-end MySQL programming skills. I can fix your code issue. Which MySQL version you're are working with? Anxiously waiting for your response. Regards, Varinder
$100 USD in 1 day
5.0 (3 reviews)
5.1
5.1
User Avatar
Hi, I can fix your error and can fulfill your requirement with efficiency as I am a professional WordPress/Woocommerce Expertise Web Designer/Developer. I am new on freelancer but I have positive attitude toward work and have 5+ year of working experience. I'd like the opportunity to discuss this job further with you and start immediately if given the chance. Looking forward to hear from you soon. Thank you for your time. Regards, Aditya.
$155 USD in 4 days
5.0 (15 reviews)
5.3
5.3
User Avatar
Dear sir, I am very interested for this WP Mysql error fixing project. I have 8+ Year of Experience in this field and I can surely do this project , i work with my team who always looking for such type of project . so please sir try to give me one chance to prove my strength and quality of work. Actually sir money is not a matter i only want to do this project if you feel good with my work then only after you can award me and pay for this project , me and my experienced team believe in accuracy and quality of work. Trust me sir i never disappoint you at least you can give me one chance. Please check my profile in freelancer.com https://www.freelancer.com/u/mdubey.html Please message me on PM for further discussion. Thanks & Regards Mohit
$150 USD in 4 days
4.3 (69 reviews)
6.1
6.1
User Avatar
I am a PHP/Wordpress Developer with 7 years of experience. I have developed many websites and e-commerce applications using wordpress/woocommerce. ## I have developed many responsive website in wordpress. Please explain project in detail. Brief about my skills: - I can work on front-end as well as back-end development. - I have worked on themes like theme forest, cake theme, Genesis theme, avada themes etc. - I have performed all the tasks like PSD to HTML/wordpress page, customizing theme or plugin,plugin development, API integration, bug fixing, optimizing websites, and mobile responsive design. - I have mastered with skills like MySQL, HTML5, CSS3, jQuery, AJAX, javascript, bootstrap. I will solve your error quickly. Please contact me to discuss further.
$155 USD in 3 days
4.9 (15 reviews)
5.1
5.1
User Avatar
Hello, I have read your requirement and i will fix your issue of MySql. I have 5+ year experience of Wordpress, PHP and MySql. Waiting for your kind reply Thank you
$88 USD in 3 days
5.0 (69 reviews)
5.2
5.2
User Avatar
i will do this job super fast and perfect. having 6+ years of experience in wordpress development and database issues. regards
$200 USD in 3 days
5.0 (21 reviews)
4.6
4.6

About the client

Flag of UNITED STATES
Avon, United States
5.0
19
Payment method verified
Member since Nov 17, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.