|
Please follow directions
precisely to ensure un-interrupted ad serving.
Pre-Installation Notes
- Verify that you are
currently using Version 9.
- 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
- Extract the upgrade files contained in banmanproSQL10upgrade.zip
to a temporary location on your local computer. You will now see
several folders including RootDirectory, Admin, Images, Advertiser,
and Bin.
- From within SQL Query Analyzer,
execute the script called banmanproSQL10Upgrade.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 banmanproSQL10Upgrade.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.
- 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.
- Copy the files in the Images
directory to the images directory. This will most likely be... http://www.yourdomain.com/banmanpro/images.
- Copy the entire Admin, Advertiser and
Language folders into the folder where Ban Man Pro is installed. Be sure to
include all subdirectories.
- 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/.
- Log into the Ban Man Pro admin console
and verify everything is working properly.
|
