| Author |
 Topic  |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
 Posted - 06 April 2002 : 16:13:14
|
If I go to my subscriptions on this board I see "Forum: Help: General / Current Version (Old)" and "Forum: DEV Discussions (General)" but there are no topics listed there.
Maybe the topics have been archived or moved, but I don't think those forums should show and there's no way for me to delete them.
http://www.frutzle.com
Snitz Exchange | Do's and Dont's |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 06 April 2002 : 18:16:52
|
The topics have been archived. But the subscriptions are not deleted when topics are deleted/archived whatever. Subscriptions, unless you physically unsubscribed, are permenant residents in the database.
The reason you see the forum but not the topics is because the My Subscriptsion page sees the subscriptions in the database, and the forum ID is there and is good. But when it looks up the topic "Title" it cannot find it because it has been moved to the archived forum. So therfor that row of the table is left blank. In a forum where all the topics you have subscribed to are archived, you will see the 'header only' syndrom.
There could be some code added to the my subscriptions page to check to see if any topics are under the header and if not not show the header, but thats a cheap 'patch' The real problem is the lack of maintenence in the subscriptions table.
Deleting the subscriptions when archiving the forum would add massive overhead to a script that is already horibly compromised.
I have though that perhaps subscriptions should time out. . . but I'm sure though with this many clever people around that a better solution will arise.
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 April 2002 : 18:48:35
|
Yes, unfortunately this in one of the through backs of supporting MySQL, the archiving and subsequent deletion of stray records woud be much simpler if we could use nested queeries, but we can't unfortunately.
The best solution woud be to show the subscription, but indicate that the topic_id was no longer valid, at least then giving you the opportunity to unsubscribe
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 06 April 2002 : 18:52:55
|
Or just put a function in subscriptsions_list.asp that checks for unvalid subscriptions when the user accesses the my subscriptions page.
Dunno what kind of overhead that would entail though.
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 06 April 2002 : 18:54:07
|
Wouldn't it be possible to add an icon to "remove all subscriptions"?
Say I go on vacation and can't check my mail but have a couple subs that are quite active. Instead of deleting them individually I could click one button and they're all removed.
If that's possible then it could work in the example I gave, but also when there are subscriptions to non-existing topics and/or archived topics, right?
http://www.frutzle.com
Snitz Exchange | Do's and Dont's |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 06 April 2002 : 18:54:59
|
Why not just unsubscribe the person (i.e. Delete the subscription record) when they enter the MySubs page and archived IDs are found.
Instead of the massive overhead when archiving, it would do it one at a time when that person next uses the page.
The loop would check to see if it is valid, and if archived would delete that row.
--Aaron
MySubs Email MOD
MOD to Smile Mgr
HotKeys MOD |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 April 2002 : 18:56:40
|
Yes that woud be an idea.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 06 April 2002 : 19:35:35
|
| Actually, while we've been working on v3.4, I found that subscriptions weren't being deleted when deleting a Category, Forum, Topic or Member. These have all been fixed though. |
|
|
| |
Topic |
|
Topic Locked
