Tamamlanmış

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)

Beceriler: HTML, MySQL, PHP, Yazılım Mimarisi, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 24 değerlendirme ) Bolwarra Hts, Australia

Proje NO: #17621543

Seçilen:

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% AUD
(32 Değerlendirme)
4.6

Bu iş için 13 freelancer ortalamada $32 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(195 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(94 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(39 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(47 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(43 Değerlendirme)
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, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(15 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(16 Değerlendirme)
4.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(21 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(4 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(5 Değerlendirme)
3.0
bhrugeshpatel

hey i can do it

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(7 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0