We upgraded mysql to 5.7 and we are getting a few SQL call errors in our PHP script.
Here is an example of one of the errors which we need fixed. we expect there to be 5 or so that need fixing, We have traced it back to this "In mysql 5.7 it is required to have the order by fields to be present in the select statement when using DISTINCT"
Expression #1 of ORDER BY clause is not in SELECT list, references column '[login to view URL]' which is not in SELECT list; this is incompatible with DISTINCT
SELECT p.*, FLOOR(prodratingtotal / prodnumratings) AS prodavgrating, pi.*, (SELECT discountpercent FROM isc_customer_group_discounts disc WHERE disc.discounttype='PRODUCT' AND disc.customergroupid='2' AND disc.catorprodid=[login to view URL]) AS prodgroupdiscount, (SELECT discountmethod FROM isc_customer_group_discounts disc WHERE disc.discounttype='PRODUCT' AND disc.customergroupid='2' AND disc.catorprodid=[login to view URL]) AS discountmethod FROM ( SELECT DISTINCT [login to view URL], FLOOR(prodratingtotal / prodnumratings) AS prodavgrating FROM isc_categoryassociations ca INNER JOIN isc_products p ON [login to view URL] = [login to view URL] WHERE p.prodvisible=1 AND [login to view URL] IN (159) ORDER BY [login to view URL] asc, [login to view URL] ASC LIMIT 0, 15 ) AS ca INNER JOIN isc_products p ON [login to view URL] = [login to view URL] LEFT JOIN isc_product_images pi ON ([login to view URL] = 1 AND [login to view URL] = [login to view URL])
/public_html/includes/classes/[login to view URL] (Line 728)
Hello, I have experience in writing optimized mysql query. I have worked on both 5.5. and 5.7 and fully understands differences. Please provide details. Thankyou
Bu iş için 13 freelancer ortalamada $32 teklif veriyor
Hello, i am ready to fix this issue, this happens after up-gradation of PHP ver and Mysql. I have done similar update for an earlier project and confident to update the site issue to your satisfaction. Please open mess Daha Fazla
I have experience of Website in PHP, Laravel, CodeIgnitor, Wordpress, Opencart, Woocommerce . We also have experience of making Android,Window and iphone application with ionic & phonegap. Benefits in working with us Daha Fazla
I have 3 year experience in wordpress and php platform. I had been completed many projects into this platform. It is my poftfolio : [login to view URL] [login to view URL] [login to view URL] www.rkfiber.c Daha Fazla
Hello, I'm interested in your project very well I'm good in SOLVING DATABASE QUERY’s. I’m quite well experienced in these kinds of jobs. Let's go ahead with me I want to service for you continuously. Now I am free, Daha Fazla
Hello Sir, I have read your job description regarding Make 5 php / mysql Queries sql 5.7 Compatible. I have 6+ year of experience in HTML, MySQL, PHP, Software Architecture, SQL. I have strong expertise to accomp Daha Fazla
Hi Radhe Shyam from india here.I can deliver this project successfully.I think I’m a great fit for this project because I have an interest in project and can deliver on time, according to your specifications. I hav Daha Fazla
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Daha Fazla