Scheduled Maintenance: 10-11-2025 Electricity company maintenance between 09:00 and 15:00.

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

<span class="qte-attr qte_32_33-qte">3.2.x & 3.3.x</span>
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6469
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Who Visited This Topic

Post by dmzx »

Mohammed AlSarsawi wrote: 29 Sep 2018, 20:11 Hi

I have 2 points
  • If user don't have permissions to see + read forum X , he must not see the topics names inside that forum in user profile page of other users
  • Inside topics if we hover on user name we can see the date and time of last visit , can we have same feature inside profile page? when hovering on topic name will show us date and time of last visit, or any other idea that will show this informations for all topics in user profile page
Thank you
Will look into these requests

User avatar

Soul_Less
Users
Users
Posts: 6
Joined: 03 Jun 2018, 20:00
    Windows 7 Chrome

Re: Who Visited This Topic

Post by Soul_Less »

So recently this error have occured, but it hasn't before which i find extremely strange.

Code: Select all

SQL ERROR [ mysqli ]

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dynclan_forum.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 = 640829 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: 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/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

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

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

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

FILE: (not given by php)
LINE: (not given by php)
CALL: dmzx\whovisitedthistopic\event\listener->viewtopic_get_post_data()

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]/viewtopic.php
LINE: 1219
CALL: phpbb\event\dispatcher->trigger_event()
Image

User avatar

martin
Admin
Admin
Posts: 5106
Joined: 06 Apr 2014, 16:12
    Linux Chrome

Re: Who Visited This Topic

Post by martin »

Does your config.php in root have this line ?

$dbms = 'phpbb\\db\\driver\\mysqli';
Image

User avatar

Soul_Less
Users
Users
Posts: 6
Joined: 03 Jun 2018, 20:00
    Windows 7 Chrome

Re: Who Visited This Topic

Post by Soul_Less »

Yes.

User avatar

Mohammed AlSarsawi
Users
Users
Posts: 24
Joined: 23 Feb 2017, 04:36
    Windows 10 Chrome

Re: Who Visited This Topic

Post by Mohammed AlSarsawi »

How can I make this Ext. compatible with Relative Dates Ext. please

https://www.phpbb.com/customise/db/exte ... s/faq/2336

User avatar

testingground
Users
Users
Posts: 24
Joined: 26 Apr 2016, 09:36
    Ubuntu Chrome

Re: Who Visited This Topic

Post by testingground »

Ive just installed this, set up the required permissions but it does not show in either topics or profile

User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6469
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Who Visited This Topic

Post by dmzx »

testingground wrote: 03 May 2019, 10:26 Ive just installed this, set up the required permissions but it does not show in either topics or profile
what style do you use?

User avatar

testingground
Users
Users
Posts: 24
Joined: 26 Apr 2016, 09:36
    Ubuntu Chrome

Re: Who Visited This Topic

Post by testingground »

Forumbook but Ive also tried the default proboards and neither work.

The permissions are set for admin but when I look at the permissions masks it shows it in red

User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6469
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Who Visited This Topic

Post by dmzx »

Strange and when you set permissions for Registered users? then also now show?

User avatar

testingground
Users
Users
Posts: 24
Joined: 26 Apr 2016, 09:36
    Ubuntu Chrome

Re: Who Visited This Topic

Post by testingground »

Nope

User avatar

testingground
Users
Users
Posts: 24
Joined: 26 Apr 2016, 09:36
    Ubuntu Chrome

Re: Who Visited This Topic

Post by testingground »

Sorry, correction.
Yes it shows if I enable registered users.
But that means everyone can see it?

User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6469
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Who Visited This Topic

Post by dmzx »

testingground wrote: 03 May 2019, 14:55 sorry, correction.
Yes it shows if I enable registered users.
But that means everyone can see it?
yes then registered group can see it.
Switch them off for that group and switch only administrators on to check it.

User avatar

ivailo95
Users
Users
Posts: 918
Joined: 02 Feb 2018, 12:04
    Android Chrome

Re: Who Visited This Topic

Post by ivailo95 »

How can i make it with scroll?
Feed like a disease
And bring them to their knees
They'll pay for their deceit

User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6469
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Who Visited This Topic

Post by dmzx »

First post updated.

User avatar

Galixte de EzCom
Users
Users
Posts: 39
Joined: 04 Mar 2015, 17:26
    Windows 10 Opera

Re: FRENCH translation for the Who Visited This Topic extension

Post by Galixte de EzCom »

Galixte de EzCom wrote: 13 Jul 2018, 15:40 Hi,

this is the FRENCH translation for the Who Visited This Topic extension, available on phpBB.com, on GitHub and on the “Communauté EzCom”.
FRENCH translation updated.
Communau EzCom
Image « Traductions d’extensions & styles pour phpBB 3.1.x & 3.2.x ».

Post Reply Previous topicNext topic