[Dspace-tech] Problems with stat-initial and stat-monthly
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
Re: [Dspace-tech] Problems with stat-initial and stat-monthly
Hi Sean, > 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" > > This is on a 1.5 installation. You'll be pleased to know that you've not done anything wrong - it is a small bug in 1.5, which has been fixed ready for 1.5.1 You need to update the following file: /dspace-api/src/main/java/org/dspace/app/statistics/LogAnalyser.java You can download an up to date version from: http://dspace.svn.sourceforge.net/viewvc/dspace/branches/dspace-1_5_x/dspace -api/src/main/java/org/dspace/app/statistics/LogAnalyser.java (or http://tinyurl.com/dspace15-stat-patch) You'll then need to recompile and redeploy DSpace, and it should then work. > 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? start.year and start.month should now be set in [dspace]/config/dstat.cfg start.year = 2005 start.month = 1 Thanks, Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ - 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
Re: [Dspace-tech] Problems with stat-initial and stat-monthly
2008/8/6 Stuart Lewis <[EMAIL PROTECTED]>: > Hi Sean, > >> 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" >> >> This is on a 1.5 installation. > > You'll be pleased to know that you've not done anything wrong - it is a > small bug in 1.5, which has been fixed ready for 1.5.1 That is a relief, thank you Stuart. 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