Re: [Dspace-tech] How to clear all monthly reports and start from the beginning

2011-11-29 Thread Evelthon Prodromou
Hello Stuart, Thank you for your reply. I followed you suggestion. There was indeed a rogue SQL query, the one below. 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

Re: [Dspace-tech] How to clear all monthly reports and start from the beginning

2011-11-28 Thread Evelthon Prodromou
Hello again, I am asking once more in case someone missed my last email. It will be really helpful if anyone can point me to the right direction. I did the following since my last email. I edited dstat.cfg and changed start.year to 2001 and start.month to 11. I then cleared /[dspace]/reports

Re: [Dspace-tech] How to clear all monthly reports and start from the beginning

2011-11-28 Thread Stuart Lewis
Hi Evelthon, If you enable DEBUG logging in DSpace, and then re-run the command, the dspace.log file should show the SQL that is failing. If you could show us that, it might help to work out where the error is. My guess is a bad value in the dspace statistics config file, but the SQL should