Pre-Installation Notes

• Verify that you are currently using Version 7.  This upgrade does not work with any other versions.
• Make a backup copy of the entire /affiliatewiz/ folder on your web server.
• Make a backup of your Affiliate Wiz SQL Server database.  This upgrade will significantly alter the database including renaming all tables.  A database backup is vital in case the upgrade script fails.

Installation Instructions

1. Extract the upgrade files contained in AffiliateWiz9UpgradeFrom7.zip  to a temporary location on your local computer.  You will now see several folders.
    
2. From within SQL Query Analyzer, execute the script called AffiliateWiz9UpgradeFrom7.sql on your existing Affiliate Wiz database.  This script is found in the /database/ folder in the location where you unzipped the files.  The database is now converted to the new format.  If you are unsure how to do this, please review Steps 5-7 of the original database instructions found at: support/SQLnewdb.asp and noting that in step 5 the SQL script is named AffiliateWiz9UpgradeFrom7.sql.
   

   Note: If any fatal errors occurred while running the database script, you should record the error and email it to us. At the same time restore the database to the backup copy you just made.  Do no proceed on with the installation.  Warnings such as these can be ignored: Warning! The maximum key length is 900 bytes. The index 'ProductSpecificCommissions_Covered' has... Warning: The table 'tblaff_Affiliates' has been created but its maximum row size (8280) exceeds... Warning: The table 'tblaff_Affiliates' has been created but its maximum row size (8680) exceeds... Warning: The table 'tblaff_Affiliates' has been created but its maximum row size (9080) exceeds... Warning: The table 'tblaff_Affiliates' has been created but its maximum row size (9380) exceeds... Warning: The table 'tblaff_Affiliates_Data' has been created but its maximum row size (10535) exceeds...

   
   

3. Copy the files AND FOLDERS from INSIDE the directory called "RootDirectory" to the web server directory where Affiliate Wiz is installed.  If you installed the software at http://www.yourdomain.com/affiliatewiz then that is where these files are to be copied.  You will be overwriting the existing files.  Be sure to include the subdirectories including Bin, Admin, Language, and Affiliate.
    
4. Copy the file in the images directory to the images directory.  This will most likely be... http://www.yourdomain.com/affiliatewiz/images.  
    
5. Run Upgrade.aspx to encrypt sensitive data.   Before doing so, you must temporarily rename Global.asax in the /AffiliateWiz folder to Global.asax1.
    
6. Next, access the Upgrade.aspx file using your browser and point to the base URL where Affiliate Wiz is installed.  For example:
   http://www.yourdomain.com/affiliatewiz/upgrade.aspx
   
   Once the page loads, click the Perform Upgrade button.
   
   
   
   Be patient if you have a large database as this may take a bit to run.
    
7. Now, rename Global.asax1 back to Global.asax
    
8. Now Delete Upgrade.aspx from the web site so it is never again executed.
    
9. Login to the Affiliate Wiz admin area and make sure things are working properly.   The admin console is located in a folder called /admin/ off the folder where you installed Affiliate Wiz.