Hello,

I'm getting the following error on Ubuntu 12.04 while building Dspace with 'ant fresh_install'. All the previous steps are successful, it fails at the load_registries step. I'm using Oracle java 6 version 1.6.0_37, postgresql 9.1, tomcat 7, maven 3.0.4, ant 1.8.4 and I have the 1.8.2 release of dspace. I kept searching for a similar case but I couldn't find any solution.

load_registries:
     [java] 2012-10-27 18:01:08,295 INFO  org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
     [java] 2012-10-27 18:01:08,301 INFO  org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if unintended, check your dspace.cfg for (log.init.config)
     [java] Error: 
     [java]  - ERROR: syntax error at or near ")"
     [java] 2012-10-27 18:01:08,762 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
     [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
     [java]  at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
     [java]  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
     [java]  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
     [java]  at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
     [java]  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
     [java]  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
     [java]  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     [java]  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     [java]  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     [java]  at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
     [java]  at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
     [java]  at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
     [java]  at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
     [java]  at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
     [java]  at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
     [java]  at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)

BUILD FAILED
/home/ubuntu/dspace-1.8.2-release/dspace/target/dspace-1.8.2-build/build.xml:826: Java returned: 1

Thanks,
Yunus Acikoz