[ome-users] java omero update setup-db deploy fails

[Markus Dorn]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi list,

I hope you can help me out.

I have followed the great installation guide in the wiki, but when I
try to:

java omero update setup-db deploy

I get the following:

- --->8 schnipp 8<---
Buildfile: build.xml

update:
Created dir: /usr/local/omero-3.0-Beta2/omero/omero2030538765
Copying 1 file to /usr/local/omero-3.0-Beta2/omero/omero2030538765
Updating jar: /usr/local/omero-3.0-Beta2/omero/omero.ear
Deleting directory /usr/local/omero-3.0-Beta2/omero/omero2030538765

reload-db:
Copying 1 file to /usr/local/omero-3.0-Beta2/omero/target
Copying 1 file to /usr/local/omero-3.0-Beta2/omero/target
Executing file: /usr/local/omero-3.0-Beta2/omero/target/ddl.sql
Executing file: /usr/local/omero-3.0-Beta2/omero/target/data.sql
Failed to execute:   alter table dbpatch alter id set default
nextval('seq_dbpatch'), alter permissions set default -35, alter
message set default 'Updating'

BUILD FAILED
/usr/local/omero-3.0-Beta2/omero/build.xml:83: The following error
occurred while executing this
line: /usr/local/omero-3.0-Beta2/omero/components/server/build.xml:15:
The following error occurred while executing this
line: /usr/local/omero-3.0-Beta2/omero/components/antlib/resources/macros.xml:47:
org.postgresql.util.PSQLException: ERROR: syntax error at or near ","

Total time: 13 seconds
- --->8 schnapp 8<---

I have no experience with postgres sql and so I am lost!

Versions: 
java -version
java version "1.5.0_10"
javac -version
javac 1.5.0_10
psql --version
psql (PostgreSQL) 7.4.16
Debian Etch
(anything else important?)

Thanks for help.

Markus
- -- 
****************************************************************
* Markus Dorn                         PHONE : +49 6221 54 9149 *
* ASIC Labor                            FAX : +49 6221 54 9112 *
* Im Neuenheimer Feld 227    mailto:dorn at kip.uni-heidelberg.de *
* D-69120 Heidelberg      http://wwwasic.kip.uni-heidelberg.de *
****************************************************************

GPG Key: 0xEC5847C4 or finger -l mdorn at ix.urz.uni-heidelberg.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (SunOS)

iD8DBQFG+kbmrgzVAOxYR8QRAkcQAKCpQ4/SS1BZc8JneM3PekT3gXKL1ACgsvwl
AB2TIQncCajmQ2CJizNs72I=
=989y
-----END PGP SIGNATURE-----