Did you read what I wrote above?
Did you read what I wrote above?
yeah , dont work
How it didn't work exactly?
the system does not recognize because of the change of letter
This is simply because you didn't follow the instructions given.eunaumtenhoid wrote: Tue Jan 16, 2018 4:56 pm the system does not recognize because of the change of letter
Code: Select all
General error
SQL ERROR [ mysqli ]
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx.phpbb_thanks.post_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]
SQL
SELECT *, COUNT(poster_id) AS poster_count FROM phpbb_thanks WHERE poster_id = '23295' AND forum_id <> 0 GROUP BY poster_id
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
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/gfksx/ThanksForPosts/core/helper.php
LINE: 752
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/gfksx/ThanksForPosts/event/listener.php
LINE: 182
CALL: gfksx\ThanksForPosts\core\helper->array_all_thanks()
FILE: (not given by php)
LINE: (not given by php)
CALL: gfksx\ThanksForPosts\event\listener->viewtopic_handle_thanks()
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: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()
FILE: [ROOT]/viewtopic.php
LINE: 1223
CALL: phpbb\event\dispatcher->trigger_event()
Stoker 4.0 wrote: Fri Jan 19, 2018 8:43 am EDIT!
Disregard my post. I was using version 2.0.2
Problem solved by updating![]()
mysql 5.7
phpbb 3.2.2
I get this error on topic pagesCode: Select all
General error SQL ERROR [ mysqli ] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx.phpbb_thanks.post_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055] SQL SELECT *, COUNT(poster_id) AS poster_count FROM phpbb_thanks WHERE poster_id = '23295' AND forum_id <> 0 GROUP BY poster_id [/quote] One would think you would know by now of how to fix that error seeing as you were told in two other topics how to do so in other extensions.
Thanks rxu, updated without errorsrxu wrote: Mon Jan 15, 2018 6:50 pm how update to ver 2.0.4
In theory, it should be as easy as:Never do it on production forums, as usually.
- Disable Thanks for posts 2.0.3-dev
- Delete
/ext/gfksx/ThanksForPosts
folder- Copy Thanks for posts 2.0.4 files into
/ext/gfksx/thanksforposts
folder (the difference is - all letters are lowercased)- Reload the manage extensions ACP page
- Enable Thanks for posts 2.0.4
Also note that current version of the Addon for Thanks for posts (to ajaxify things) won't work with ver. 2.0.4.
lol
Version 2.0.4 had been sent for validation a while ago. if it gets validated, you'll find it out I guess.ArKay99 wrote: Tue Feb 13, 2018 8:18 pm Any idea as to when this might be finished so it can be incorporated?