Forwarding back to dspace-tech Looks like we may have issues with installing DSpace 1.4.2 + PostgreSQL 8.3, based on problems that Floriana encountered. (see below)
- Tim -------- Original Message -------- Subject: Re: [Dspace-tech] Error with DSpace administrator's account Date: Wed, 12 Mar 2008 16:47:16 +0100 From: floriana perrucci <[EMAIL PROTECTED]> To: Tim Donohue <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> I had installed PostgreSQL 8.3 with DSpace 1.4.2. Now I've installed PostgreSQL 8.2.5 and work well. Thanks very much Floriana Perrucci +39 380 4322283 Rome, Italy 2008/3/12, Tim Donohue <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>: Floriana, What version of PostgreSQL are you trying to install DSpace with? I've heard rumors that Postgres 8.3 (which was just released a month ago) doesn't work well with the DSpace 1.4.2 install. I will admit that I haven't verified this yet, but I'm curious as to whether this may be what you're seeing. If this is the problem you are seeing, you may want to try the install with either Postgres 8.2.x or 8.1.x for the time being (until we can determine if there's something that needs to be fixed for Postgres 8.3). - Tim floriana perrucci wrote: > Goodmorning, > I installed DSpace 1.4.2, but I received an error with DSpace > administrator's account. When I performed the "dsrun > > org.dspace.administer.CreateAdministrator" command next output apparead: > > > C:\Users\Floriana\Desktop\DSpace>C:\Users\Floriana\Desktop\DSpace\bin\dsrun > org.dspace.administer.CreateAdministrator > Using DSpace installation in: C:\Users\Floriana\Desktop\DSpace > Creating an initial administrator account > E-mail address: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> > First name: Floriana > Last name: Perrucci > WARNING: Password will appear on-screen. > Password: password > Again to confirm: password > Is the above data correct? (y or n): y > 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) > > Does anyone know how can help me to debug and solve this error? > > Thanks a lot. > Floriana Perrucci > +39 380 4322283 > Rome, Italy > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > DSpace-tech mailing list > [email protected] <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- ======================================== Tim Donohue Research Programmer, Illinois Digital Environment for Access to Learning and Scholarship (IDEALS) 135 Grainger Engineering Library University of Illinois at Urbana-Champaign email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> web: http://www.ideals.uiuc.edu phone: (217) 333-4648 fax: (217) 244-7764 ======================================== ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
