Upgrading From 5.05.006 to 5.05.007

Only one QPL file has been changed to accommodate MySQL 5.x: qpl_db_admin_funcs.inc. You can update a live QPL 5.05.006 site by first installing the new QPL software, extracting the qpl_db_admin_funcs.inc file from the qpl_public_master_files.zip file, and then copy it over the old file on your live web site. If you are uncomfortable taking this short-cut, you may follow the upgrade steps listed below to rebuild your site in a new location (in order to test the changes).

Upgrading From 5.05.001 to 5.05.006

No changes have been made to the database structure so upgrading a live site only involves updating the generated questionnaire files and the administrative page files.

Step Comment
1. Install the new QPL software on your computer.
2. Create a new directory for your project.
3. Copy only your source program file (.pgm) to the new directory.
4. Open the source program file (.pgm) in HomeSite.

Then click on the "Create new project" (Create new project) button (or follow the similar instructions in the manual using the Console version) to add all the QPL system files to the project directory.
5. Click on the PHP button (Build web server PHP files) on the QPL tool bar to build the web site files.
6. Update the new home page file, index.htm, with the contents of your old index.htm file where it says, "<P>(The description of your questionnaire project goes here.)</P>". Replace any <BR> tags (used to create paragraphs in the old index.htm page) with <P></P> tags.
7. Copy the new files, except the qpl_config.inc and *.sql files, to a new directory on your web server. (The qpl_config.inc file should already be installed on your server.) Then log into your questionnaire from the new location to test the site. It will use the same database as the old site.

Once you are satisfied that the new version of the site is working correctly, you can delete the old project directory on the web server and rename the new site to the old name, or put in a new index page on the old location to redirect your respondents to the new location, or send respondents the URL to the new version, or other use some other clever redirection scheme.

Upgrading From 5.04.002 Through 5.04.010 to 5.05.001

One change has been made to the data base structure to accomodate the new automatic login feature. So in addition to updating the site with new QPL files, you must also run a short SQL script to update the old database structue.

Step Comment
1. Install the new QPL software on your computer.
2. Create a new directory for your project.
3. Copy your source program file (.pgm) and the hello.htm file to the new directory.
4. Open the source program file (.pgm) in HomeSite and make any changes to the CONVERT options you use such as using new options to modify the Summary Statistics report.

Then click on the "Create new project" (Create new project) button (or follow the similar instructions in the manual using the Console version) to add all the QPL system files to the project directory.
5. Click on the PHP button (Build web server PHP files) on the QPL tool bar to build the web site files.
6. Update the new home page file, index.htm, with the contents of your old hello.htm file.
7. Copy the new files, except the qpl_config.inc and *.sql files, to a new directory on your web server. (The qpl_config.inc file should already be installed on your server.)
8. Backup your live project database using the mysqldump program:
%> mysqldump -u myusername -p --opt myjob > myjob_dump.sql

Where 'myusername' is your MySQL account name and 'myjob' is the name of your database. (Backing up your database is only suggested here as a precaution against losing any data should you make a mistake.)
9. Run the following SQL command to add a new column to the info table:
mysql> ALTER TABLE myjob.info ADD q_get_allowed CHAR(1) DEFAULT '0';

Where 'myjob' is the name of your database.

Once you are satisfied that the new version of the site is working correctly, you can delete the old project directory on the web server and rename the new site to the old name, or put in a new index page on the old location to redirect your respondents to the new location, or send respondents the URL to the new version, or other use some other clever redirection scheme.

Upgrading From 5.04.002 and Later to 5.04.010

The data base structure has not changed between these releases so upgrading an existing site is just a matter of rebuilding the project files. To be entirely safe, however, you should rebuild the project in a new directory on your computer, and then deploy the files to a new location on your web server but without running any SQL scripts. The new site will use the existing data base that was created when you launched the old site.

Step Comment
1. Install the new QPL software on your computer.
2. Create a new directory for your project.
3. Copy your source program file (.pgm) and the hello.htm file to the new directory.
4. Open the source program file (.pgm) in HomeSite and make any changes to the CONVERT options you use such as using new options to modify the Summary Statistics report.

Then click on the "Create new project" (Create new project) button (or follow the similar instructions in the manual using the Console version) to add all the QPL system files to the project directory.
5. Click on the PHP button (Build web server PHP files) on the QPL tool bar to build the web site files.
6. Update the new home page file, index.htm, with the contents of your old hello.htm file.
7. Copy the new files, except the qpl_config.inc and *.sql files, to a new directory on your web server. (The qpl_config.inc file should already be installed on your server.)

Once you are satisfied that the new version of the site is working correctly, you can delete the old project directory on the web server and rename the new site to the old name, or put in a new index page on the old location to redirect your respondents to the new location, or send respondents the URL to the new version, or other use some other clever redirection scheme.

Upgrading from 5.03.011 to 5.04.002

The data base structure has changed with the addition of the content analysis functions version 5.04.002, so the data base of an earlier project must be altered to fit with the new QPL programs. This involves building an SQL script that adds columns to two existing tables and adding several new tables to support the new content analysis functions.

Detailed instructions on modifying an existing database are provided in the QPL Help Files in the "Customization" section, on the page called "Upgrading a Live QPL Web Site to Add Content Analysis Functions." The QPL Help files may be accessed with the HomeSite help files if you installed the HomeSite Add-In version of QPL, or from an icon on your desktop if you installed the DOS Console version of QPL.

Upgrading from 5.03.006, .007, or .010 to 5.03.011

The data base structure has not changed between these releases, so upgrading an existing site is just a matter of rebuilding the project files. To be entirely safe, however, you should rebuild the project in a new directory on your computer, and then deploy the files to a new location on your web server but without running any SQL scripts. The new site will use the existing data base that was created when you launched the old site.

Step Comment
1. Install the new QPL software on your computer.
2. Create a new directory for your project.
3. Copy your source program file (.pgm) and the hello.htm file to the new directory.
4. Open the source program file (.pgm) in HomeSite and click on the "Create new project" (Create new project) button (or follow the similar instructions in the manual using the Console version).
5. Click on the PHP button (Build web server PHP files) on the QPL tool bar to build the web site files.
6. Update the new home page file, index.htm, with the contents of your old hello.htm file.
7. Copy the new files, except the qpl_config.inc and *.sql files, to a new directory on your web server. (The qpl_config.inc file should already be installed on your server.)

You should now be able to open the new home page in your browser and log in normally. The new site will be using the same data base as the old site.

If you are satisfied that the new site is working normally, you can copy all the new site files over the old site files to complete the upgrade.

Important!You could make the upgrade even safer by first dumping the "live" data base and rebuilding it on a test server and installing the new QPL files there.

QPL Home Send comments to Kevin Dooley.

Site Map