Fermé

Fix an error with mysql after server migration

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.

Compétences : MySQL, PHP, Administration de Bases de données, Linux

En voir plus : fix error 404 server problem, mysql server migration php, opencart notice error mysql server gone away, error mysql server gone away opencart, opencart error mysql server gone away error 2006, notice error mysql server gone away error 2006, opencart error notice error mysql server gone away, error mysql server gone away error 2006, php notice error mysql server gone away, Need Urgent fix of Mysql server on Ubuntu, aws the mysql server is running with the --read-only option, the mysql server is running with the --read-only option aurora, microsoft sql server migration assistant 8.1 for access, the mysql server is running with the --secure-file-priv option so it cannot execute this statement, syntax error or access violation 1055 expression #1 of select list is not in group by clause laravel, cmdphp error a db cell failed!, error mysql server has gone away, mysql server not running in zimbra

Concernant l'employeur :
( 11 commentaires ) Perth, Australia

Nº du projet : #30109168

33 freelances font une offre moyenne de 24 $ pour ce travail

vili1977

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1033 Commentaires)
7.6
(792 Commentaires)
7.6
(517 Commentaires)
7.4
(319 Commentaires)
7.2
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(507 Commentaires)
7.3
jbosseu

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(385 Commentaires)
7.0
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(134 Commentaires)
6.7
waleedakram2

Hi I can start your project right away and can fix the query issue. Please send me a message in a chat so we can discuss your requirements in detail. Thank you!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(95 Commentaires)
5.8
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(70 Commentaires)
6.2
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(103 Commentaires)
5.9
alkajain2906

I am a senior Wordpress/ WooCommerce PHP web developer, fluent English speaker with 7+years experience in solving problems and building complex sites with custom features.I can help I create custom Wordpress themes an Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(61 Commentaires)
6.0
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(84 Commentaires)
6.0
SqlDevelopment

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(35 Commentaires)
5.2
malikbilal15

hi I can fix it right now thank bilal

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(126 Commentaires)
5.7
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:Word Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(80 Commentaires)
4.9
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 w Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(42 Commentaires)
4.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(33 Commentaires)
4.7
(16 Commentaires)
4.5
mepsd

This is not something chargeble run this query SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Thanks Paras Suthar

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(31 Commentaires)
4.8