[
https://jira.duraspace.org/browse/DS-680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark H. Wood updated DS-680:
----------------------------
Status: Open (was: Received)
> invalid input syntax for type timestamp in db query for stat-initial utility
> ----------------------------------------------------------------------------
>
> Key: DS-680
> URL: https://jira.duraspace.org/browse/DS-680
> Project: DSpace
> Issue Type: Bug
> Affects Versions: 1.6.2
> Environment: DSpace 1.6.2; Java JDK 1.6.0 (Sun); Apache Ant 1.8.1;
> JUnit 4.8.2; Apache Maven 2.2.1; Apache Tomcat 6.0.26; Apache Httpd 2.2.15;
> Tomcat Connector 1.2.30 (for mod_jk); PostgreSQL 8.4.4
> Reporter: Royal Roads University
>
> DSpace 1.6.2 >> Command [dspace]/bin/stat-initial generates an Exception:
> ERROR: invalid input syntax for type timestamp
> Traced issue to extraneous content in db query in WHERE clause( e.g. AND
> text_value::timestamp > ...)
> Traced to:
> /dspace-1.6.2-src-release/dspace-api/src/main/java/org/dspace/app/statistics/LogAnalyser.java
> CHANGED FROM:
> Line 1240:
> dateQuery.append(" AND text_value::timestamp > '" +
> unParseDate(startDate) + "'::timestamp ");
> Line 1255:
> dateQuery.append(" AND text_value::timestamp > '" +
> unParseDate(startDate) + "'::timestamp ");
> CHANGED TO:
> Line 1240:
> dateQuery.append(" AND text_value > '" +
> unParseDate(startDate) + "' ");
> Line 1255:
> dateQuery.append(" AND text_value > '" +
> unParseDate(startDate) + "' ");
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.duraspace.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
