On 26 March 2012 11:05, Wellaway, Ian <[email protected]> wrote: > After updating from 1.6.2 to 1.8.2, I get the following error when > attempting to remove a group from any of the three workflow roles when > editing a collection (Accept/Reject, Accept/Reject/Edit Metadata Step, Edit > Metadata Step): > > > > java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
During your upgrades, did you update your database for each version? e.g.: 8. Update the Database. You will need to run the 1.6.x to 1.7.x database upgrade script. For PostgreSQL: psql -U [dspace-user] -f [dspace-source]/dspace/etc/postgres/database_schema_16-17.sql [database name] (Your database name is by default 'dspace'). Example: psql -U dspace -f [dspace-source]/dspace/etc/postgres/database_schema_16-17.sql dspace For Oracle: Execute the upgrade script, e.g. with sqlplus, recording the output: 1. Start SQL*Plus with sqlplus [connect args] 2. Record the output: SQL> spool 'upgrade.lst' 3. Run the upgrade script SQL> @[dspace-source]/dspace/etc/oracle/database_schema_16-17.sql 4. Turn off recording of output: SQL> spool off 9. Generate Browse and Search Indexes. It's always good policy Sean -- Sean Carte esAL Library Systems Manager +27 72 898 8775 +27 31 373 2490 fax: 0866741254 http://esal.dut.ac.za/ ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
