Hi Mika, > 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?
Try running that query directly in Postgres, and see if it works. It should work fine, and return a number. If it doesn't work, then we'll need to know the error message. If it does work, then I'll be puzzled as that is the query that DSpace is running. 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); 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