Details
Description
Cron running on Moodle 2.3 finishes with this error:
Backing up Careers...complete - next execution: Wednesday, 18 July 2012, 2:00 AM
|
Backing up Data Analysis...complete - next execution: Wednesday, 18 July 2012, 2:00 AM
|
Backing up 12 Legal Studies...complete - next execution: Wednesday, 18 July 2012, 2:00 AM
|
Sending email to admin
|
!!! Error reading from database !!!
|
Postgres version is:
PostgreSQL 8.3.14 on x86_64-unknown-linux-gnu, compiled by GCC gcc (SUSE Linux) 4.3.2 [gcc-4_3-branch revision 141291]
It looks to be because the query in get_backup_status_array() is missing an "AS" for aliasing one of the columns.
PostgreSQL 8.3 requires the "AS" to alias a column. See here http://www.postgresql.org/docs/8.3/static/sql-select.html