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