| Author |
 Topic Search  Topic Options
|
Slov 
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forum sending e-mails to every user
Posted: 25 January 2006 at 3:53pm |
|
We are currently in process of upgrading our WebWiz forum version 6.28 to 7.97. We have migrated database from Access to SQL server using a wizard from this site. After configuring CDONTS I have tried to post a few test messages. Very slow response time attracts my attantion but while I realazed what is really happening I have posted a few test e-mails in the forum. This "application" where sending a notification e-mail to every registred user in the database!!! My development machine have sent about 10000 junk e-mails to our users!
Somebody should respond for that!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 4:07pm |
|
This is something that should NOt be happening.
The only thing that I can put it down to is that you either have a corrupted file and you should reupload the files again, or the 3rd party tool you found to migrate to SQL server has entered all the users into the tblEmailNotify table.
Try reuploading the files again and check that the tblEmailNotify table in the database is empty.
Edited by -boRg- - 25 January 2006 at 4:08pm
|
|
|
|
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 4:16pm |
|
We have used "Version 6 to 7.x Access Database Migration Tool" from this site. Then we have manually moved database to SQL server.
The table is called tblEmailNotify and it is really not empty, but as I understand forum subscription records are the records with 0 in Topic_ID field. There is no records with 0 in Topic_ID field in this table, all other records looks as legitmate user subscriptions to the topic replies.
We will download files again, but I doubt this is the reason.
Maybe you have more ideas?
We have used CDONTS as a transport.
|
|
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 4:30pm |
|
File corruption is impossible because it is a checksum protected ZIP archive. So it is either bug in the forum itself or in migration script.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 4:59pm |
|
With over 300,000 downloads on the 7.x version I'm sure that the problem is not in the coding, or something like this would have been reported to me before.
One of the most common errors is corrupt files that happen during the FTP upload process, so if you uploaded the files via FTP do so again.
The actual process of sending the emails is via an SQL query in the post_message.asp file, after the post is saved. The query is looped through to send the emails to each user returned by the SQL query on the tblEmailNotify table.
This means that the problem would not be related to the component you are using.
There could have been an issue in your transfer process between Access and SQL versions.
I would recommend deleting all entries in the table tblEmailNotify and re-uploading files again to the server in case of a corrupt file.
|
|
|
|
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 5:06pm |
|
We didn't used FTP to upload files, it is our local development machine (unfortunately it is connected to the internet).
Do you have any recommendations on how the database trnasfer from Access to the SQL Server should be done?
Deleting of all records from tblEmailNotify is possible, but I want to make sure this will not hapen again with a new data. Also I have already noted that tblEmailNotify doesn't look corrupted.
Maybe I can post you our database so you could check it?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 5:22pm |
|
There is a tool for migration between 6.x to 7.x Access, but upsizing to SQL is very hit a miss.
There is a sticky topic on upsizing to SQL server, try looking through that as many uses have found different ways to get it to work for them.
|
|
|
|
Slov
Newbie
Joined: 24 January 2006
Status: Offline
Points: 14
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 January 2006 at 5:28pm |
|
I have tried to search for "upsizing SQL server" but this didn't worked because word SQL is below 4 characters long. Unfortunately I don't have any Idea how to find what I need without word SQL in search.
|
|
