You should perform this upgrade at a time when you are not delivering a newsletter.  If a newsletter is currently being delivered wait until the send has completed.  It is recommended you wait until 48 hours after any newsletter has been sent and then perform the upgrade.  Click here to see what's new in this update.    Note: This upgrade works only with version 3.0.  If you are not using 3.0 please contact us.  The version is listed at the bottom of the administration console.

Please verify that your server meets the following requirements for eNewsletter Pro version 6 for .NET:

• .NET Framework 2.0 (Note: this can be installed using the Windows Update tool)
• Make sure the IIS Application for eNewsletter Pro has selected .NET 2.0 on the ASP.NET Tab.  If 1.1 is selected and you change to 2.0 make sure this application pool is not shared by other applications running .net 1.1 or you will get an error.
  

1. Make a backup copy of your database as this upgrade will modify the database.  
    
2. Unzip the contents of eNewsletterProEnterprise6UpgradeFrom3.zip in a temporary location somewhere on the server where eNewsletter Pro is installed.  You will now see the following folders:
   
   eNewsletterPro
   Database
   MailEngine
   
3. Next, Execute the SQL script called enewsletterpro6Upgrade.sql on your existing eNewsletter Pro Enterprise database.  The script is found in the folder where you unzipped the files in step 1.  This script is executed in SQL query analyzer.  If unsure how to do this, please review steps 6-7 of the original install instructions.  Be absolutely certain that you select the proper database in the drop-down menu before executing the script.
    
4. Once the above script has executed, you will see a number of messages indicating various rows were affected.  For example...(89 row(s) affected)  Scan all messages and make sure no errors occurred.  If an error occurred, email us the error and discontinue the upgrade.  If an error occurred you may wish to restore the database backup until we can resolve the issue.  If you see this warning message you can ignore it as it is not fatal:  Warning: The table 'tbl_newspro_SendQueue' has been created but its maximum row size (8403) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
   
   
5. If the database has successfully been upgraded, copy the files and folders from the folder called "eNewsletterPro" to the web folder where eNewsletter Pro is installed.  Typically this is http://www.yourdomain.com/enewsletterpro/.  Replace any existing files if prompted.  Be sure to include all folders and subfolders such as Admin, Bin, etc.
   
   

Install Updated Mail Delivery Engine and SMTP Express Update

Note: You should be logged in as the administrator or an account with administrative privileges.  You should be logged in using the same account under which the software was originally installed.

1. From the /mailengine/ folder, double-click on eNewsletterPro6.MSI to run the installation program.  Be sure to choose the folder in which your current version of the eNewsletter Pro Mail Engine is installed. 
   
   The default path is C:\program files\enewsletterpro however you may have choose a different path or drive.
   
   This installer will now update the necessary files.