| Author |
 Topic  |
|
bpatti
Starting Member
USA
11 Posts |
 Posted - 27 January 2001 : 16:15:24
|
Kerry,
I've installed the MOD and it works great!
I've modified it so that when it sends the Email it includes the following:
To be removed from this mailing list, click on the link below:
http://www.mydomain.com/forum/pop_profile.asp?mode=Modify&ID=251&name=BPatti
Obviously this won't work because the user is not logged in, is there a way that the user can unsubscibe from the mailing just by clicking on the link without loggin in?
Thanks |
 |
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 27 January 2001 : 17:35:20
|
Bpatti - I don't think it would be too difficult to do that. Gimme a day or two to catch up with regular work and a couple bugs and I'll give it a go.
-Kerry
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 27 January 2001 : 17:50:20
|
quote:
Are you aware of this or is it just my installation. Specifically, I cannot get it to sort by Posts DESC.
Try this:
http://www.cantonweb.com/kerrycode/admin_emaillist.txt
Let me know if that corrects it. Also, is anyone else seeing this same behavior?
-Kerry
Edited by - kerry on 27 January 2001 17:53:13 |
|
|
|
stef
Starting Member
37 Posts |
Posted - 27 January 2001 : 18:07:32
|
Thanks Kerry,
But it did not fix the problem. I'll be a little more specific:
The first time you view the page you can get it to sort properly using any combination of combo box options. But after the first one, if you start changing your options and press the go button, the combo boxes will not remember your previous selection and the sort order is not what you asked.
Stef.
P.S. You're very quick
|
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 27 January 2001 : 20:41:00
|
Hmmmm... *Scratching head*
Okay - I can't replicate it now. Do me a favor and logon, do a specific sort making notes of what you're selecting and then list the discrepencies in the results. Hopefully with that I can replicate & troubleshoot.
...Also, for anyone interested in testing out the paging-enabled version please run it through it's paces. This file is NOT included in the zip and should work the same on either Standard or HuwR Modified Release 3.1SR4. Please give feedback so I know whether or not it's ready.
File:
http://www.cantonweb.com/kerrycode/admin_emaillist2.txt
-Kerry
Edited by - kerry on 27 January 2001 20:41:33 |
|
|
|
ajy
New Member
USA
55 Posts |
Posted - 28 January 2001 : 20:39:16
|
When I ran emaillist_setup.asp I got this.
I am using the Mail List / Message Manager v.1.9 for HuwR RELEASE of Snitz Forums v3.1SR4. (Created January 25, 2001) and using the forum HuwR RELEASE of Snitz Forums v3.1SR4.
Setting up user preference table....
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_RECMAIL smallint DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Setting up admin table for frequently sent mail....
CREATE TABLE FORUM_SPAM (ID int IDENTITY (1, 1) not null CONSTRAINT primarykey PRIMARY KEY, SUBJECT VARCHAR(255), MESSAGE MEMO, F_SENT VARCHAR(255), ARCHIVE VARCHAR(1) DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
ajy
http://www.ajy.net/ |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 28 January 2001 : 22:08:17
|
ajy,
Check your conn string in config.asp. Is it set to Access97? If so, switch it Access2k (which is the format of HuwR's DB) then rerun the setup.
Let me know how that works.
-Kerry
|
|
|
|
tteal
Junior Member
USA
438 Posts |
Posted - 29 January 2001 : 01:45:53
|
Kerry,
I tested the newest run and it appears to work just fine in SQL 7. Thank you.
Cheers,
Tim
http://www.free-guestbook.com |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 29 January 2001 : 01:54:29
|
No problem - I'm glad it's working  .
If you get around to actually running an "all user" email, please let me know how it performs with a large list (I don't have one to test it out on, I only did a generic of 100 to one of my own Domains - just want to see how it handles it).
-Kerry
|
|
|
|
tteal
Junior Member
USA
438 Posts |
Posted - 29 January 2001 : 02:19:37
|
Kerry,
I have less then 200 members right now but growing at a rapid rate. I did a batch email with the "before this fix" and honestly it took a while almost timing out. I'm not sure if we're doing a Server.Timeout = "xx" or not ... or even if that's an option but if a user has thousands of users, that could mean big trouble. Just a lil something to ponder :)
Cheers,
Tim
Cheers,
Tim
http://www.free-guestbook.com |
|
|
|
JoeL
Starting Member
2 Posts |
Posted - 29 January 2001 : 03:10:37
|
quote:
Got it - the problem is actually in inc_profile.asp (where the form is)
Hi Kerry,
I'm brand spanking new and have a problem when attempting to change the Member Level.
I am using a Access2k with the regular forum download. I do have your password generator and changed the inc_profile....asp.
Here's the message I get after hitting save:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/pop_profile.asp, line 1118
Your assistance would be much appreciated.
JoeL
Edited by - JoeL on 29 January 2001 03:31:36 |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 29 January 2001 : 04:55:18
|
quote:
I'm brand spanking new and have a problem when attempting to change the Member Level.
JoeL,
Redownload the zip - I think the "with random pass" file was missed when I updated it. Replace inc_profile.asp with inc_profile_WITH_RANDOM_PASS_AND_MAILLIST_MANAGER.asp
That should take care if it, but by all means let me know if it doesn't.
-Kerry
Edited by - kerry on 29 January 2001 05:04:04 |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 29 January 2001 : 05:00:13
|
quote:
Kerry,
I have less then 200 members right now but growing at a rapid rate. I did a batch email with the "before this fix" and honestly it took a while almost timing out. I'm not sure if we're doing a Server.Timeout = "xx" or not ... or even if that's an option but if a user has thousands of users, that could mean big trouble. Just a lil something to ponder :)
Cheers,
Tim
Cheers,
Tim
http://www.free-guestbook.com
Thanks for the feedback, Tim. Yes, the script is set to timeout at 6000, but I think you're right - any large list should go out at maybe 50 at a time. Or 100 tops.
-Kerry
|
|
|
|
ajy
New Member
USA
55 Posts |
Posted - 29 January 2001 : 17:05:39
|
quote:
ajy,
Check your conn string in config.asp. Is it set to Access97? If so, switch it Access2k (which is the format of HuwR's DB) then rerun the setup.
Let me know how that works.
-Kerry
I havent tried it but I am sure that must be the problem. I was using Access 97 before I upgraded to HuwR's Modified version and I forgot to change that.
Thanks for your help I appreciate it.
ajy
http://www.ajy.net/
Edited by - ajy on 29 January 2001 17:07:31 |
|
|
|
lcs78816
Junior Member
195 Posts |
Posted - 31 January 2001 : 03:29:20
|
does sending a huge list of emails decrease the performance of the system server?
I just happend to find ASPMail stuff and found this file that allow asp to send emails without CDONTS
http://www.freevbcode.com/ShowCode.Asp?ID=390
Edited by - lcs78816 on 31 January 2001 03:31:52 |
|
|
|
Topic |
|
Topic Locked
