Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hello
I have a question for the next query:
INSERT into workperiod (`idResource`,`periodRange`,`periodValue`,
`submitted`,
`submittedDate`,
`validated`,
`validatedDate`,
`idLocker`,
`comment`,
`idle`) VALUES (25,'week','201722',0,NULL,1,SYSDATE(),1,NULL,0)
When I excecuted this query. The excecution returns an error
[SQL]
INSERT into workperiod (`idResource`,`periodRange`,`periodValue`,
`submitted`,
`submittedDate`,
`validated`,
`validatedDate`,
`idLocker`,
`comment`,
`idle`) VALUES (25,'week','201722',0,NULL,1,SYSDATE(),1,NULL,0)
Affected rows: 1
Time: 0.063s
This is an error.
The question is, why returns that error / alert
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Thanks for your help.
Regards.
Hi,
This issue is not in ProjeQtOr.
It occurs in schema PROFILING.
It seems to be a database issue.
So you should migrate your database to latest fix version of disable profiling or option sql_mode=only_full_group_by as pointed out by reported error.