[Dspace-tech] Error in MultilingualismDSpace Patch

[Victoria Rasero]

We have implemented the MultilingualismDSpace Patch:
http://sourceforge.net/tracker/index.php?func=detail&aid=1450491&group_id=19984&atid=319984

We obtain an error when we try to submit items.

The error is:
"Error in line: 84 in file jsp: /submit/edit-metadata.jsp 
Error de servlet generado: 
The method getMonthName(int) in the type DCDate is not applicable for the arguments (int, Locale)" ;
but we look at the file DCDate.java, and the method ' getMonthName(int, Locale)' is correct.
Could anyone help us?
Many thanks

--------------------------------------------------------------------
Victoria Rasero
Gestión de Recursos de Información
Biblioteca de la Universidad Carlos III de Madrid
---------------------------------------------------------------------

[Claudia Jürgen]

Hello Victoria,

we run this patch along with 1.4.1 and do not run into this error.

Seems as if your servlet container still got some old data.
Build the dspace.war again.
Stop your Servlet container.
Supposing it is Tomcat, remove your deployment in
/webapps
and
/work

cp the new dspace.war to /webapps and start your servlet container.

sunny greetings

Claudia

Victoria Rasero schrieb:

> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Victoria Rasero]

Claudia,
we have run the patch and we have created a new colum (language) in the e-person table.
We have DSpace 1.4, Tomcat and postgreSQL.
We have rebuild.
And when I register in My DSpace we obtain an error:

ID de Sesión:5E5BB1F390D265D37BCCBB82A41A6BA6
-- URL Was: http://e-archivo2.uc3m.es:8080/dspace/mydspace
-- Method: GET
-- Parameters were:

Excepción:
org.postgresql.util.PSQLException: The column index is out of range: 1,
number of columns:0
       at org.postgresql.core.v3.SimpleParameterList.bind (SimpleParameterList.java:57)
       at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:105)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.bindString (AbstractJdbc2Statement.java :2089)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1202)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java :1188)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java :131)
       at org.dspace.storage.rdbms.DatabaseManager.loadParameters(DatabaseManager.java:1724)
       at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:257)
       at org.dspace.storage.rdbms.DatabaseManager.query (DatabaseManager.java:278)
       at org.dspace.workflow.WorkflowManager.getOwnedTasks(WorkflowManager.java:242)
       at org.dspace.app.webui.servlet.MyDSpaceServlet.showMainPage(MyDSpaceServlet.java :585)
       at org.dspace.app.webui.servlet.MyDSpaceServlet.doDSGet(MyDSpaceServlet.java:97)
       at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
       at org.dspace.app.webui.servlet.DSpaceServlet.doGet (DSpaceServlet.java:99)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:252)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
       at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter (RegisteredOnlyFilter.java :98)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java :173)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
       at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:126)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
       at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:663)
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
       at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt (LeaderFollowerWorkerThread.java :80)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
       at java.lang.Thread.run(Thread.java:595)

Could you help us, please?
Many thanks.

--
Victoria Rasero
Gestión de Recursos de Información
Biblioteca de la Universidad Carlos III de Madrid

Tfno: 91 624 90 76
Correo-e: vra...@db.uc3m.es
---------------------------------------------------------------------

2007/3/13, Claudia Jürgen < Claudia...@ub.uni-dortmund.de>:

[Richard Jones]

Hi Victoria,

This is pretty strange. Can you, by any chance, turn your logging up to
debug level (look in config/log4j.properties, and replace the instance
of "INFO" with "DEBUG" and restart Tomcat), reproduce the error, and
send us the logging from the request (from log/dspace.log). It might
make it possible to see how the problem is arising.

Cheers,

Richard

> Correo-e: vra...@db.uc3m.es <mailto:vra...@db.uc3m.es>

> ---------------------------------------------------------------------
>
> 2007/3/13, Claudia Jürgen < Claudia...@ub.uni-dortmund.de

> <mailto:Claudia...@ub.uni-dortmund.de>>:

> <mailto:DSpac...@lists.sourceforge.net>
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech

>
>
>
>
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech

--
Richard
------------------------------------------------------------------------
Richard Jones | t: +44 (0)20 759 [48614 / 41815]
Web & Database | e: richard...@imperial.ac.uk
Technology Specialist | b: http://chronicles-of-richard.blogspot.com/
Imperial College London |
------------------------------------------------------------------------

[Dan Scott]

On 16/03/07, Victoria Rasero <vra...@db.uc3m.es> wrote:
> Claudia,
> we have run the patch and we have created a new colum (language) in the
> e-person table.
> We have DSpace 1.4, Tomcat and postgreSQL.
> We have rebuild.
> And when I register in My DSpace we obtain an error:
>
> ID de Sesión:5E5BB1F390D265D37BCCBB82A41A6BA6
> -- URL Was: http://e-archivo2.uc3m.es:8080/dspace/mydspace
> -- Method: GET
> -- Parameters were:
>
> Excepción:
> org.postgresql.util.PSQLException: The column index is out of range: 1,
> number of columns:0

That sounds vaguely familiar. If there were already e-persons
registered in the database before you applied the patch and created
the language column for the table, did you try assigning a default
language to all the existing e-persons?

For example, something like:

UPDATE e-person SET language = 'en';

(or something like that -- I don't have the code / schema in front of
me at the moment).

Dan

[Victoria Rasero]

Richard,
thank you for your reponse.
I have turn the logging and I send you the error:

-- Method: GET
-- Parameters were:

2007-03-19 14:21:19,752 DEBUG org.dspace.app.webui.util.JSPManager @ anonymous:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=163.117.159.141:view_jsp:/login/password.jsp
2007-03-19 14:21:33,116 DEBUG org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr= 163.117.159.141:http_request:-- URL Was: http://e-archivo2.uc3m.es:8080/dspace/password-login
-- Method: POST
-- Parameters were:
-- login_password: *not logged*
-- login_submit: "Entrar"
-- login_email: "vra...@db.uc3m.es"

2007-03-19 14:21:33,116 INFO  org.dspace.eperson.PasswordAuthentication @ anonymous:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr= 163.117.159.141:authenticate:attempting password auth of user=vra...@db.uc3m.es
2007-03-19 14:21:33,121 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from eperson where email = ? "
2007-03-19 14:21:33,187 INFO  org.dspace.eperson.PasswordAuthentication @ vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=163.117.159.141:authenticate:type=PasswordAuthentication
2007-03-19 14:21:33,190 INFO  org.dspace.app.webui.servlet.PasswordServlet @ vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=163.117.159.141:login:type=explicit
2007-03-19 14:21:33,211 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from eperson where eperson_id = ? "
2007-03-19 14:21:33,216 DEBUG org.dspace.app.webui.servlet.DSpaceServlet @ vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr= 163.117.159.141:http_request:-- URL Was: http://e-archivo2.uc3m.es:8080/dspace/mydspace

-- Method: GET
-- Parameters were:

2007-03-19 14:21:33,217 INFO  org.dspace.app.webui.servlet.MyDSpaceServlet @ vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=163.117.159.141:view_mydspace:
2007-03-19 14:21:33,311 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * FROM WorkflowItem WHERE owner=2"
2007-03-19 14:21:33,324 WARN  org.dspace.app.webui.servlet.DSpaceServlet @ vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=163.117.159.141:database_error:org.postgresql.util.PSQLException: El índice de la columna está fuera de rango: 1, número de columnas: 0.
org.postgresql.util.PSQLException: El índice de la columna está fuera de rango: 1, número de columnas: 0.
    at org.postgresql.core.v3.SimpleParameterList.bind (SimpleParameterList.java:57)
    at org.postgresql.core.v3.SimpleParameterList.setLiteralParameter(SimpleParameterList.java:101)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.bindLiteral(AbstractJdbc2Statement.java :2077)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.setInt(AbstractJdbc2Statement.java:1112)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:116)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.setInt (DelegatingPreparedStatement.java:116)
    at org.dspace.storage.rdbms.DatabaseManager.loadParameters(DatabaseManager.java:1729)
    at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:157)
    at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:194)
    at org.dspace.workflow.WorkflowManager.getOwnedTasks(WorkflowManager.java:245)
    at org.dspace.app.webui.servlet.MyDSpaceServlet.showMainPage (MyDSpaceServlet.java:585)

    at org.dspace.app.webui.servlet.MyDSpaceServlet.doDSGet(MyDSpaceServlet.java:97)
    at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
    at org.dspace.app.webui.servlet.DSpaceServlet.doGet (DSpaceServlet.java:99)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

    at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java :98)

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

    at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java :663)

    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
2007-03-19 14:21:39,023 DEBUG org.dspace.app.webui.util.JSPManager @ vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=163.117.159.141:view_jsp:/error/internal.jsp
2007-03-19 14:23:18,624 DEBUG org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:session_id=5D6F4D9B8F16CBE486F2C35F5BAD4A0B:ip_addr=66.249.72.173:http_request:-- URL Was: http://e-archivo2.uc3m.es:8080/dspace/items-by-author?author=lksaoiulkj%2C+lkj%C3%B1fdaoiu&order=title

-- Method: GET
-- Parameters were:

-- order: "title"
-- author: "lksaoiulkj, lkjñfdaoiu"

2007-03-19 14:23:18,633 DEBUG org.dspace.browse.BrowseCache @ Checking browse cache with 0 objects
2007-03-19 14:23:18,635 DEBUG org.dspace.browse.BrowseCache @ Running SQL to check whether index has changed: "select count(items_by_author_id) as count, max(items_by_author_id) as max from ItemsByAuthor"
2007-03-19 14:23:18,635 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select count(items_by_author_id) as count, max(items_by_author_id) as max from ItemsByAuthor"
2007-03-19 14:23:18,652 DEBUG org.dspace.browse.BrowseCache @ Not in browse cache
2007-03-19 14:23:18,653 DEBUG org.dspace.browse.Browse @ Subquery is "null"
2007-03-19 14:23:18,653 DEBUG org.dspace.browse.Browse @ Created SQL "select * from (SELECT DISTINCT *  from ItemsByAuthor ) as distinct_view where (sort_author = ?) order by sort_author"
2007-03-19 14:23:18,658 DEBUG org.dspace.browse.Browse @ Adding result 82
2007-03-19 14:23:18,673 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from item where item_id = ? "
2007-03-19 14:23:18,676 DEBUG org.dspace.content.Item @ anonymous:session_id=5D6F4D9B8F16CBE486F2C35F5BAD4A0B:ip_addr=66.249.72.173:find_item:item_id=82
2007-03-19 14:23:18,676 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * FROM MetadataValue WHERE item_id= ?  ORDER BY metadata_field_id, place"
2007-03-19 14:23:18,689 INFO  org.dspace.content.MetadataField @ Loading MetadataField elements into cache.
2007-03-19 14:23:18,689 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * from MetadataFieldRegistry"
2007-03-19 14:23:18,714 INFO  org.dspace.content.MetadataSchema @ Loading schema cache for fast finds
2007-03-19 14:23:18,714 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * from MetadataSchemaRegistry"
2007-03-19 14:23:18,729 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT handle FROM Handle WHERE resource_type_id = ? AND resource_id = ?"
2007-03-19 14:23:18,731 DEBUG org.dspace.browse.Browse @ Number of matches 1
2007-03-19 14:23:18,732 DEBUG org.dspace.browse.Browse @ Number of Results: 1 Overall position: 0 Total 1 Offset 0
2007-03-19 14:23:18,732 DEBUG org.dspace.browse.Browse @ Got results: 0 to 1 out of 1
2007-03-19 14:23:18,732 INFO  org.dspace.app.webui.servlet.ItemsByAuthorServlet @ anonymous:session_id=5D6F4D9B8F16CBE486F2C35F5BAD4A0B:ip_addr=66.249.72.173:items_by_author:order=title ,result_count=1
2007-03-19 14:23:18,732 DEBUG org.dspace.app.webui.util.JSPManager @ anonymous:session_id=5D6F4D9B8F16CBE486F2C35F5BAD4A0B:ip_addr=66.249.72.173:view_jsp:/browse/items-by-author.jsp
2007-03-19 14:26:18,510 DEBUG org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:session_id=FBE73063114A3496DC1B53486DA7DE89:ip_addr=66.249.72.173:http_request:-- URL Was: http://e-archivo2.uc3m.es:8080/dspace/items-by-author?author=Garc%C3%ADa-Romero+%2C+Antonio&order=title

-- Method: GET
-- Parameters were:

-- order: "title"
-- author: "García-Romero , Antonio"

2007-03-19 14:26:18,510 DEBUG org.dspace.browse.BrowseCache @ Checking browse cache with 0 objects
2007-03-19 14:26:18,510 DEBUG org.dspace.browse.BrowseCache @ Not in browse cache
2007-03-19 14:26:18,510 DEBUG org.dspace.browse.Browse @ Subquery is "null"
2007-03-19 14:26:18,510 DEBUG org.dspace.browse.Browse @ Created SQL "select * from (SELECT DISTINCT *  from ItemsByAuthor ) as distinct_view where (sort_author = ?) order by sort_author"
2007-03-19 14:26:18,513 DEBUG org.dspace.browse.Browse @ Adding result 85
2007-03-19 14:26:18,513 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "select * from item where item_id = ? "
2007-03-19 14:26:18,515 DEBUG org.dspace.content.Item @ anonymous:session_id=FBE73063114A3496DC1B53486DA7DE89:ip_addr=66.249.72.173:find_item:item_id=85
2007-03-19 14:26:18,515 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * FROM MetadataValue WHERE item_id= ?  ORDER BY metadata_field_id, place"
2007-03-19 14:26:18,518 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT handle FROM Handle WHERE resource_type_id = ? AND resource_id = ?"
2007-03-19 14:26:18,519 DEBUG org.dspace.browse.Browse @ Number of matches 1
2007-03-19 14:26:18,519 DEBUG org.dspace.browse.Browse @ Number of Results: 1 Overall position: 0 Total 1 Offset 0
2007-03-19 14:26:18,519 DEBUG org.dspace.browse.Browse @ Got results: 0 to 1 out of 1
2007-03-19 14:26:18,519 INFO  org.dspace.app.webui.servlet.ItemsByAuthorServlet @ anonymous:session_id=FBE73063114A3496DC1B53486DA7DE89:ip_addr=66.249.72.173:items_by_author:order=title ,result_count=1
2007-03-19 14:26:18,520 DEBUG org.dspace.app.webui.util.JSPManager @ anonymous:session_id=FBE73063114A3496DC1B53486DA7DE89:ip_addr=66.249.72.173:view_jsp:/browse/items-by-author.jsp
2007-03-19 14:29:18,575 DEBUG org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:session_id=D6FE3A294D981BBA6999018C16E64F71:ip_addr=66.249.72.173:http_request:-- URL Was: http://e-archivo2.uc3m.es:8080/dspace/items-by-author?author=Santamar%C3%ADa+%2C+Llu%C3%ADs&order=title
-- Method: GET

Many thanks. Regards

--
Victoria Rasero
Gestión de Recursos de Información
Biblioteca de la Universidad Carlos III de Madrid

---------------------------------------------------------------------

2007/3/16, Richard Jones < richard...@imperial.ac.uk>:

> org.dspace.storage.rdbms.DatabaseManager.query (DatabaseManager.java:257)

> org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:178)

>        at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126)
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105)
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
> :107)
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection

> ( Http11BaseProtocol.java:663)

>        at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt

> ( LeaderFollowerWorkerThread.java :80)

[Claudia Jürgen]

Hi Victoria,

> 2007-03-19 14:21:33,311 DEBUG org.dspace.storage.rdbms.DatabaseManager @
> Running query "SELECT * FROM WorkflowItem WHERE owner=2"
> 2007-03-19 14:21:33,324 WARN org.dspace.app.webui.servlet.DSpaceServlet @
> vra...@db.uc3m.es:session_id=9AD622FD61B0BF83A7DA168770DDD1AA:ip_addr=
> 163.117.159.141:database_error:org.postgresql.util.PSQLException: El

> índice
> de la columna está fuera de rango: 1, número de columnas: 0.

this query "SELECT * FROM WorkflowItem WHERE owner=2"
seems odd, if you really do run 1.4 it should be
"SELECT * FROM WorkflowItem WHERE owner=?"
The parameter is allready bound and the error occurs on trying to bind a
parameter (2) which does not exist.

Which version of
org/dspace/workflow/WorkflowManager.java
do you use?

Claudia

[Victoria Rasero]

---------- Forwarded message ----------
From: Victoria Rasero <victori...@gmail.com>
Date: 21-mar-2007 12:59
Subject: Re: [Dspace-tech] Fwd: Error in MultilingualismDSpace Patch
To: Claudia Jürgen <Claudia...@ub.uni-dortmund.de>
Cc: dspac...@lists.sourceforge.net

Claudia,
thanks for your response.
We have DSpace 1.4 and the path is 'multilingualism-CVS-2006-04-07'.

We have modified the file:
usr/local/dspace-1.4-source/org/dspace/workflow/WorkflowManager.java
We have changed the method getOwnedTasks(Context c, EPerson e) la
petición TableRowIterator tri = DatabaseManager.queryTable(c,
"workflowitem", myquery,e.getID()), por  TableRowIterator tri =
DatabaseManager.query (c, myquery);

and now works.
Many thanks. Regards
-------------------------------------------------------------------
Victoria Rasero

Gestión de Recursos de Información
Biblioteca de la Universidad Carlos III de Madrid
---------------------------------------------------------------------

2007/3/20, Claudia Jürgen < Claudia...@ub.uni-dortmund.de >:

--
Victoria Rasero
Gestión de Recursos de Información
Biblioteca de la Universidad Carlos III de Madrid
Tfno: 91 624 90 76
Correo-e: vra...@db.uc3m.es

---------------------------------------------------------------------

[Claudia Jürgen]

Hi Victoria,

good too hear that it works now.
But I still wonder, how you ran into it, as the applying of the
multilingualism patch got nothing to do with it. It does not change this
part of the WorkflowManager. Are you sure you started with 1.4 stable
release and only applied this patch?

sunny greetings

Claudia Jürgen




Victoria Rasero schrieb:
> Claudia,
> thanks for your response. We have DSpace 1.4 and the version patch is 1.32.

> We have modified the file:
> usr/local/dspace-1.4-source/org/dspace/workflow/WorkflowManager.java
> We have changed the method getOwnedTasks(Context c, EPerson e) la
> petición TableRowIterator tri = DatabaseManager.queryTable(c,
> "workflowitem", myquery,e.getID()), por TableRowIterator tri =
> DatabaseManager.query(c, myquery);
>

> Many thanks. Regards
> -------------------------------------------------------------------

> Victoria Rasero
> Gestión de Recursos de Información
> Biblioteca de la Universidad Carlos III de Madrid
> ---------------------------------------------------------------------
>
>

> 2007/3/20, Claudia Jürgen <Claudia...@ub.uni-dortmund.de >: