Installation help

 
 
Picture of Helder Pereira
Upgrade from 2.2 to 2.4 on Oracle Database
 

Hello everyone. Little problem here.

After doing everything in the Upgrade Documentation page, I get the error in the attached file.

I know what the errors mean, but I can't find the source of the problem.

Any help would be great since it's a problem that is making my moodle install offline.

Thank you.


 
Average of ratings: -
Picture of Howard Miller
Re: Upgrade from 2.2 to 2.4 on Oracle Database
Group DevelopersGroup Documentation writersGroup Particularly helpful Moodlers

My guess is a bug - as it's Oracle.

I would be inclined to roll-back and see if you can upgrade to 2.3. Backup your site there and then try for 2.4. If it still fails make a tracker report.

 
Average of ratings: -
Picture of Helder Pereira
Re: Upgrade from 2.2 to 2.4 on Oracle Database
 

Hello and thank you.

I tried as you said, first to 2.3 then to 2.4.

But 2.3 gives the exact error. The first in the picture only with another content in the variables.

 

 
Average of ratings: -
Picture of Howard Miller
Re: Upgrade from 2.2 to 2.4 on Oracle Database
Group DevelopersGroup Documentation writersGroup Particularly helpful Moodlers

No idea sorry - it seems to failing writing to the config table and it does seem to have two values. We need someone who knows about Oracle and that isn't me.

 
Average of ratings: -
Picture of Helder Pereira
Re: Upgrade from 2.2 to 2.4 on Oracle Database
 

I know Oracle. What I don't know is much of PHP and Moodle "internals" so I can't find the place where that problem occurs.

In the message I can see moodle_database.php, but that file, from what I can understand is some kind of wrapper to the real "insert command". And that I cannot seem to find it...

Again, thank you.

 
Average of ratings: -
Picture of Helder Pereira
Re: Upgrade from 2.2 to 2.4 on Oracle Database
 

It's a bug. I solved it by adding a trigger on a table. It's a sequence not being passed to the insert clause.

Reported the bug here: hxxxs://tracker.moodle.org/browse/MDL-39222

 
Average of ratings:Useful (1)
Sketch...
Re: Upgrade from 2.2 to 2.4 on Oracle Database
Group Particularly helpful Moodlers

Thanks, but what Oracle sequence did you have to create and on which table?

 
Average of ratings: -
Picture of Helder Pereira
Re: Upgrade from 2.2 to 2.4 on Oracle Database
 

Hi. I did not created a sequence. The sequence already exist. For some reason I did not yet found out, the insert doesn't use it. So I created a trigger to force the use of the sequence before an insert.

The sequence is M_CONF_ID_SEQ. M_ is my Moodle prefix, by default is MLD I think.

 
Average of ratings: -