Moodle 3.2 PostgreSQL 12 Error reading from database

Moodle 3.2 site started showing error “Error reading from database”.

Moodle 3.2 PostgreSQL error

I checked config.php, the database credentials are correct, i was able to login to Amazon AWS RDS PostgreSQL database with the credentaials and able to see the database tables with command \dt.

I enabled debug in DB with following SQL commands

But for some reason, moodle did not show any further debug info.

I did a search for the error message “Error reading from database” using ack command, that search inside files.

I added some debug code in file

That shows the SQL command that caused the failure. The error was

This was because PostgreSQL removed the column name adsrc. To fix, edit file

Find (On line 394)

Replace with

For more information on this patch, see MDL-67220

See moodle

Leave a Reply

Your email address will not be published. Required fields are marked *