[ome-users] update existing db

[Bernhard Voigt]

That solved it, thanks! Bernhard

FYI: Upgrade went well, I've converted data from an old 2.3 version to
the latest 4.0 release.


On Thu, Apr 2, 2009 at 2:36 PM,  <josh.moore at gmx.de> wrote:
>
> Bernhard Voigt writes:
>  > Dear Omero-Developers,
>
> Hi Bernhard,
>
>  > I ran the update sql script as described on
>  > http://openmicroscopy.org/site/documents/data-management/omero4/server/upgrade
>  > to move from Omero3.1.1 to version 4.0. Unfortunately I get an pretty
>  > much in the beginning. There's a message like this:
>  >
>  >  ERROR:  Table is not empty: category Please contact the OME
>  > developers for more information --
>  > http://www.openmicroscopy.org/site/community
>  >
>  > What should I do? Empty the table manually - it's just test data?
>
> Yes. There are some types that we don't yet expect to be in any
> production databases and if they are, then they are almost certainly
> malformed, which is why we've added the "Table is not empty"
> check. You can either use:
>
>  DELETE FROM categorygroupcategorylink;
>  DELETE FROM categoryimagelink;
>  DELETE FROM categorygroup;
>  DELETE FROM category;
>
> or even:
>
>  DROP table category CASCADE;
>  etc.
>
> Categories were deprecated during the upgrade to OMERO3A__5, and
> finally removed in OMERO4__0:
>
> https://trac.openmicroscopy.org.uk/omero/browser/trunk/sql/psql/OMERO3A__5/CGCtoPDI.sql
>
>
>  > Thanks! Bernhard
>
> Sure.
> ~Josh.
>