Selesai

Make 5 php / mysql Queries sql 5.7 Compatible

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

Location:

/public_html/includes/classes/[login to view URL] (Line 728)

Keahlian: HTML, MySQL, PHP, Perancangan Perangkat Lunak, SQL

Lihat lebih lanjut: mysql function example, mysql functions in php pdf, mysql functions in php w3schools, php mysql query, mysql functions in php, php mysql example, php mysqli functions, php mysql connect, php mysql load sql, complex php mysql queries, stars rating php mysql sql, sql part time hate room php mysql, php mysql queries css instead tabs, php mysql products compatible products, php mysql sql programmers india, sql database convert joomla joomla php mysql, php mysql capture bad sql, sql asp php mysql, mysql import sql php, php mysql load sql file

Tentang Pemberi kerja:
( 24 ulasan ) Bolwarra Hts, Australia

ID Proyek: #17621543

Diberikan kepada:

pks11

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

$20 AUD dalam 1 hari
(32 Ulasan)
4.6

13 freelancer menawar dengan rata-rata $32 untuk pekerjaan ini

$25 AUD dalam 1 hari
(195 Ulasan)
7.3
maxtechsl

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 Lebih banyak

$30 AUD dalam 1 hari
(94 Ulasan)
6.5
manjeet2017

24 Hi I have read your project details and I am keen to work on your project. I have appended below my list of work to discuss your project: 1. [login to view URL] --- Framework: PHP, Javascript Library (jQuer Lebih banyak

$25 AUD dalam 1 hari
(39 Ulasan)
5.0
jamesmartin81

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 Lebih banyak

$47 AUD dalam 1 hari
(47 Ulasan)
5.1
bhanderirakesh

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 Lebih banyak

$15 AUD dalam 1 hari
(43 Ulasan)
4.3
ankitbagre2000

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, Lebih banyak

$30 AUD dalam 1 hari
(15 Ulasan)
4.3
infobeckons

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 Lebih banyak

$25 AUD dalam 1 hari
(16 Ulasan)
4.6
$29 AUD dalam 1 hari
(21 Ulasan)
4.7
radhesuthar86

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 Lebih banyak

$30 AUD dalam 1 hari
(4 Ulasan)
3.1
nodinh325

Hi, I am professional in Web back-end development and Web front-end. I have good experience with a lot of experiences such as php, javascript, angularjs, bootstrap, jquery, css3, html5 etc. So far, I have accompli Lebih banyak

$100 AUD dalam 1 hari
(5 Ulasan)
3.0
bhrugeshpatel

hey i can do it

$15 AUD dalam 1 hari
(7 Ulasan)
1.5
evonsystems7

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 Lebih banyak

$25 AUD dalam 1 hari
(0 Ulasan)
0.0