| Author |
 Topic  |
|
Torborg
Junior Member
Norway
109 Posts |
 Posted - 28 December 2013 : 18:59:54
|
Hello 
Earlier i could delete members subscriptions. The forum is almost 13 years and some users is no longer there and their email stops working. I need to clean up in some of the subscriptions.
For a while the subscription_list.asp has not been working.
I get this error:
Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/enbiolog/subscription_list.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed it's configured limit.
I read somewhere that it could be something with IIS6
Can any of you help?? |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 December 2013 : 20:22:09
|
It sounds like you have a lot of subscriptions to manage, that the server can't handle showing all of them at the same time.
Would need to recode the page so that it shows like maybe 10 or 50 at a time.
Either that, or server admin would need to increase the limit (default is 4mb) to something higher. But that really shouldn't be needed.
P.S. Hi Torborg! |
Support Snitz Forums
|
Edited by - Davio on 28 December 2013 20:36:11 |
 |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 29 December 2013 : 04:13:32
|
Create a new asp file as below and name it lostsubscriptions.asp
Upload the file to your website forum directory and then run it in your browser, ie http://yoursitename/forumdirectory/lostsubscriptions.asp
This will remove any subscriptions that no longer link to a topic, ie topics that have been deleted or archived, which should reduce the number in your subscription list substantially
|
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 29 December 2013 : 12:42:59
|
Here's another subscription management program (limits results to 50 per page, searchable by member name). Links are provided on each row to delete all subscriptions by member or individually (the first deletion link of each row will remove all subscriptions for that particular member, the second will delete only the particular subscription on that row). I wrote this to sort by "date last here". That way, you can easily remove subscriptions of those who no longer visit the forum. I did not include any other sorting, because I couldn't see any benefit.
"subscriptions.asp"
I made some small modifications to the original code I posted above, primarily for aesthetics. |
Edited by - Carefree on 29 December 2013 21:07:07 |
|
|
|
Torborg
Junior Member
Norway
109 Posts |
Posted - 29 December 2013 : 14:27:57
|
Thanks Carefree and Webbo! I will try the last script. I haven't archived anything and deleted very few posts, so I don't think the first one will help.
And hi DAVIO !! So nice that you are still here.
I have been a member since January 2001. Davio and Rui has helped me a lot. But in this forum I will remain new member as long as I don't talk much |
Edited by - Torborg on 29 December 2013 14:33:15 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 01 January 2014 : 09:57:34
|
Carefree, have you got a subscription file that will delete all subscriptions before a specific date, or for instance 'older than...' and a drop down of options ie 1 month, 2 months, 3 months, etc, etc ?
|
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 01 January 2014 : 11:58:05
|
| No, but wouldn't be too difficult to write one. It's 1:00 a.m. here and time for some rest, but will write it tomorrow. |
Edited by - Carefree on 02 January 2014 01:42:36 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 01 January 2014 : 16:46:59
|
| Get some rest you've a busy year ahead [;D] |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 02 January 2014 : 01:42:51
|
OK - in order to do this, have to add a date field to the subscriptions when they are made, since that isn't currently recorded. So if you wanted to use this function now to purge your subscriptions, it isn't possible.
If you want it for future use; however, it's easy enough. |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 02 January 2014 : 01:56:27
|
Wouldn't it be easier to do it using the topic date record as that is already used?
Effectively deleting subscriptions for topics started by date |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 02 January 2014 : 02:06:00
|
Not at all. Suppose you just joined a forum, read an older topic about something you were interested in and subscribed to it. Then your subscription gets deleted the next day because the topic is old....
The only effective method will require adding a field. |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 02 January 2014 : 04:55:12
|
OK - I wrote this, get it at SnitzBitz.
CAUTION! If there are existing subscriptions when you add this, and you use the drop-down menu to delete older subscriptions, they will ALL be deleted without warning.
New subscriptions, made after this modification, will have the date of the subscription added to the database and the drop-down menu will function properly for them.
You can search for members with subscriptions and filter accordingly.
The default display of subscriptions are sorted based upon the length of time since the member last visited, with the longest gap listed first. That makes deletion of older subscriptions simpler.
You can delete subscriptions in one of three ways:
1) Individually, by using the deletion link (trashcan) at the end of each line.
2) By member, by using the deletion link (trashcan) after the member's name.
3) By using the drop-down menu. |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 02 January 2014 : 17:19:29
|
| I'll give this a go Carefree in a couple of days after warning my members I'm going to purge all existing subscriptions, thanks |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 02 January 2014 : 21:00:31
|
| You're welcome. |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 06 January 2014 : 03:12:30
|
Hi Carefree,
I've added the above and have made a couple of changes to the subscriptions.asp file as below:
Altered lines 150-166 inclusive to:
This gives the option of removing all subscriptions, plus in the original the 'selected' option (1 month) cannot work as it cannot be selected from what I can see.
I've also added a paragraph at the end to create a break before the next table.
A couple of things though, I couldn't see it working as the original subscriptions remained after running the options in the changed file in your download. So I deleted all subscriptions from the database and created a new subscription.
When running the file again with the option 'All' in my changes above, nothing was deleted so this part needs some of your magic (),
However, altering the SUB_DATE for the new subscription to a year older and selecting 6months option your file worked
Thanks
|
Edited by - Webbo on 06 January 2014 03:17:21 |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 06 January 2014 : 09:59:52
|
Here:
|
|
|
|
Topic |
|
|
|
