Posts merging

[3.2.0] SQL ERROR - Posts merging

[3.2.0] SQL ERROR

by Nimsiki » Sun Feb 05, 2017 10:34 pm

Hi!
I get a error, if i use it...

Code: Select all

SQL ERROR [ mysqli ]

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'hw-ff.phpbb_attachments.attach_id'; this is incompatible with sql_mode=only_full_group_by [1140]

SQL

SELECT attach_id, COUNT(*) as num_attachments FROM phpbb_attachments WHERE post_msg_id = 1389 AND in_message = 0

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/rxu/PostsMerging/core/helper.php
LINE: 206
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/rxu/PostsMerging/event/listener.php
LINE: 145
CALL: rxu\PostsMerging\core\helper->count_post_attachments()

FILE: (not given by php)
LINE: (not given by php)
CALL: rxu\PostsMerging\event\listener->posts_merging()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/functions_posting.php
LINE: 1456
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/posting.php
LINE: 1415
CALL: submit_post()
Nimsiki
Registered User
Posts: 7
Joined: Fri Nov 13, 2015 12:02 am
Contact:

Re: [3.2.0] SQL ERROR

by rxu » Mon Feb 13, 2017 3:44 pm

Nimsiki wrote:sql_mode=only_full_group_by
What if you switch this mode off for your SQL server?
rxu
Extensions Development Team
Posts: 2907
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation
Name: Ruslan
Contact: