[
https://jira.duraspace.org/browse/DS-680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Donohue updated DS-680:
---------------------------
Assignee: Mark H. Wood
Developers discussed this in our meeting on Feb 16, 2011
Full Thread follows:
[20:20] <tdonohue> moving on for now: https://jira.duraspace.org/browse/DS-680
invalid input syntax for type timestamp in db query for stat-initial utility
[20:21] <tdonohue> anyone have ideas on DS-680, or want to volunteer to
investigate this further?
[20:21] <mhwood> Hmmm, where did that "::" stuff come from?
[20:23] <tdonohue> mhwood -- that "::" looks to also be in Trunk version of
LogAnalyser
[20:23] <tdonohue> lines 1209 and 1225 of LogAnalyser in Trunk
[20:24] <mhwood> If no one else wants it, I can dig into it.
[20:24] <tdonohue> ok, assign DS-680 to mhwood for investigation / fix
> 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
> Assignee: Mark H. Wood
>
> 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
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
