A ton of errors since server upgrade with php7 and mysql 5.7

197 Posts

jonahnaylor Reply #1, 10 years, 1 month ago

Hi just upgraded a server with ubuntu 16.04 and now I have a ton of errors on one of my modx sites:

(ERROR @ /home/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error HY000 executing statement: 
Array
(
    [0] => HY000
    [1] => 3065
    [2] => Expression #1 of ORDER BY clause is not in SELECT list, references column 'bobrayisthebest.tvtpl.rank' which is not in SELECT list; this is incompatible with DISTINCT
)

I hope someone can please help me fix this?

Thanks, any help really appreciated.

This question has been answered by paulp. See the first response.

Yorkshire UK based hosting provider: https://www.simulant.uk

discuss.answer

1,572 Posts

Paulp Reply #2, 10 years, 1 month ago

Seems to be a issue with mysql 5.7

https://github.com/modxcms/revolution/issues/12826#issue-121693438

197 Posts

jonahnaylor Reply #3, 10 years, 1 month ago

Quote from: paulp at Aug 22, 2016, 09:15 AM

Seems to be a issue with mysql 5.7

https://github.com/modxcms/revolution/issues/12826#issue-121693438

Hi thanks, that patch file fixes it for Modx 2.5.1

Much appreciated

Yorkshire UK based hosting provider: https://www.simulant.uk

1,572 Posts

Paulp Reply #4, 10 years, 1 month ago

Quote from: jonahnaylor at Aug 22, 2016, 05:48 AM

Quote from: paulp at Aug 22, 2016, 09:15 AM
Seems to be a issue with mysql 5.7

https://github.com/modxcms/revolution/issues/12826#issue-121693438

Hi thanks, that patch file fixes it for Modx 2.5.1

Much appreciated

Glad it's worked for you

☆ A M B ☆
1,031 Posts

Jako Reply #5, 10 years, 1 month ago

Should be fixed with https://github.com/modxcms/revolution/pull/13098 in 2.6.2.

Answered A ton of errors since server upgrade with php7 and mysql 5.7