Can anyone say whether there is a problem with postgresql 8.3 on windows which would cause the error I have seen. I'm having problems just setting up a stock 1.4.2 DSpace.
John On Wed, Aug 13, 2008 at 9:34 AM, John Preston <[EMAIL PROTECTED]> wrote: > So am I to take it that there is a problem with postgresql 8.3 > > John > > On Wed, Aug 13, 2008 at 8:41 AM, Víctor Izaguirre <[EMAIL PROTECTED]> wrote: >> Try with Postgresql 8.2 >> >> 2008/8/13 John Preston <[EMAIL PROTECTED]> >>> >>> Does anybody know why I would get the following error trying to run >>> create administrator on a new 1.4.2 dspace installation. >>> >>> Exception occurred:org.postgresql.util.PSQLException: ERROR: operator >>> does not exist: integer = character varying >>> org.postgresql.util.PSQLException: ERROR: operator does not exist: >>> integer = character varying >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) >>> at >>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) >>> at >>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) >>> at >>> org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:159) >>> at >>> org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:447) >>> at >>> org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:465) >>> at >>> org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager.java:647) >>> at >>> org.dspace.storage.rdbms.DatabaseManager.find(DatabaseManager.java:612) >>> at org.dspace.eperson.Group.find(Group.java:635) >>> at >>> org.dspace.administer.CreateAdministrator.main(CreateAdministrator.java:142) >>> >>> Using psql I can see that the administrator group 1 exists in the >>> database. >>> >>> John >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win great >>> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in the >>> world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> DSpace-tech mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> >> >> >> -- >> Saludos cordiales, >> >> Víctor Izaguirre Castro >> > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
