3.2 & 3.3 Extensions Database 3.2 / 3.3 ⇒ Who Visited This Topic

[ssl]

Can you help me please ?

What version off this extension do you use?

[multigames]

What version off this extension do you use?

The last 1.0.8

[dmzx]

Can you check the db table like below and post picture of it.

[multigames]

Hi dmzx,

here is my database screenshot, thanks

[PostaL]

Phpbb 3.3.10
FastCGI (Apache) php 8.2.0
Error when opening any topic

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

SELECT w.user_id, w.topic_id, w.counter_user, w.date, u.username, u.user_colour, u.user_id, u.user_avatar, u.user_avatar_type, u.user_avatar_height, u.user_avatar_width, u.user_type, SUM(w.counter_user) AS total FROM phpbb_whovisitedthistopic w, phpbb_users u WHERE w.topic_id = 7672 AND w.user_id = u.user_id GROUP BY w.user_id ORDER BY w.date DESC LIMIT 2

BACKTRACE

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

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

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

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

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 337
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/dmzx/whovisitedthistopic/event/listener.php
LINE: 216
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: dmzx\whovisitedthistopic\event\listener->viewtopic_get_post_data()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
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: 1320
CALL: phpbb\event\dispatcher->trigger_event()

[dmzx]

phpbb 3.3.10
FastCGI (Apache) php 8.2.0
Error when opening any topic

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

SELECT w.user_id, w.topic_id, w.counter_user, w.date, u.username, u.user_colour, u.user_id, u.user_avatar, u.user_avatar_type, u.user_avatar_height, u.user_avatar_width, u.user_type, SUM(w.counter_user) AS total FROM phpbb_whovisitedthistopic w, phpbb_users u WHERE w.topic_id = 7672 AND w.user_id = u.user_id GROUP BY w.user_id ORDER BY w.date DESC LIMIT 2

BACKTRACE

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

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

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

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

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 337
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/dmzx/whovisitedthistopic/event/listener.php
LINE: 216
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: dmzx\whovisitedthistopic\event\listener->viewtopic_get_post_data()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
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: 1320
CALL: phpbb\event\dispatcher->trigger_event()

is your ONLY_FULL_GROUP_BY on in MySQL?

Check it like this:

SHOW VARIABLES LIKE 'sql_mode';

And post the output here.

[dmzx]

First post updated.

[PostaL]

is your ONLY_FULL_GROUP_BY on in MySQL?

Check it like this:

SHOW VARIABLES LIKE 'sql_mode';

And post the output here.

[dmzx]

is your ONLY_FULL_GROUP_BY on in MySQL?

Check it like this:

SHOW VARIABLES LIKE 'sql_mode';

And post the output here.

use these 2 commands:

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

then check:

SHOW VARIABLES LIKE 'sql_mode';

And look if ONLY_FULL_GROUP_BY is gone, then test extension.

[Peralta]

Hello dmzx, there is a syntax error in a language variable:

open ./ext/dmzx/whovisitedthistopic/adm/style/acp_whovisitedthistopic.html

Code: Select all

		<input class="button1" type="submit" id="submit" name="submit" value="{{ lang('submit') }}" />

Should be:

Code: Select all

		<input class="button1" type="submit" id="submit" name="submit" value="{{ lang('SUBMIT') }}" />

Thanks for the update

[dmzx]

Hello dmzx, there is a syntax error in a language variable:

open ./ext/dmzx/whovisitedthistopic/adm/style/acp_whovisitedthistopic.html

Code: Select all

		<input class="button1" type="submit" id="submit" name="submit" value="{{ lang('submit') }}" />

Should be:

Code: Select all

		<input class="button1" type="submit" id="submit" name="submit" value="{{ lang('SUBMIT') }}" />

Thanks for the update

Thanks will correct

[PostaL]

use these 2 commands:

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

then check:

SHOW VARIABLES LIKE 'sql_mode';

And look if ONLY_FULL_GROUP_BY is gone, then test extension.

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

SHOW VARIABLES LIKE 'sql_mode';

[gep]

Thank you for this update

[ssl]

Download the french language pack for 1.0.9 version ici

[dmzx]

use these 2 commands:

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

then check:

SHOW VARIABLES LIKE 'sql_mode';

And look if ONLY_FULL_GROUP_BY is gone, then test extension.

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

SHOW VARIABLES LIKE 'sql_mode';

Check if you can see where you can disable ONLY_FULL_GROUP_BY I dont know is your provider must do it.