Please follow directions
precisely to ensure un-interrupted ad serving.
- 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.
- This upgrade require
.net 4.0 be installed on the server. Please verify .net 4 has been
installed. If it is not installed it should be installed through
the Windows Update utility.
- Modify your existing Ban
Man Pro IIS Application Folder to use .net 4.0 instead of
Click here for instructions on doing so.
- Extract the upgrade files contained in
to a temporary location on your local computer. You will now see
several folders including RootDirectory, Admin, Images, Advertiser,
Bin, and Language.
- Version 14 includes changes to
the Root web.config file for .net 4.0 and the new charting control.
Because this file also holds your custom database connection string, you
must first enter your database connection into the web.config file
before copying the updated files. If you don't your database connection
will break after the upgrade. Also, if you added any custom tags to the
web.config they should also be transferred. To do so...
Open the web.config for your EXISTING installation of BanManPro. Find
and copy this line:
<add key="DBConnectionString" value="server=(LOCAL);UID=youruserid;PWD=yourpass;DATABASE=BanManPro"
Now, open the web.config found in the "banmanproSQL14upgradeFrom9\RootDirectory"
folder of the upgrade files. Replace the sample connection string with
your full connection string.
Save the file.
- From within SQL Query Analyzer,
execute the script called banmanproSQL14upgradeFrom9.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:
and noting that in step 5 the SQL script is named
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,
ChartImages,App_Data, EditorDialogs, ImageEditorDialogs, 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...
- Load the Upgrade.aspx
file in your browser. It is located in the root folder and has open
Click the button to upgrade your existing database.
- Now delete upgrade.aspx so it
cannot be executed a second time.
- In order to use the charting tool, you must give the Users
account WRITE permissions on the ChartImages folder.
here for directions on setting write permissions.
- Log into the Ban Man Pro admin console
and verify everything is working properly.