Author |
Topic |
Podge
Support Moderator
Ireland
3775 Posts |
|
Podge
Support Moderator
Ireland
3775 Posts |
|
Art
Starting Member
USA
32 Posts |
Posted - 03 September 2009 : 07:59:30
|
Yes, SQLserver 2005 (right now...I fear upgrading to 2008...) Thanks Podge...I 'll get right on it! |
http:\\StarFrontiers.org |
|
|
Art
Starting Member
USA
32 Posts |
Posted - 03 September 2009 : 08:54:59
|
Heh, added those tables, tried a mailing and got: Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cInt'
/forum/pop_mail.asp, line 68
If Not rs.EOF then intMPosts = cLng(rs("M_POSTS")) line 68 intAllowEmail = cInt(rs("M_ALLOWEMAIL"))
|
http:\\StarFrontiers.org |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
Art
Starting Member
USA
32 Posts |
Posted - 03 September 2009 : 10:21:01
|
Wow, lots of code there, and about a dozen different approaches. I used the last version of the fix, and I no longer have any errors. I also don't get the test e-mail
Maybe I can back up a step now and look at something besides forum code. Here is where I am at:
One, set email server config in forum to use CDOSYS (which the forum says is enabled on the machine). Two, hard wired the username and password into inc_mail.asp under the case cdosys. Three, added collums to fix M_AllowEmail issue. Four, changed intAllowEmail = cInt(rs("M_ALLOWEMAIL")) to:
Five, checked settings in forum and forum code. Six, tested e-mail function. Seven, Punched wall.
Now, I have the default smtp server in IIS disabled. I intend to use the hmail server as it has an MX record and all that, so I want to use it as a remote email server. I found the following code to do that with:
Is this code roughly equivalent to that in Snitz, yes? So I should be good to go...... but I am not. Owie BUT WAIT! This has code for OUTGOING AUTHENTICATION which my server requires...It is the same as for incoming, but it requires it. I shall try that code! The cdosys code in Snitz apparently assumes that if you are running IIS, then you are using the (horrible) default SMTP server, or a local server of some kind that doesn't require authentication. About right EDIT No, i am an idiot....Snitz ONLY has code for outgoing. Adding cdo config fields does nothing, as the SEND fields are already there. Anyway, I altered the fields in inc_mail.asp to read:
This resulted in broken code for whatever reason (where do I find a good troubleshooting .asp editor?) and I had to replace inc_mail.asp with an earlier version. Gosh.....
|
http:\\StarFrontiers.org |
Edited by - Art on 03 September 2009 10:59:09 |
|
|
Art
Starting Member
USA
32 Posts |
Posted - 03 September 2009 : 11:49:01
|
OK...I tried modifying my profile, and I got an error in POP_Profile calling for an non-existent Spam_Mail table. I commented out all of this:
That helped. Then I got a problem when I changed my e-mail adress in my user profile (to help troubleshooting). It SENT the e-mail to me indicating that my profile had changed, and sent a validation code! The e-mail worked! But when I clicked on it, it gave me a validation error! Argh! So I turned off email validation, which forced me to not have any control over who registers, but now e-mail, profile editing, and registration works.
I have an established database here. I would like to keep it while solving these problems. I suppose I could create a forum version that has Active Users on it, and hopefully gatekeeper (no luck with that mod in the past) as well as a few other nice mods (If I find a few days of spare time in the next few years). I could then look at how the database those mods create looks, then modify my database tables to fit manually, and then see how it all comes out. I'll just need a few months of spare time or so. Thanks for your help guys. Too bad I have to trade one feature for another. I just wish Snitz had a few more features without having to tinker so much to add them. Not that I don't appreciate the developers that created the base forum as well as the mods. -Frustrated and Gripey. I'll get over it. Thanks Guys. |
http:\\StarFrontiers.org |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
Art
Starting Member
USA
32 Posts |
Posted - 04 September 2009 : 00:42:32
|
Thank you much for the help Podge and Friends. I'm gonna do some more game coding before I play with this again.... |
http:\\StarFrontiers.org |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
Topic |
|