[ome-users] OMERO 4.1.1 to 4.2.0 upgrade error...

[Jerome Avondo]

Cheers Josh,

Platform: CentOS 5
Postgresql: 8.1.11

J.

----------------------------------------
> Date: Mon, 19 Jul 2010 14:07:53 +0200
> Subject: Re: [ome-users] OMERO 4.1.1 to 4.2.0 upgrade error...
> From: josh.moore at gmx.de
> To: jeromeavondo at msn.com
> CC: ome-users at lists.openmicroscopy.org.uk
>
> Jerome,
>
> What platform is this and what version of PostgreSQL? What's happening
> is that the setting of the variable at the top of the upgrade script:
>
> http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L18
>
> is somehow losing its quotation marks on your platform and being
> interpeted as: \set ACTION ABORT
>
> It'd be good to fix this for others, but if you would like to move
> forward you can change the use of ":ACTION" here:
>
> http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L542
>
> to say:
>
> select * from omero_41_check1(cast('ABORT' as text));
>
> Cheers,
> ~Josh
>
> On Mon, Jul 19, 2010 at 11:20 AM, Jerome Avondo  wrote:
>> This is the error I get on the command line:
>>
>> psql:OMERO4.1__0.sql:542: ERROR:  column "abort" does not exist at character
>> 36
>> psql:OMERO4.1__0.sql:542: LINE 1: select * from omero_41_check1(cast(ABORT
>> as text));
>> psql:OMERO4.1__0.sql:542:                                            ^
>>
>>
>> Thanks,
>>
>> J.
 		 	   		  
_________________________________________________________________
http://clk.atdmt.com/UKM/go/197222280/direct/01/
Do you have a story that started on Hotmail? Tell us now