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

[Kinsman]

Hi all, I recently updated this extension to 1.08, but since then this shows on all styles including pro silver.

" style="color:#404000" class="username-coloured">Trevor68

It only happens for my username, maybe because I have a custom colour set???

[lause74]

Deutsche Übersetzung 1.0.8

de.rar

[tmjeletronica]

Hi, I have a little problem.

I make an update to phpbb 3.3.8
and Who Visited this topic stopped works.

Can Someone help me?
photo from error:

[JackSparrow]

Hi has everyone. I have installed this extension and on any post on my forum I get this error message:

Code: Select all

SQL ERROR [ mysqli ]

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql1573107_1.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 avphpbb_whovisitedthistopic w, avphpbb_users u WHERE w.topic_id = 6569 AND w.user_id = u.user_id GROUP BY w.user_id ORDER BY w.date DESC LIMIT 10

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()

Rereading this thread I saw that, a few pages back, another user had the same problem but, I can't find the solution ... can anyone help me?
Who Visited This Topic

[tmjeletronica]

Hi has everyone. I have installed this extension and on any post on my forum I get this error message:

Code: Select all

SQL ERROR [ mysqli ]

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql1573107_1.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 avphpbb_whovisitedthistopic w, avphpbb_users u WHERE w.topic_id = 6569 AND w.user_id = u.user_id GROUP BY w.user_id ORDER BY w.date DESC LIMIT 10

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()

Rereading this thread I saw that, a few pages back, another user had the same problem but, I can't find the solution ... can anyone help me?
Who Visited This Topic

This is the same error with me.

SQL no understand how to agregate "couter_user" collun

[martin]

Delete data and reinstall i just installed this ext on phpbb 3.3.8 and php 8.1.10 and it works i also installed it on phpbb 4.0 and worked.

[tmjeletronica]

Delete data and reinstall i just installed this ext on phpbb 3.3.8 and php 8.1.10 and it works i also installed it on phpbb 4.0 and worked.

MySql and PHP versions

[JackSparrow]

Delete data and reinstall i just installed this ext on phpbb 3.3.8 and php 8.1.10 and it works i also installed it on phpbb 4.0 and worked.

done, but the error continues to remain

[kennybroh]

Thanks so much for this extension. It is really helpful to me.

I have one question. The description of the extension says it displays a list of the users who visited the topic and the time of the visit. I don't see that anywhere. Am I missing something?

[martin]

Set what groups can see it.

[kennybroh]

I'm sure I am dense. I can see the list of who visited the topic, but nowhere can I see the time of the visits. What displays in the first and last columns is the time of the last post, which are always the same. I would have thought the last column would be the time of the visit, but it's not. It looks like when the list is built the extension populates the far right column with last post information instead of the last visit.

I'll send a picture in a minute.

[kennybroh]

This is from the profile.The topic just displays the names and number of visits, like "John (3), Bill (7), Tom (2)". Clicking the name opens the profile but I was expecting to see the list of Bill's 7 visits to this topic. But nowhere can I find the date/time of the visit.

[martin]

Last 10 in this image.

Screenshot from 2022-12-01 16-09-27.png

[kennybroh]

Ah, now I understand. I re-read the description of the extension which says it displays who visited and the “times”. You meant the “number of times” and I interpreted that to mean the “times of the visit”. Words….

Now that we’ve gotten to this point, is there any chance you could enhance it so when you click on “Bill (7)” it displays a list of those 7 visits? Or maybe add the date and time to the list in the profile? I assume you’re getting the data from the session table so isn’t it available?

Sorry for the confusion.

[multigames]

Hi,

I have the same SQL error like jacksparrow

Phpbb 3.3.9
PHP 8.0.24

Can you help me please ?