Patch 2 - Bug fixes
Date: March 27, 2006 (updated for missing
SQL script)
Version affected: v1.90.
Notes:
-
This is a cumulative patch. It includes all previous patches.
Prior
patch documentation:
patch 1.
- Patch 1 updates
the web-module string table (strings.txt). If you
are using a translated version of WBT Manager you will need to obtain a
translated version from your reseller or translate and add the new strings to
your existing table. If you have modified the standard version of strings.txt you should make a backup
copy before installing the patch. After installtion restore your customized version and update
it with the changes in this patch. See
string
table changes
for more
information.
- In addition to bug fixes this patch includes
preliminary changes to support change auditing for student records and some
additional customization hooks in the course enrollment functions. These
changes will be completed and documented in a future release (some limited
audit capability is available for SQL Server users now, contact customer
support if you have a need for this feature).
- This patch includes a minor change to the database
structure. Several user-defined flag columns
have been added to the Student Hierarchy elements (Organization, Department,
etc.) to support customizations for various clients. These fields will be
added to edit forms and documented in a future release but the support code
has been included in this patch.
Contents:
- M2006011701 - Local administrators cannot edit
other admins that are selected using the admin selector search
function.
If a local administrator attempted to find and edit an
administrator using the administrator selector search function an error was
displayed. The desired administrator could be edited if selected by navigating
to their assigned hierarchy element using the navigation tree. This has been
corrected.
- M2006011702 - Error adding local administrator
under Access
If a local administrator was added through the
web-based local administrator interface under the Access DBMS an error
("invalid use of null") occured. This has been corrected.
- M2005121501 - Cannot set page delay to 0 for
student account maintenance page.
If a value of "0" was set in the
pagesettings.ini [pagedelay] group for the "smaint" page, a javascript error
occured on that page instead of jumping immediately to the student menu. This
has been corrected.
- M2006012501 - Add/Edit student in web module
complains that Reference ID is duplicated even though local administrators
cannot edit Reference ID.
When a student was added by a local
administrator the system displays a message indicating that the student's
Rference ID had to be modified to make it unique even though no
Reference ID was entered because the local administrator did not have
rights to enter one. This has been corrected.
- M2006020201 - SQL error in Course Results report
for long reports
For reports on large populations of students the
"Course Results" report displayed an "unable to connect or SQL Server not
found" error message under SQL Server. The report has been modified to correct
this.
- M2006021301 - Language dropdown on
profile edit page displays HTML-encoded value for language
names.
When a language was added whose name contained non-ASCII
characters (such as "Français"), the language name displays the HTML encoding
for that name ("Français"). This has been
corrected.
- M2006021501 - ILT calendar report
shows some dates in mm/dd format even when system date format is dd/mm
(Eur format).
The ILT Calendar report includes
dates in month/day format to indicate the starting date of a week. On systems
where UK date format (dd/mm/yyyy) is used the week starting dates were still
displayed as mm/dd instead of dd/mm. This has been corrected.
- M2006022701 - Adhoc reports show incorrect
TOTTIME
The Ad-Hoc report generator formats the "total time in
lesson" field as hhhh:mm:ss. The formatting code was converting the value from
the database incorrectly (the value is in seconds in the database). When a
value's remaining seconds was greater than 30, the minute value was increased
and the second value decreased. For example: if the value were 150 seconds the
report would display 0000:02:30 but 151 seconds displayed as 0000:03:29
instead of 0000:02:31. This has been corrected.
- M2006011801 - Student import returns "Entry
modified by another user." if a field in the student's database record
contains trailing blanks.
When updating student records by
importing data with the student import utility, if a student record in the
database contained leading or trailing blanks in any of its
character-type columns, the update was rejected with an "Entry modified by
another user" error. This has been corrected. NOTE: this condition was very
rare and usually associated with direct manipulation of the student record in
the database outside of the WBT Manager application and
utilities.
Installation:
First unzip the patch
files to a temporary directory. Copy the web_module directory to the web-server
where WBT Manager is installed.
Database
Schema:
The database schema must be updated before applying the patch to the
web-module.
- Perform a database backup (optional, but highly
recommended).
- Launch the runSQL.exe program found in the
database directory in this patch.
- Connect to the WBT Manager database and log on as the
wbtmanadmin user (or whatever user account was used to create the WBT Manager
tables).
- Execute the M2006032401.sql script found in the
database directory in this patch. It should execute with no
errors.
Web-Module:
On
the web-server where the WBT Manager Web-Server Application is
installed:
Note the NTFS permissions on the
WBT Manager DLLs (see "Replaced Files" list below) in the
Windows/System32 directory.
If you have a translated version of
WBT Manager or have customized the string table (strings.txt
) make a backup copy of strings.txt and update it as described in
string table
changes below.
Stop IIS web services (skipping
this step may cause a system re-boot to be required after installing the
patch).
Run
the setup.exe program found in the patch's
web_module directory. When prompted for the
installation directory select the directory where the WBT
Manager web-module is installed.
When the
installation is complete re-start IIS. Run the reload.asp script in a browser
to verify the installation. If any errors occur verify that the NTFS
permissions on the WBT Manager DLLs have not changed. Correct if necessary and
re-run reload.asp.
Student import
module:
On each system where the
student import utilities are installed:
Shut down any instances of the student import
utility, status import utility, or any custom programs which use the student
import component.
Run the setup.exe program found in
the patch's student_import_tools directory. When prompted for
the installation directory select the directory where the student import
utilities were originally installed.
String Table
Changes
This patch will replace the string table
(strings.txt ) used by the web module. If you have a translated
version of WBT Manager you will need to obtain a new version from your reseller
or add the new strings to your existing file.
To update the file yourself:
- Make a copy of your existing strings.txt file.
- Translate and
change the following entries in the file.
146021,To change your password enter your
current password, the password you would like (2 times), and click "Update"
below.
- Install the patch.
- Replace the patch's strings.txt file with
your updated one.
Replaced files
| Web-Module |
| Destination |
File |
Version |
Date |
| \winnt\system32\ |
wbtman6a.dll |
1.9.0.1 |
2006/01/30 4:10 PM |
| |
wbtman6b.dll |
1.9.0.1 |
2006/01/30 4:10 PM |
| |
wbtman6c.dll |
1.9.0.1 |
2006/01/30 4:10 PM |
| |
wbtman6d.dll |
1.9.0.1 |
2006/01/30 4:10 PM |
| |
wbtman6f.dll |
1.9.0.2 |
2006/01/30 4:11 PM |
| |
wbtman6g.dll |
1.9.0.2 |
2006/01/30 4:11 PM |
| |
wbtman6h.dll |
1.9.0.1 |
2006/01/30 4:11 PM |
| |
wbtman6m.dll |
1.9.0.1 |
2006/01/30 4:11 PM |
| <web-dir> |
strings.txt |
|
2006/01/10 2:54 PM |
| |
global.asa |
|
2005/12/19 10:47 AM |
| |
reload.asp |
|
2005/12/19 10:49 AM |
| <web-dir>/asp |
ahredit2.asp |
|
2005/08/03 10:45 AM |
| |
aicc_int.asp |
|
2005/12/21 1:46 PM |
| |
aicc_int_c1.asp |
|
2005/12/21 1:36 PM |
| |
amenu.asp |
|
2005/08/02 1:51 PM |
| |
asgncls3.asp |
|
2006/01/27 10:38 AM |
| |
asgncls4.asp |
|
2006/01/27 10:39 AM |
| |
auditcodes.inc |
|
2006/01/26 11:38 AM |
| |
cat1c.asp |
|
2006/01/05 7:23 AM |
| |
enrollcertstud.asp |
|
2006/01/26 1:08 PM |
| |
enrollstud.asp |
|
2006/01/26 1:08 PM |
| |
iltcedit1.asp |
|
2005/08/02 9:51 AM |
| |
iltinstr3.asp |
|
2005/12/08 3:21 PM |
| |
login2.asp |
|
2005/09/13 11:01 AM |
| |
login2a.inc |
|
2005/12/02 9:18 AM |
| |
r_adm2.asp |
|
2005/12/29 1:18 PM |
| |
r_adm4.asp |
|
2006/02/02 3:19 PM |
| |
r_adm8.asp |
|
2006/02/15 3:22 PM |
| |
r_crspr.inc |
|
2006/02/23 8:30 AM |
| |
r_stu5.asp |
|
2006/02/15 3:25 PM |
| |
regstud.asp |
|
2005/12/07 9:56 AM |
| |
reportah.asp |
|
2005/08/03 11:56 AM |
| |
reportah.inc |
|
2006/02/27 9:56 AM |
| |
slfdrop.asp |
|
2006/01/26 11:41 AM |
| |
slfenrol.asp |
|
2006/01/26 1:34 PM |
| |
slfenrollcert.asp |
|
2006/01/26 1:34 PM |
| |
slfresilt.asp |
|
2006/01/26 1:34 PM |
| |
sprofile.asp |
|
2006/01/24 4:11 PM |
| |
wbtconst.inc |
|
2005/08/25 1:36 PM |
| <web-dir>/xsl |
admin2.xsl |
|
2006/02/13 11:27 AM |
|
ahredit.xsl |
|
2005/08/03 12:00 PM |
|
amenu.xsl |
|
2005/08/02 2:03 PM |
|
assign5.xsl |
|
2005/09/02 10:42 AM |
|
crssel1.xsl |
|
2005/09/06 3:55 PM |
|
crssel1a.xsl |
|
2005/09/06 4:06 PM |
|
crssel3.xsl |
|
2005/09/06 3:56 PM |
|
login_a.xsl |
|
2005/08/04 11:54 AM |
|
login_s.xsl |
|
2005/08/04 11:54 AM |
|
pw_a.xsl |
|
2006/02/13 11:28 AM |
|
pw_s.xsl |
|
2006/02/13 11:29 AM |
|
studnt2.xsl |
|
2006/02/13 11:29 AM |
Version 1.9 Patches
Patch 1 - Bug
fixes.
- M2005111701 -
max_normal check counts lessons in all courses when shared status
enabled
.
On a system converted for shared lesson
status. If a course had a restriction on the number of lessons allowed in an
incomplete state ("Max concurrent lessons" on the "Startup" tab). And if other
courses were assigned to the same student. Then the system would count
all of the student's incomplete lessons (regardless of which course they
belonged to) against the "Max concurrent lessons" limit. This has
been corrected.
- M2006010501 - Flag to hide Certificate Program
tree in course catalog does not hide the
programs.
There is a flag variable in
cat1a.inc which can be set to "false" if a client does not
use Certificate Programs and does not want the "Certificate Programs" heading
to appear on the course catalog page. This flag was having no effect. This has
been corrected.
- M2005092901 - "password" is
spelled "passward" in strings.txt #146021.
Instructions on
the user "Edit Profile" page had incorrect spelling of the word "password".
This has been corrected.
- M2006011301 - SQL error in
self-reg routine under Oracle.
A SQL error displayed in the
regstud.asp script under Oracle when an attempt was made to self-register a
student. This has been corrected.
- M2005082402 - Course results report ignores
course category selection.
When a Course Category was selected as a
criteria to the Course Results report all courses were included in the report
instead of only courses in the selected category. This has been
corrected.
- M2005122901 - SQL error in Course
Progress report for long reports.
Running a long Course Progress
report under SQLServer results in "SQL Server does not exist or access
denied". This has been corrected.
- M2005122101 - Browser information set incorrectly when login
expires during an API lesson.
If a
student is in a lesson which uses the SCORM API and their login session times out then they
experienced strange behavior after they returned from the lesson unless they closed and re-opened the browser. Typical symptoms were
changes to the navigation bar color and button
spacing. This has been
corrected.