search

cYbercOsmOnauT / wysiwygsceditorphpbb

8 stars 11 forks source link

SQL-Error on 3.2 #22

Closed b-vetter closed 7 years ago

b-vetter commented 7 years ago

I get the following error on phpBB 3.2:

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'amzecho_phpbb_test2.phpwg_smilies.code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

AutoJunkie79 commented 7 years ago

I'm also on 3.2 and got something similar, but for MSSQL:

sqlerror

cYbercOsmOnauT commented 7 years ago

MSSQL is nothing I use. Let me take a look at it.

b-vetter commented 7 years ago

I using MySQL and PHP 7.1. ;)

cYbercOsmOnauT commented 7 years ago

Which MySQL version?

b-vetter commented 7 years ago

5.7.17

cYbercOsmOnauT commented 7 years ago

Can you try out the following? Open cosmo/sceditor/event/sce.php and change in line 69 the following GROUP BY smiley_url to GROUP BY smiley_url,code

b-vetter commented 7 years ago

It works perfect now! I have now a new problem: #23

AutoJunkie79 commented 7 years ago

This worked for me as well on MSSQL! Thank you!

cYbercOsmOnauT commented 7 years ago

5b272a0dc9c09b5c1de97a342ee96aa8744989b7 fixed this problem