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
