search

flo-sch / slideshow-plugin

Slideshow Plugin for OctoberCMS : Manage Twitter Bootstrap carousels with additional content.
MIT License
7 stars 10 forks source link

SQL violation #10

Closed rluders closed 7 years ago

rluders commented 7 years ago

I'm getting this error, right after I installed the plugin and try to access his admin's page.

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '<table>.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: selectflosch_slideshow_slides.slideshow_id, count(*) as count fromflosch_slideshow_slideswhereflosch_slideshow_slides.slideshow_idin (1) group byflosch_slideshow_slides.slideshow_idorder bysort_orderasc)

rluders commented 7 years ago

Please, add it to your documentation:

You must edit the config/database.php and add the 'strict' => false to your mySQL configuration.