Course and block status not updating. Feb 13 2001

Version affected: v1.5 under SQLServer or Oracle. 
Does not affect copies of WBT Manager 1.5 downloaded after Feb. 13 2001.

Symptoms:

When a student completes a lesson within an instructional block
the block and course status do not update. This occurs only when
running WBT Manager under MS SQL Server or Oracle and only if
the site was not upgraded from WBT Manager version 1.3.

Cause:

Instructional Block level status values where added to the STATS table in
verson 1.5. In order to contain both lesson and block information the table
structure was modified to allow null values in the lesson_id column. The upgrade
scripts modify the table structures correctly however the scripts which 
build a new WBT Manager database still contain a restriction that lesson_id
can not be empty. Therefore it is not possible to insert status values for
blocks.

Correction:

This patch contains corrected SQL scripts to build and upgrade the 
WBT manager database. 

If you have not yet built your database or upgraded from version 1.3 then you 
should download the current version of WBT Manager 1.5 or use the scripts
included in this patch in place of those in your current WBT Manager installation set.

To correct the problem in existing databases:

    SQLServer 6.5 - contact Integrity eLearning support for assistance.

    SQLServer 7
	
	Start the runsql.exe program found in the \utilities\database directory of
	the WBT Manager installation set or start the SQL Query analyser utility 
	from SQLServer Enterprise Manager.

	Connect to the WBT Manager database (use the login id originally used to 
	create the database).

	If using runsql, check the "manual entry" checkbox.

	Enter and execute the following:

	    ALTER TABLE STATS ALTER COLUMN LESSON_ID INT NULL

    Oracle

	Start the runsql.exe program found in the \utilities\database directory of
	the WBT Manager installation set.

	Connect to the WBT Manager database (use the login id originally used to 
	create the database).

	If using runsql, check the "manual entry" checkbox.

	Enter and execute the following:

	    ALTER TABLE STATS MODIFY LESSON_ID INTEGER NULL


After the database constraints are corrected the block and course status values
will be updated the next time a student completes a lesson or clicks on the 
"recalc status" button on the course menu. If you want to update status for 
all courses at once you can use the status rebuild utility found in the
\utilities\conversion_tools\status_rebuild directory on the of the WBT Manager
installation set. See rebstats.html.