Title: Message Title
|
|
|
|
|
Issue Type:
|
![Bug]() Bug
|
|
Assignee:
|
Unassigned
|
|
Created:
|
17/Nov/13 2:49 AM
|
|
Environment:
|
*Location*: http://demo.dspace.org/
*User-Agent*: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0
*Screen Resolution*: 1366 x 768
|
|
Labels:
|
collector-60e7afac
|
|
Reporter:
|
Anonymous (No Reply)
|
|
After install dspace 4.0RC
Run command dspace stat-initial from /dspace/bin
dspace show:
Exception: ERROR: more than one row returned by a subquery used as an _expression_ org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an _expression_
----------------------------------------------------------
This is log file with DEBUG
2013-11-17 09:44:21,831 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No CacheManagerEventListenerFactory class specified. Skipping...
2013-11-17 09:44:21,862 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No BootstrapCacheLoaderFactory class specified. Skipping...
2013-11-17 09:44:21,862 DEBUG net.sf.ehcache.config.ConfigurationHelper @ No CacheExceptionHandlerFactory class specified. Skipping...
2013-11-17 09:44:22,487 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 LIKE '____-__-__T__:__:__Z' AND text_value::timestamp > '2005-01-01'::timestamp AND text_value::timestamp < '2005-01-31'::timestamp ) " with parameters:
2013-11-17 09:44:22,519 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 LIKE '____-__-__T__:__:__Z' AND text_value::timestamp > '2005-01-01'::timestamp AND text_value::timestamp < '2005-01-31'::timestamp ) AND item_id IN ( SELECT item_id FROM metadatavalue WHERE text_value LIKE '%Thesis or Dissertation%' AND metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'type' AND qualifier IS NULL) ) " with parameters:
*Reporter*: Nguyen Hung Thanh
*E-mail*: [mailto:nghungth...@gmail.com]
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
