Sakai 2.9 - Special Notes for Lessons tool

Lessons tool - special installation instructions

Lesson tool

Sakai 2.9.3

For large installations with a million Lessons items or more, Lessons may break since the id generated cannot go high enough. To fix you can use the following statements. Please see LSNBLDR-284 - Getting issue details... STATUS for more information.

mysql
alter table lesson_builder_items modify gradebookId varchar(100);
alter table lesson_builder_items modify altGradebook varchar(100);

oracle:
alter table lesson_builder_items modify gradebookId varchar2(100 char);
alter table lesson_builder_items modify altGradebook altGradebook varchar2(100 char);

Sakai 2.9.4 (and a note about Lessons with 2.8.x)

If you are running the Lessons that comes with Sakai 2.9.x, database upgrades are handled automatically. No special instructions are needed.

If you install Lessons yourself, we recommend using the most recent tag. This is currently 1.4.2. If you install it yourself, you need to be concerned about database schema updates. We recommend starting once with auto.ddl on. That will handle most database updates for you. The exceptions are in the following files:

If you are moving from a copy of lessons older than the 1.4.0 tag:

* simplepage.pre29-to29.sql

If you are moving to the 1.4.2 tag from any previous version, and are using mysql:

* simplepage.for-2.9.2.sql [mysql only]

If you are unable to use auto.ddl, see the README files in the Lessons source. It will explain how to generate a database update script to go between any two versions of the source.

For the convenience of sites running 2.8, we generate binaries for 2.8. See https://sakai.rutgers.edu/stats/lb-281/