Sunday, January 16, 2011

Moodle 2.0 Course Backup: DDL SQL Execution Error

Moodle 2.0 fails to backup courses (and quizzes) returning the following error: "DDL sql execution error".

It appears that this error occurs if the database user does not have the permission to create temporary tables.

Thursday, January 6, 2011

PostgreSQL Installation Problem on Windows without WSH

PostgreSQL 8.3 and 8.4 may fail to install on Windows with the following error message: "An error occurred executing the Microsoft VC++ runtime installer". PostgreSQL 9.x may fail with a different message: "Unable to write inside TEMP environment variable path", but the actual reason appears to be the same.