hi there,

i had this bug (after fresh Slideshow install on freshly updated October)

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'mydatabasename.flosch_slideshow_slides.sort_order' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select flosch_slideshow_slides.slideshow_id, count(*) as count from flosch_slideshow_slides where flosch_slideshow_slides.slideshow_id in (1) group by flosch_slideshow_slides.slideshow_id order by sort_order asc)

thanks for lights

Hey Pat, thanks for reporting that ;

I never had such an issue myself, could you please tell me where do you get this?

(In october's back-end? Slideshows list page or when you try to create / update a Slideshow? In the front-end component?)

hi flosh, thanks for reactivity

i got this in back-end here :

mysite/accesadmin/flosch/slideshow/slideshows

in front, i had this (surely the same error)

An exception has been thrown during the rendering of a template ("No query results for model [Flosch\Slideshow\Models\Slideshow].") in "mythemepath/layouts/homepage.htm" at line 6.

i have this in local dev environnement with wamp64 and mysql 5.7.14 (and this work in my dev remote server and in local environnement of my mate so perhaps it is due to my local mySQL version)

seems it is a start of response here :-)

http://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql

see the azerafati response

Last updated 7 years ago

I am personaly using mysql 5.7.9 locally, with the only_full_group_by option aswell.

However, I do not think the front error is related... You seem to try to display slides but have no result. Maybe are you trying to loop on an empty var? A if condition on the slides number could prevent this?

I will try to see if I find something about mysql changelog and see what is the cause of the back-end error.

I tried to reinstall on a backuped version but same back end error.

Is it possible that the problem comes from the upgrade of the latest version of OctoberCMS ? locally i have the last System Version 382

Indeed and strangely, your slideshow works perfectly on our remote dev server with System Version 365

My stack trace says the bug trigger here (no surprise) Flosch\Slideshow\Controllers\Slideshows->listRender()

this method is handled here Backend\Behaviors\ListController->listRender()

Last updated 7 years ago

hi Flosh,

As it worked on the server, i just import all source files and database in my local environment and i have the same bug (without or without slides it is the same)

have you some idea ?

ok, this bug is not specific to your plugin, i had it on other plugin which try to process the same request type

seems it comes from my local configuration apologize for inconvenient and thank you

and now i have the reason :

http://stackoverflow.com/questions/41182801/october-cms-sql-request-incompatible-with-sql-mode-only-full-group-by

i open issue ticket on october github about

thanks dear :-)

EDIT: i doesn't open issue ticket because the problem comes from list query don't match with new mySQL standart as you can see in the stackoverflow page i notice above

Last updated 7 years ago