Fix an error with mysql after server migration

$10-30 USD

Closed

Posted

almost 3 years ago

$10-30 USD

Paid on delivery

Fix an error with mysql after server migration The error upon running a script is: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '####.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Googling seems to suggest its related to moving from an old version of mysql to a new one. The script itself is very old also.

MySQL

PHP

Database Administration

Linux

Project ID: 30109168

About the project

31 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

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

31 freelancers are bidding on average $24 USD for this job

@vili1977

Hello. I wouldl ike to help you wuth fixing mysql issue after migrataion. I have experience. Please read my feedbacks. Thank you.

$20 USD in 1 day

4.9

(1175 reviews)

7.7

@sat12

i fixed similar issue few times. it shows when the old script run in mysql new version. group by needs to modify in that query. in 1-2 places may there..where it needs to modify query.

$30 USD in 1 day

4.8

(532 reviews)

7.3

@jbosseu

Have worked with servers and webhosting for many years. Can help you with this issue. Let me know.

$25 USD in 1 day

5.0

(435 reviews)

7.1

@sanu61

Hi, greeting of the day , your job detail got my attention , i can fix your mysql issue start right now lets connect here thanks Javed

$25 USD in 1 day

5.0

(140 reviews)

6.6

@ShrineWeb

I have some queries in relation to the specifications of the project. Could we please have a word? My Skills: PHP, Database Administration, MySQL and Linux

$10 USD in 14 days

4.8

(103 reviews)

6.5

@TechnicalKnight

I am php and MySQL expert. I can help you in fixing the issue. I can fix within half an hour. Please give me details and access over chat

$30 USD in 1 day

4.9

(158 reviews)

6.2

@purplemaestro

Hi. Hope are doing fine. I have high level expertise in MYSQL. I can fix this issue right away. Will provide you top quality work for sure. I can start right now.

$20 USD in 1 day

5.0

(121 reviews)

6.4

@webcodeater

i can fix your error right now,i can fix your error right now,i can fix your error right nowi can fix your error right now,i can fix your error right now

$20 USD in 1 day

5.0

(96 reviews)

5.8

@sandeepohri1

Hello, I have gone through your project description and I can confirm that l am deem fit to deliver it as expected. I am a senior software developer with plenty of experience and creativity. Kindly contact me so that we can discuss more on the specifics. Thank you

$19 USD in 1 day

5.0

(142 reviews)

6.0

@jagadishcse143

Hello, I'm Jagadish, Senior Web Developer 7+ years of experience ✤I can do this task, I can start the work right away! ✤I understood your requirements & I can complete the project as per your requirements. ✤Skills:WordPress,PHP,Javascript,MySQL,HTML,CSS,Angular. ✤Please send me a message in a chat so we can start the project Wating for your reply... Thank you !

$10 USD in 1 day

5.0

(90 reviews)

5.0

@gigadev0

Dear sir! I'm interested in your project. I have experience with 5 years experience of dealing with Nodejs and MySQL. I can finish your project on time. I hope to work on the project with you. Regards, Yurii

$50 USD in 7 days

5.0

(6 reviews)

5.1

@SqlDevelopment

I can qualitatively assist with required troubleshooting because I am exceptionally well qualified SQL developer with 10+ years' seniority.

$30 USD in 1 day

5.0

(37 reviews)

5.3

@falaksafi

Hi, I am an expert system admin. I have good knowledge of MySQL and I can debug and fix the error. I am ready to start this now. Drop a text. Thanks Safi

$25 USD in 7 days

5.0

(47 reviews)

5.4

@malikbilal15

hi I can fix it right now thank bilal

$20 USD in 1 day

4.8

(135 reviews)

5.7

@mohitcloudoserv

Hello! I am system admin,I have 6+ years of experience, i'm only new here. Will resolve the issues as per your requirement, and have expertise in the relevant field. Ping me for further discussion Thanks

$25 USD in 1 day

5.0

(27 reviews)

4.8

@skanusha504

Hey, I have worked previously in mysql database development. I can complete the task in one day. we can discuss more in the chat.

$20 USD in 1 day

5.0

(6 reviews)

4.8

@olaoluwa2093

Hello, Thank you for the clear details of the project, i have gone through it and understand perfectly what needs to be done. I am a lead sys admin with over 5 years of experience managing over 250 servers with over 40,000 different application deployments hosted on them, give me some time to have a look for you and get the issue fixed in the fastest time possible, I look forward to hear from you soon.

$30 USD in 1 day

5.0

(19 reviews)

4.5

@mindmagicexpert

Hey, I'm interested in your project. i am ready to fix it right now. Please send me a message so that we can discuss more. Thank you

$20 USD in 2 days

4.7

(35 reviews)

4.8

@Webstudi0

Hi there, I am a certified Linux system administrator with rich experience in MySQL. I can fix the issue for you, have done this before. Send me a message to discuss the details. Best regards, Dmitri

$25 USD in 1 day