Anybody have any idea what I've done wrong here? I get the following
error when I try to run stat-initial or stat-monthy:
[EMAIL PROTECTED]:/dspace$ bin/stat-initial
Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
syntax error at or near "FROM"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:209)
at
org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:279)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1273)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1302)
at
org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:543)
at
org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport.java:291)
at
org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:162)
This is on a 1.5 installation.
I thought perhaps it might be a permissions problem, but stat-general
runs and generates a .dat file.
Could it be a configuration problem? In 1.4 I know I had to set
$start_year and $start_month in the stat-* files, but that no longer
seems to be the case. Is there somewhere else I should be setting that
information?
Sean
--
Sean Carte
esAL Library Systems Manager
+27 72 898 8775
+27 31 373 2490
fax: 0866741254
http://esal.dut.ac.za/
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
