How to find Moodle version from Database

Sometimes you may need to find what version of Moodle database you have. To find the version of moodle from the database, check in table mdl_config SELECT * FROM `mdl_config` WHERE `name` LIKE ‘%release%’; SELECT * FROM `mdl_config` WHERE `name` LIKE ‘%version%’; These SQL commands will give information about the version of Moodle you are … Read more

Moodle 3.2 PostgreSQL 12 Error reading from database

Moodle 3.2 PostgreSQL error

Moodle 3.2 site started showing error “Error reading from database”. 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. psql -h mydb.hwfckmarrpeo.ap-southeast-2.rds.amazonaws.com -p 5432 -U moodle_user -W I enabled debug in DB … Read more