| Author |
 Topic  |
|
richfed
Average Member
United States
999 Posts |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 10 December 2002 : 11:38:43
|
Is there anyway of setting some code up, so when new people register, they are automatically added to the newsletter subscription list?
Thanks  |
 |
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 17 December 2002 : 16:20:35
|
Hi I Get the following message after installing the MOD.
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_Maillist'.
/forumlive2/nladmin.asp, line 45
As you can see, I am using SQL. I have run the MOD Setup in Admin options, but it tells me the tables exist.
Any Ideas?
|
Nick |
|
|
|
nickw
Junior Member
Ireland
193 Posts |
Posted - 17 December 2002 : 16:24:10
|
By the way, I am running 34v234
Cheers,
Nick |
Nick |
|
|
|
Lucky
Junior Member
USA
127 Posts |
Posted - 20 December 2002 : 00:21:37
|
quote:
Originally posted by mortioli
Is there anyway of setting some code up, so when new people register, they are automatically added to the newsletter subscription list?
Thanks
I agree. Is there any way to set this up? Could there be a pull down menu like "Allow Forum Members to Send you E-Mail?:" that would let them opt in/out from the time they sign up? |
~Lucky |
|
|
|
Lucky
Junior Member
USA
127 Posts |
Posted - 21 December 2002 : 19:32:43
|
| Is anyone else working on this? (other than burthold - it seems he's pretty tied up.) |
~Lucky |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 20 January 2003 : 07:50:35
|
I've got two forums ... both use Snitz 3.4.03 and both use Access 2000 database. Both are on the same server &, as far as I can tell, the E-mail settings are identical.
The Newsletter MOD works fine on one, but I just tried sending one on the other & received this error:
Send Failure...Error was 6 - 550 not local host Netscape.net, not a gateway User:
The E-mail address of the user was included in the error. All the way down the line, each user generated the same error message EXCEPT for mine ... mine was sent & received! The domains were valid [msn.com, aol.com, etc.].
Any ideas on this?
PS - E-mail all users works just fine! |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
Edited by - richfed on 20 January 2003 07:55:34 |
|
|
|
burthold
Junior Member
USA
426 Posts |
Posted - 20 January 2003 : 09:44:30
|
It has to do with mail relaying setup on your mail server. The newsletter mod is connecting to your mail server you mail server is rejecting the mail.
Wes |
|
|
|
richfed
Average Member
United States
999 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 02 February 2003 : 10:58:42
|
quote:
Originally posted by burthold
It has to do with mail relaying setup on your mail server. The newsletter mod is connecting to your mail server you mail server is rejecting the mail.
Wes
This really doesn't make any sense to me ...
My web host claims nothing is different or wrong at their end. I use the identical files on both my forums - all of them, with some minor modification on a couple [like config, inc_header, default, etc.].
Add to that:
- My regular E-mail works fine
- My Snitz-based E-mail works fine, including subscriptions, E-mail All Users, etc.
- The Newsletter sends E-mail just fine on Forum A [the larger, busier one]
- Even on Forum B, it sends the Newsletter to ME - it rejects all other addies!
My server uses ASPEmail.
What could possibly be causing this?!? |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
dcigary
Starting Member
USA
4 Posts |
Posted - 04 February 2003 : 01:31:53
|
When I try to run the database mod, I receive the following error as well as other people have:
Newsletter 2.0 Mod
Creating table(s)...
CREATE TABLE FORUM_MAILLIST( ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , EMAIL varchar(50) NOT NULL , ACTIVE int NULL , ACTIVE_TEMP int NULL DEFAULT 1, DATE_CREATED varchar(20) NULL )
Table already exists
I tried a manual delete before the script of the table, and it said that the table didn't exist. Then, when the script ran, it said that the table already exists!
Muh?
What's going on??
BTW I'm using an Access DB.
|
Edited by - dcigary on 04 February 2003 01:35:30 |
|
|
|
dcigary
Starting Member
USA
4 Posts |
Posted - 04 February 2003 : 11:19:43
|
Ahh. Nevermind. I did a little more searching through the forums and found out about the MS 2000 Connect string issue. I had the DB configured as a DSN at my hosting service. I changed the database connection to be one of the MS 2000 connect strings and now all is well.
|
|
|
|
dcigary
Starting Member
USA
4 Posts |
Posted - 06 February 2003 : 23:48:17
|
Ok, and you just THOUGHT you got rid of me. :)
Here's what I've been seeing. I loaded my MAILLIST table manually by bringing the database down to my PC and inserting the records in with an import from a text file.
However, now when I go to edit any of the addresses that I put in AFTER the import, i.e. through the subscribe dialog box, I get the following error:
Microsoft VBScript runtime error '800a0006'
Overflow: 'cint'
/forum/nledit_record.asp, line 20
In looking at the table, the records I inserted I have 1-120 in the ID field, and the ones that I did manually have a pretty large number like 453054269. I take it something got out of whack in the table with the autosequence type and I'm overflowing?
|
|
|
|
kbrowder
Starting Member
6 Posts |
Posted - 09 February 2003 : 14:28:19
|
I am running the serverhacker modded snitz 3.4 with the newsletter mod installed.
When I email the newsletter, it arrives with a sickly green background. I need it to have the lightpurple that is used in the serverhacker forum.
Can someone point me to the right file where I can change that?
Thanks for any help. |
Ken Browder
http://7times.org
"A Newletter of Biblical Understanding" |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 12 February 2003 : 13:39:01
|
quote:
Originally posted by richfed
quote:
Originally posted by burthold
It has to do with mail relaying setup on your mail server. The newsletter mod is connecting to your mail server you mail server is rejecting the mail.
Wes
This really doesn't make any sense to me ...
My web host claims nothing is different or wrong at their end. I use the identical files on both my forums - all of them, with some minor modification on a couple [like config, inc_header, default, etc.].
Add to that:
- My regular E-mail works fine
- My Snitz-based E-mail works fine, including subscriptions, E-mail All Users, etc.
- The Newsletter sends E-mail just fine on Forum A [the larger, busier one]
- Even on Forum B, it sends the Newsletter to ME - it rejects all other addies!
My server uses ASPEmail.
What could possibly be causing this?!?
Finally got to the bottom of this. It was my server. Nothing wrong with the mod or my implementation of it. Basically, my webhosts eliminated many of the aliases for generated e-mail. On one site, I was using my main e-mail in my Snitz e-mail configuration. The other, I was using something else: webmaster@etc.,etc. Switched that over and it all worked.
|
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
Topic |
|
Topic Locked
