Admire, I believe this should be normal,. It is upgrading the 1.4 browse system to the Configurable Browse implementation in 1.5. You will then want to run dspace/bin/index-init to get you default Browse By indicies popluated. Make sure you are running the rest of the upgrade process to update your [dspace]/lib and [dspace]/webapps to 1.5
Mark On Thu, Jan 7, 2010 at 4:41 AM, Mutsikiwa Admire <amutsik...@uzlib.uz.ac.zw> wrote: > Hi All, > > > > I am trying to upgrade my DSpace instance from version 1.4.2 to 1.5.0. When > updating the database schema using the > /dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql file, the > execution is resulting in the dropping of views, which impacts on the > running of the updated DSpace instance. Here is the except from the update: > > $psql -U dspace -f > /dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql dspace > > ALTER TABLE > > UPDATE 68 > > ALTER TABLE > > ALTER TABLE > > ALTER TABLE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:80: > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "collection_item_count_pkey" for table "collection_item_count" > > CREATE TABLE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:85: > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "community_item_count_pkey" for table "community_item_count" > > CREATE TABLE > > DROP SEQUENCE > > DROP SEQUENCE > > DROP SEQUENCE > > DROP SEQUENCE > > DROP SEQUENCE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: > NOTICE: drop cascades to rule _RETURN on view communityitemsbyauthor > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: > NOTICE: drop cascades to view communityitemsbyauthor > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: > NOTICE: drop cascades to rule _RETURN on view collectionitemsbyauthor > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: > NOTICE: drop cascades to view collectionitemsbyauthor > > DROP TABLE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: > NOTICE: drop cascades to rule _RETURN on view communityitemsbytitle > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: > NOTICE: drop cascades to view communityitemsbytitle > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: > NOTICE: drop cascades to rule _RETURN on view collectionitemsbytitle > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: > NOTICE: drop cascades to view collectionitemsbytitle > > DROP TABLE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: > NOTICE: drop cascades to rule _RETURN on view communityitemsbydate > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: > NOTICE: drop cascades to view communityitemsbydate > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: > NOTICE: drop cascades to rule _RETURN on view collectionitemsbydate > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: > NOTICE: drop cascades to view collectionitemsbydate > > DROP TABLE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: > NOTICE: drop cascades to rule _RETURN on view communityitemsbydateaccession > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: > NOTICE: drop cascades to view communityitemsbydateaccession > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: > NOTICE: drop cascades to rule _RETURN on view > collectionitemsbydateaccession > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: > NOTICE: drop cascades to view collectionitemsbydateaccession > > DROP TABLE > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: > NOTICE: drop cascades to rule _RETURN on view communityitemsbysubject > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: > NOTICE: drop cascades to view communityitemsbysubject > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: > NOTICE: drop cascades to rule _RETURN on view collectionitemsbysubject > > psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: > NOTICE: drop cascades to view collectionitemsbysubject > > DROP TABLE > > DROP TABLE > > DROP TABLE > > > > As a results, I end up with two views instead of 12 as in DSpace 1.4.2. Is > this correct? I cannot views items after the upgrade as I get the > “communityitemsbydate relation not found” error. > > > > Kind Regards, > > > > Admire Mutsikiwa (Mr) > > ICT Projects Manager > > Library IT > > University of Zimbabwe > > Tell:+263-4-303276 > > Cell:+263-92239187 > > Alt/email:amutsik...@gmail.com > > > > ------------------------------------------------------------------------------ > This SF.Net email is sponsored by the Verizon Developer Community > Take advantage of Verizon's best-in-class app development support > A streamlined, 14 day to market process makes app distribution fast and easy > Join now and get one step closer to millions of Verizon customers > http://p.sf.net/sfu/verizon-dev2dev > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > -- Mark R. Diggory Head of U.S. Operations - @mire http://www.atmire.com - Institutional Repository Solutions http://www.togather.eu - Before getting together, get t...@ther ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech