Forum losing topic watch settings

Let us know when something isn't working correctly, or if you find a typo. Do not post complaints or suggestions here.
Post Reply
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Forum losing topic watch settings

Post by fluffy »

On at least one thread (Themesongfight 2005), the forum keeps on misplacing my topic watch settings. There's probably a bunch of other topics and users which are simply getting their "watch this topic for replies" setting lost.

It's possible that maybe the phpbb_topics_watch table is getting too big. One thing you can do to mitigate this is to install my "expiring notifications" <a href="http://trikuare.cx/code/phpbb/">phpBB mod</a>, and then every month or so run this SQL command (assuming the server is running mysql):

Code: Select all

DELETE FROM phpbb_topics_watch WHERE notify_status > 1 AND notify_status < UNIX_TIMESTAMP(NOW()) - 5184000;
which will remove all topic watch information for topics which haven't been posted to in the last 60 days.

You can also see how big the topic watch table is with this command:

Code: Select all

SELECT COUNT(*) FROM phpbb_topics_watch;
and you can see how much of it is obsolete by adding everything from the WHERE to the ; in the DELETE line above to the SELECT line below.

Another cute SQL/phpBB trick is you can see who is watching which threads with this command:

Code: Select all

select u.username, t.topic_title from phpbb_topics_watch as tw left join phpbb_topics as t on (t.topic_id = tw.topic_id) left join phpbb_users as u on (u.user_id = tw.user_id) order by tw.topic_id desc;
Last edited by fluffy on Thu Oct 20, 2005 12:35 am, edited 1 time in total.
User avatar
Kamakura
Panama
Posts: 799
Joined: Sat Sep 25, 2004 10:50 am
Instruments: Drums, Guitar, Keys, Howling
Recording Method: LogicPro
Submitting as: Kamakura
Location: England
Contact:

Re: Forum losing topic watch settings

Post by Kamakura »

fluffy wrote:you can see who is watching which threads with this command
'Big fluffy is watching you!" :wink:
"There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

https://kamakura.bandcamp.com
HeuristicsInc
Beat It
Posts: 5297
Joined: Sat Sep 25, 2004 6:14 pm
Instruments: Synths
Recording Method: Windows computer, Acid, Synths etc.
Submitting as: Heuristics Inc. (duh) + collabs
Pronouns: he/him
Location: Maryland USA
Contact:

Post by HeuristicsInc »

man, it doesn't load and then it loads without telling me. sheesh.
i can't delete this.
-bill
Last edited by HeuristicsInc on Thu Oct 06, 2005 7:49 am, edited 1 time in total.
152612141617123326211316121416172329292119162316331829382412351416132117152332252921
http://heuristicsinc.com
Liner Notes
SF Lyric Ideas
HeuristicsInc
Beat It
Posts: 5297
Joined: Sat Sep 25, 2004 6:14 pm
Instruments: Synths
Recording Method: Windows computer, Acid, Synths etc.
Submitting as: Heuristics Inc. (duh) + collabs
Pronouns: he/him
Location: Maryland USA
Contact:

Post by HeuristicsInc »

assuming that's the problem, is there a way to see, as a user, if we're watching an old topic that we don't necessarily care about anymore?
-bill
152612141617123326211316121416172329292119162316331829382412351416132117152332252921
http://heuristicsinc.com
Liner Notes
SF Lyric Ideas
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Post by fluffy »

Nope, phpBB has no "my watched topics" search view, which is stupid. It'd be really convenient to have something like that. I've been meaning to code a mod for it but I haven't gotten around to it, since adding search views is a much bigger pain than it should be.
Post Reply