Pre-Installation Notes

• Verify that you are currently using Version 8. 
• Make a backup copy of the entire /banmanpro/ folder on your web server as well as the SQL database.  This upgrade will alter the database and a backup is required in the event of an error in the upgrade script.
• This upgrade alters a number of database indices.  If you have a large database this script may take a long time to run, in some cases minutes to an hour.  You may wish to disable ad serving under the Ban Man Pro tools option until the upgrade is completed.

Installation Instructions

1. Extract the upgrade files contained in banmanproSQL9upgrade.zip  to a temporary location on your local computer.  You will now see several folders including RootDirectory, Admin, Images, Advertiser, and Bin.
    
2. From within SQL Query Analyzer, execute the script called banmanproSQL9Upgrade.sql on your existing Ban Man Pro database.  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 banmanproSQL9Upgrade.sql.
   
   Note: If you receive the error below it is not fatal and can be ignored...BMP_proc_ObtainBannerForKeywordCampaignAdvanced4, Line 27
   Cannot use a CONTAINS or FREETEXT predicate on table 'Campaigns' because it is not full-text indexed.
    
3. Copy the files from the directory called "Root Directory" to the web server directory where Ban Man Pro is installed.  If you installed the software at http://www.yourdomain.com/banmanpro then that is where these files are to be copied.  You will be overwriting the existing files.  
    
4. Copy the files in the Images directory to the images directory.  This will most likely be... http://www.yourdomain.com/banmanpro/images.  
    
5. Copy the entire Admin, Advertiser and Language folders into the folder where Ban Man Pro is installed. Be sure to include all subdirectories.
    
6. Copy the contents of the /bin/ folder to your Ban Man Pro /bin/ folder.  This will most likely be... http://www.yourdomain.com/banmanpro/bin/. 
    
7. Log into the Ban Man Pro admin console and verify everything is working properly.
    
8. Click Setup and make sure the field called "Physical server path of BanManPro application" is set correctly.  This must be the physical file path to the location where BanManPro is installed.  This is used to find the Language Files.  If not set correctly the web interface will load more slowly.  Once set correctly, click Update Setup.