Forum .LRN Q&A: Re: Res: Re: Problem with create class

Collapse
3: Re: Res: Re: Problem with create class (response to 2)
Posted by Fernando Jose Ernesto Mendoza Jerez on 07/07/09 01:00 AM
The server have a PG8.2, dotLRN 2.1.0b4  and i'm using PG8.3, dotLRN 2.4.1

try to install PG8.2

Collapse
4: Re: Res: Re: Problem with create class (response to 3)
Posted by Emmanuelle Raffenne on 07/07/09 11:49 AM
Hi Fernando,

.LRN 2.4.1 is not ready for postgresql version 8.3, it works with pg 8.1 and 8.2. We recommend you use version 8.2.

.LRN 2.5.0 will support postgresql version 8.3

Collapse
5: Re: Res: Re: Res: Re: Problem with create class (response to 4)
Posted by Fernando Jose Ernesto Mendoza Jerez on 07/07/09 07:49 PM
thanks Emmanualle

The scenario is PG8.2, dotLRN-2.1.0b4 but restored in reviewing PG8.3 the log postgresql found the following error:

psql: backup.01-07-2009.dump: 16003236: ERROR: foreign key constraint "rss_gen_subscrs_ctx_fk" can not be implemented
DETAIL: Key columns "summary_context_id" and "object_id" are of incompatible types: character varying and integer.

Collapse
6: Re: Problem with create class (response to 5)
Posted by Emmanuelle Raffenne on 07/08/09 12:11 PM
Hi Fernando,

dotLRN 2.1.0 uses OpenACS 5.1, check the compatibility matrix at http://www.openacs.org/xowiki/openacs-compatibility-matrix

Collapse
7: Re: Res: Re: Res: Re: Problem with create class (response to 4)
Posted by Fernando Jose Ernesto Mendoza Jerez on 07/23/09 11:05 PM
Hi emmanuelle

I try restore the database en PG8.2 but dont work i get the same error

Collapse
8: Re: Res: Re: Res: Re: Problem with create class (response to 5)
Posted by Don Baccus on 07/27/09 09:21 PM
The problem is that "summary_context_id" was declared to be varchar(100) originally, though the key it references is an integer.

Versions of PG up to 8.2 would automatically convert it to an integer, PG 8.3 correctly catches it as a type incompatibility error.

It was fixed by me in february 2008 so should be in 2.4, actually, *however* I rather stupidly forgot to commit my upgrade script, so I guess I'll have to recreate it...

I'll post here when I do ...

For now, use PG 8.2 ...

Collapse
9: Re: Res: Re: Res: Re: Problem with create class (response to 7)
Posted by Don Baccus on 07/27/09 09:51 PM
OK, I've added the upgrade script on the oacs-5-5 branch.

If you'd like to test it, check it out and use the APM package upgrade facility to install the upgrade on your local copy.