Hi,<br><br><span id="result_box" class="medium_text"><span style="background-color: rgb(255, 255, 255);" title="tengo un problema con la actualizacion de la base de datos postgresql8.1 a la 8.4, actualmente estoy usando la version de DSpace 1.4.2.">I have a problem with updating the database postgresql8.1 to 8.4, I am currently using version 1.4.2 of DSpace.<br>
</span><span style="background-color: rgb(255, 255, 255);" title="el sigueinte es el error que me genera.">the error is payable are generated by me.<br></span><span title="Gracias"></span></span><br>2009-12-01 18:21:18,929 WARN org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:session_id=53468F88760ECBA21183090138CAFEAB:ip_addr=0:0:0:0:0:0:0:1:database_error:org.postgresql.util.PSQLException: ERROR: el operador no existe: integer = character varying<br>
org.postgresql.util.PSQLException: ERROR: el operador no existe: integer = character varying<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)<br> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)<br>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)<br> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<br> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<br>
at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:159)<br> at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:447)<br> at org.dspace.storage.rdbms.DatabaseManager.querySingleTable(DatabaseManager.java:465)<br>
at org.dspace.storage.rdbms.DatabaseManager.findByUnique(DatabaseManager.java:647)<br> at org.dspace.storage.rdbms.DatabaseManager.find(DatabaseManager.java:612)<br> at org.dspace.content.Item.find(Item.java:205)<br>
at org.dspace.content.Collection.<init>(Collection.java:146)<br> at org.dspace.content.Community.getCollections(Community.java:477)<br> at org.dspace.app.webui.servlet.CommunityListServlet.doDSGet(CommunityListServlet.java:90)<br>
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)<br> at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br>
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br>
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br>
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)<br> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)<br> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)<br>
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)<br> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)<br> at java.lang.Thread.run(Thread.java:619)<br>
<br><span id="result_box" class="medium_text"><span title="Gracias">Thanks</span></span><br><br clear="all">--<br>Jonathan Narvaez<br>SYSADMIN<br><br>