Forum > Support

database error

(1/3) > >>

Juan Carlos:
I just reinstalled for a clean hithub and now I have this error when clic in "Gallery":

SMFHacks:
If possible can you disable "ONLY_FULL_GROUP_BY" IN mysql sql mode that will fix that error
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by
if you're running MySQL 5.7.5+ is to edit your my.cnf file and remove the ONLY_FULL_GROUP_BY option from sql_mode.

Juan Carlos:
Sorry but I dont know how to do that.

The strange is that I dont change anything in my database that is MySQL 5.5

SMFHacks:
It's a setting in the my.ini or my.cnf for mysql

If not we will have to modify the gallery to include this line

--- Code: ---SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));

--- End code ---
But there will be an extra query on each gallery call.

Juan Carlos:
I installed the "lite version" and is working without errors.

Where I need to insert that code?

Navigation

[0] Message Index

[#] Next page