<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Jerome,<div><br></div><div>I'm going to try and answer for Josh, since he's actually on holiday right now (still checking his e-mail occasionally). </div><div><br></div><div>It looks like your user (id=2) is the owner of several Projects, Datasets and Images in group=2 ("default") but these have various links and annotations that were created in group=4 ("CoenLab"). </div><div><br></div><div>You should be able to resolve these using the </div><div>omero-4.1-move-to-group.sql </div><div>script mentioned and linked from here: <a href="http://openmicroscopy.org/site/support/omero4/server/db-upgrade-41-to-42">http://openmicroscopy.org/site/support/omero4/server/db-upgrade-41-to-42</a></div><div><br></div><div>You can choose to move all of the data belonging to user=2 to either group 2 or 4.</div><div>E.g. to move to group 4, the command would be</div><div><br></div><div>psql -vGRP=4 -vUSR=2 -f omero-4.1-move-to-group.sql <my-database></div><div><br></div><div>Then you should be able to upgrade 4.1 -> 4.0 as normal. </div><div>Just make sure you back up your DB, before you go ahead. </div><div><br></div><div>If you need reminding who is user ID=2, you can do </div><div>bin/omero user list</div><div><br></div><div>If the above solution doesn't fit your needs, then let us know (Josh will certainly have to handle that one).</div><div><br></div><div> Hope this helps,</div><div><br></div><div> Will. </div><div><br></div><div><br></div><div> <br><div><div>On 19 Jul 2010, at 13:48, Jerome Avondo wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><br>Hi Again,<br><br>By manually editing I got a little further, but still stuck...<br>Upgrade2.log file is attached, as well as the output from the consolle (consolle.txt)<br><br>thanks,<br><br>J.<br><br>----------------------------------------<br><blockquote type="cite">From: <a href="mailto:jeromeavondo@msn.com">jeromeavondo@msn.com</a><br></blockquote><blockquote type="cite">To: <a href="mailto:josh.moore@gmx.de">josh.moore@gmx.de</a><br></blockquote><blockquote type="cite">Date: Mon, 19 Jul 2010 12:17:25 +0000<br></blockquote><blockquote type="cite">CC: <a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br></blockquote><blockquote type="cite">Subject: Re: [ome-users] OMERO 4.1.1 to 4.2.0 upgrade error...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Cheers Josh,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Platform: CentOS 5<br></blockquote><blockquote type="cite">Postgresql: 8.1.11<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">J.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">----------------------------------------<br></blockquote><blockquote type="cite"><blockquote type="cite">Date: Mon, 19 Jul 2010 14:07:53 +0200<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Subject: Re: [ome-users] OMERO 4.1.1 to 4.2.0 upgrade error...<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">From: <a href="mailto:josh.moore@gmx.de">josh.moore@gmx.de</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">To: <a href="mailto:jeromeavondo@msn.com">jeromeavondo@msn.com</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">CC: <a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Jerome,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">What platform is this and what version of PostgreSQL? What's happening<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">is that the setting of the variable at the top of the upgrade script:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L18">http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L18</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">is somehow losing its quotation marks on your platform and being<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">interpeted as: \set ACTION ABORT<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">It'd be good to fix this for others, but if you would like to move<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">forward you can change the use of ":ACTION" here:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L542">http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L542</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">to say:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">select * from omero_41_check1(cast('ABORT' as text));<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Cheers,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">~Josh<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">On Mon, Jul 19, 2010 at 11:20 AM, Jerome Avondo wrote:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">This is the error I get on the command line:<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">psql:OMERO4.1__0.sql:542: ERROR: column "abort" does not exist at character<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">36<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">psql:OMERO4.1__0.sql:542: LINE 1: select * from omero_41_check1(cast(ABORT<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">as text));<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">psql:OMERO4.1__0.sql:542: ^<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">Thanks,<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">J.<br></blockquote></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_________________________________________________________________<br></blockquote><blockquote type="cite"><a href="http://clk.atdmt.com/UKM/go/197222280/direct/01/">http://clk.atdmt.com/UKM/go/197222280/direct/01/</a><br></blockquote><blockquote type="cite">Do you have a story that started on Hotmail? Tell us now<br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">ome-users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br></blockquote><blockquote type="cite"><a href="http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users">http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users</a><br></blockquote> <span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span> <br>_________________________________________________________________<br><a href="http://clk.atdmt.com/UKM/go/195013117/direct/01/">http://clk.atdmt.com/UKM/go/195013117/direct/01/</a><br><span><upgrade2.log></span><span><consolle.txt></span>_______________________________________________<br>ome-users mailing list<br>ome-users@lists.openmicroscopy.org.uk<br>http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users<br></div></blockquote></div><br><div apple-content-edited="true"> <div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>William Moore</div><div><div>Wellcome Trust Centre for Gene Regulation & Expression</div><div>College of Life Sciences</div><div>MSI/WTB/JBC Complex</div><div>University of Dundee</div><div>Dow Street</div><div>Dundee DD1 5EH</div><div>United Kingdom</div><div><br></div><div>Phone 01382 386364</div></div><div><a href="http://openmicroscopy.org.uk">http://openmicroscopy.org.uk</a></div></div></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"> </div><br></div></body></html>