Fixing the upgrade procedure of WebCalendar 1.2 for PostgreSQL 7.4

When trying to upgrade WebCalendar to 1.2, I fell on a series of errors due to the fact that the upgrade script relies on a dependency to PostgreSQL 8.1, which allows much more ALTER TABLE syntaxes than PostgreSQL 7.4. Nevertheless, there are ways to make it work by updating the upgrade script a little to suit the new syntax. I'm giving bits of code here, which are directly based on the www/install/sql/update-postgres.sql script, and altered to make it work. This script can be executed manually as many times as you want with the PostgreSQL user you use for Webcalendar.

Preparing Dokeos 1.8.5 RC1

Next week, we will be releasing an RC1 for Dokeos 1.8.5. The main targets for this version are:
  • fixing SCORM (import, export and reporting)
  • fixing audio recorder and some videoconference minor bugs
  • improving the templating system
  • adding repetitive events to the agenda (and iCal import, as well)
I'm quite annoyed because I will have to update the database structure to allow for repetitive events, but we're still before RC1 so it is still an "acceptable" change, and apparently it's been said it would be in 1.8.5, so...