Stuart, Here goes:
2008-12-08 14:10:56,445 INFO org.dspace.core.ConfigurationManager @ Loading: /home/dspace/tds/dspace/config/log4j.properties 2008-12-08 14:10:57,681 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = false AND item_id IN ( SELECT item_id FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'date' AND qualifier = 'accessioned') AND text_value::timestamp > '2008-12-01'::timestamp AND text_value::timestamp < '2008-12-31'::timestamp ) " with parameters: Any ideas? Mika 2008/12/8 Stuart Lewis <[EMAIL PROTECTED]>: > Hi Mika, > >> When running stat-monthly I get the following. Any ideas whats wrong? >> I can see the statistics fine till November. >> >> org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1270) >> at >> org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1299) > > This is the query where is trying to count the total number of items in your > repository. > > Could you set your log level to DEBUG, re-run stat-monthly, and forward the > log trace to us. We should be able to see what query DSpace is trying to > run, and hope to see what might be going wrong. For some reason it sounds > like the dates for the start and end of the month are not getting set > properly. > > Thanks, > > > Stuart > _________________________________________________________________ > > Gwasanaethau Gwybodaeth Information Services > Prifysgol Aberystwyth Aberystwyth University > > E-bost / E-mail: [EMAIL PROTECTED] > Ffon / Tel: (01970) 622860 > _________________________________________________________________ > > ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
