10 November 2021, 3:28

Hello folks,

is Mahara 18.04 working with PostgreSQL 13.4?

The startpage just says:
"A nonrecoverable error occurred. This probably means you have encountered a bug in the system"

The pg-log says:
"ERROR:  column d.adsrc does not exist at character 24
STATEMENT:  SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='institution' order by d.adnum"

We are in a kind of a chicken-and-egg situation and updating to Mahara 21 before changing to the new server with pg 13 isn´t that easy beacause of a outdated Ubuntu-Version with too old PHP-Version (that isn´t supported by Mahara 21 anymore) on the old server.

According to the readme (https://git.mahara.org/mahara/mahara/-/tree/21.10_STABLE) 21.10 is the first Mahara-Version officially supporting pg 13. Nevertheless Mahara 21.04 works fine with pg 13 on our test server.

Thanks für your answers and hints!

kind regards
Klaus

10 November 2021, 8:59

Hi Klaus,

There was a fix for this issue in later versions of Mahara -> https://bugs.launchpad.net/mahara/+bug/1913504

The fix is shown here https://reviews.mahara.org/#/c/11687/2/htdocs/lib/adodb/drivers/adodb-postgres64.inc.php

You could try applying that fix to your site to see if it helps.

Note: version 18.04 is quite old now and there may be other problems encountered trying to run 18.04 on new infrastructure

Cheers

Robert

11 November 2021, 4:32

Hi Robert,

thank you very much!

That fix works.

kind regards
Klaus