Yes, that's the process I followed; I downloaded each version and ran the appropriate sql files to upgrade the database and then did the dump to import to 1.6.
On 12/13/10 1:10 PM, "Jeffrey Trimble" <jatrim...@ysu.edu> wrote: Well the simple answer is that 'you can't' go from 1.3.2 to 1.6 directly. There are sql scripts between each major release that change the database in various ways. So 1.6 is expecting different relationships that aren't there. You'll need to upgrade from 1.3.2 to 1.4.x, then 1.4.x to 1.5x then 1.5 to 1.6x. I wouldn't even think of suggesting a dangerous shortcut I thought of, because of the interlinkings and the changes with the DSpace config file over the life of these previous releases. Sorry to be a bearer of bad news. --Jeffrey Trimble On Dec 13, 2010, at 1:26 PM, Savage, Karen R. wrote: We are in the process of upgrading our instance of Dspace from 1.3.2 to 1.6. The process I followed was to upgrade a copy of the 1.3.2 database up to 1.6, dump the database to a text file and then create a fresh instance of 1.6. Once it was up, I deleted the database it had created, made a new blank one and imported the dump I had made previously. But when I run index-init, I get a bunch of 'relation does not exist' errors (see below). Should I have reindexed after each database upgrade? Is that the cause of my problem? -- Karen Savage Baylor University Libraries Electronic Library Library Systems karen_sav...@baylor.edu (254) 710-3275 Creating browse and search indexes ERROR: relation "bi_1" does not exist at character 15 STATEMENT: SELECT * FROM bi_1 LIMIT 1 ERROR: relation "bi_1_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_1_dis LIMIT 1 ERROR: relation "bi_2" does not exist at character 15 STATEMENT: SELECT * FROM bi_2 LIMIT 1 ERROR: relation "bi_3" does not exist at character 15 STATEMENT: SELECT * FROM bi_3 LIMIT 1 ERROR: relation "bi_3_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_3_dis LIMIT 1 ERROR: relation "bi_4" does not exist at character 15 STATEMENT: SELECT * FROM bi_4 LIMIT 1 ERROR: relation "bi_5" does not exist at character 15 STATEMENT: SELECT * FROM bi_5 LIMIT 1 ERROR: relation "bi_5_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_5_dis LIMIT 1 ERROR: relation "bi_6" does not exist at character 15 STATEMENT: SELECT * FROM bi_6 LIMIT 1 ERROR: relation "bi_6_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_6_dis LIMIT 1 ERROR: relation "bi_7" does not exist at character 15 STATEMENT: SELECT * FROM bi_7 LIMIT 1 ERROR: relation "bi_7_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_7_dis LIMIT 1 ERROR: relation "bi_8" does not exist at character 15 STATEMENT: SELECT * FROM bi_8 LIMIT 1 ERROR: relation "bi_8_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_8_dis LIMIT 1 ERROR: relation "bi_9" does not exist at character 15 STATEMENT: SELECT * FROM bi_9 LIMIT 1 ERROR: relation "bi_9_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_9_dis LIMIT 1 ERROR: relation "bi_10" does not exist at character 15 STATEMENT: SELECT * FROM bi_10 LIMIT 1 ERROR: relation "bi_10_dis" does not exist at character 15 STATEMENT: SELECT * FROM bi_10_dis LIMIT 1 LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection ------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech Jeffrey Trimble System LIbrarian William F. Maag Library Youngstown State University 330.941.2483 (Office) jatrim...@ysu.edu http://www.maag.ysu.edu http://digital.maag.ysu.edu ""For he is the Kwisatz Haderach..." ------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
