Forum sending e-mails to every user
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18128
Printed Date: 13 April 2026 at 12:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Forum sending e-mails to every user
Posted By: Slov
Subject: Forum sending e-mails to every user
Date 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! |
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Slov
Date 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. |
Posted By: Slov
Date 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. |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Slov
Date 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? |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Slov
Date 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. |
Posted By: WebWiz-Bruce
Date Posted: 25 January 2006 at 5:34pm
|
It's a sticky post at the top of this support forum entitled, Access to SQL step by step, or something like that.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Slov
Date Posted: 25 January 2006 at 5:39pm
|
OK, I found the post. But is it possible to remove 4 characters limitation in the search? At least is it configurable?
Also is the search case insensitive or not and is there a way to configure it? |
Posted By: WebWiz-Bruce
Date Posted: 25 January 2006 at 6:14pm
|
The searchon this forum is completly different to the 7.97 version you will be using. This forum is currently running an alpha version which uses a different searching engine and is not yet completed so chnages will be made. Searchs use SQL like queries, so whether it is case sesitive or not depends on how the server is setup. In version 7.97 there is no limtation on search word lengths. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Slov
Date Posted: 25 January 2006 at 8:01pm
|
OK, thank you for the support.
By the way, I have a proposition that may be interesting for you. We offer a product called ISAPI_Rewrite - this is analog of mod_rewrite but for IIS, you may be know what is it. With this product it is possible to make this forum search engines friendly. For example instead of http://forums.webwiz.net/forum_posts.asp?TID=18128&PN=2 URL we can get http://forums.webwiz.net/forum_posts_18128_2.asp or something. This will require changing links in the forum engine. You may offer it as add-on. The good news is that there is a free Lite version of ISAPI_Rewrite that many peaple can use. If you are interested please write me an e-mail so we can discuss technical questions. |
Posted By: Slov
Date Posted: 26 January 2006 at 12:13pm
| We found the problem. It is a bug in Access migration script. It has created tblEmailNotify table and filled Forum_ID field for all records by the ID of the forum where initial post was made. We can send you data example if you want. |
Posted By: WebWiz-Bruce
Date Posted: 26 January 2006 at 5:48pm
|
Thanks for the info about ISAPI_Rewrite, it is something that I have considered but at the moment it is not an important consideration, also I have to think about the extra support time required to support a version with the altered URL's. The Access Migration Tool was written about 2 years ago by someone else and I wouldn't even know now how or even if they could be contacted to fixed the issue. As version 6.x was superceded over 2 years ago, most users have now already upgraded to a 7.x version, although it is recommended for security reasons to always be running the latest satble release. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: dpyers
Date Posted: 27 January 2006 at 12:57am
|
I haven't found to many webhosts that support ISAPI_Rewrite. Nothing against the product AFAIK, but they're reluctant to add any isapi dlls. Windows is flakey enough.
------------- 
Lead me not into temptation... I know the short cut, follow me. |