Re: [Dspace-tech] [Dspace-devel] statistics

2009-08-16 Thread Kim Shepherd
Hi Pradip, (cc’ing to dspace-tech) I can’t guarantee this is the problem, but I’ve encountered this SQL error running stat-initial when I’ve had two metadata schemas that both had element/qualifier combinations that some Dspace queries expect to be unique. For instance, on one of my

Re: [Dspace-tech] [Dspace-devel] statistics

2009-08-16 Thread Van Ly
On 17/08/2009, at 5:56 AM, Kim Shepherd wrote: the subquery run by stat-initial (when it’s getting a count of non-withdrawn items) looks for metadata with element ‘date’ and qualifier ‘accessioned’ but ignores schema ID – both results are returned, and the exception is thrown

Re: [Dspace-tech] [Dspace-devel] statistics

2009-08-16 Thread Kim Shepherd
-Original Message- From: Van Ly [mailto:v...@usyd.edu.au] Sent: Monday, 17 August 2009 11:36 a.m. To: DSpace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] [Dspace-devel] statistics On 17/08/2009, at 5:56 AM, Kim Shepherd wrote: the subquery run by stat-initial (when it’s getting

Re: [Dspace-tech] [Dspace-devel] statistics

2009-08-16 Thread Van Ly
the schema ID I'm talking about. Yep, that would be the `metadata_schema_id'. Thanks. Cheers, Kim -Original Message- From: Van Ly [mailto:v...@usyd.edu.au] Sent: Monday, 17 August 2009 11:36 a.m. To: DSpace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] [Dspace-devel