invalid input syntax for type timestamp in db query for stat-initial utility
----------------------------------------------------------------------------
Key: DS-680
URL: http://jira.dspace.org/jira/browse/DS-680
Project: DSpace 1.x
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
Priority: Minor
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:
http://jira.dspace.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
