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

[Jerome Avondo]

Hi Again,

By manually editing I got a little further, but still stuck...
Upgrade2.log file is attached, as well as the output from the consolle (consolle.txt)

thanks,

J.

----------------------------------------
> From: jeromeavondo at msn.com
> To: josh.moore at gmx.de
> Date: Mon, 19 Jul 2010 12:17:25 +0000
> CC: ome-users at lists.openmicroscopy.org.uk
> Subject: Re: [ome-users] OMERO 4.1.1 to 4.2.0 upgrade error...
>
>
> 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
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
 		 	   		  
_________________________________________________________________
http://clk.atdmt.com/UKM/go/195013117/direct/01/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: upgrade2.log
Type: application/octet-stream
Size: 3539 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20100719/6a9017c1/attachment.obj>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: consolle.txt
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20100719/6a9017c1/attachment.txt>