Hi Tim, Thanks very much for pointing us in the right direction. We think we’ve now resolved the issue by following the instructions for a post you responded to in 2015.
The registry update was being ignored, and when I tried to run it separately, we were getting the error: Caused by: java.sql.BatchUpdateException: Batch entry 0 update public.bitstreamformatregistry set description=NULL, internal='FALSE', mimetype='application/vnd.openxmlformats-officedocument.wordprocessingml.document', short_description=NULL, support_level=-1 where bitstream_format_id=52 was aborted: ERROR: value too long for type character varying(48) Which led me to your 2015 reply to a post about the change of the bitstreamformatregistry table’s mimetype column switching from 48 to 256 characters in DSpace 1.5. We’ve been on DSpace since 1.4, so we’ve obviously been hauling this problem along for a while! After altering the column character length on the 5.6 database the registry update task was initially ignored, but this time when we ran [dspace]/bin/dspace database migrate ignored, it completed successfully. We now have an entry in the site table, and the recent submissions are working – yay! Hopefully there aren’t any other left-over issues that we haven’t identified, but as far as we can tell, all is well. :) Thanks again, Donna From: Tim Donohue <[email protected]> Sent: Wednesday, 19 February 2020 9:51 AM To: Donna Barber <[email protected]>; DSpace Technical Support <[email protected]> Subject: Re: [dspace-tech] Recent-submissions homepage error in DSpace 6.3 Hi Donna, I'd recommend checking that all the Database migrations ran successfully when you upgraded to 6.3. That error seems to be returning a "null" Site object on the homepage. The Site object is a virtual object that represents your site as a whole...it's created automatically in the database in a table named "site". This error seems to imply that some portion of your database migration (which should have created that Site object) must have failed. So, I'd recommend looking at your logs more closely during the upgrade....also, you should run "[dspace]/bin/dspace database info" to see if there are any migrations that your upgrade flagged as IGNORED (if so, you should run them, by running "./dspace database migrate ignored"). More info on these new database commands is at: https://wiki.lyrasis.org/display/DSDOC6x/Database+Utilities Overall, it looks to me like your database upgrade didn't succeed. It's hard to say exactly what happened without looking closer at the logs or what the "database info" command returns. If you find an error and are not sure what is happening, feel free to forward it along to this list and hopefully someone here can help! Tim ________________________________ From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Donna Barber <[email protected]<mailto:[email protected]>> Sent: Sunday, February 16, 2020 7:27 PM To: DSpace Technical Support <[email protected]<mailto:[email protected]>> Subject: [dspace-tech] Recent-submissions homepage error in DSpace 6.3 Hi, We’re in the process of moving from 5.6 to 6.3 with everything up and running in our development environment, except we’ve found that we’re now getting an error trying to view the recently added list from the homepage (/recent-submissions). However, it still works from the community/collection homepages. Does anyone have any idea what could be the cause? We’ve stripped out our customisations and switched between Mirage and Mirage2 themes, but it’s the same. The stack trace produced when clicking on “view more” is attached. Many thanks, Donna Barber eServices Coordinator | Kairuruku Ratonga Tāhiko Library Access and Collections | Rōpū Tautāwhi Phone: +64 3 369 3849 extn 93849 | Puaka - James Hight Building, Level 5, Rm 519 Learning Resources | University of Canterbury | Te Whare Wānanga o Waitaha | Private Bag 4800 | Christchurch 8140 | New Zealand Website: http://www.canterbury.ac.nz/library -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/9f93b399-eeda-4245-99a9-32c64da0ce25%40googlegroups.com<https://groups.google.com/d/msgid/dspace-tech/9f93b399-eeda-4245-99a9-32c64da0ce25%40googlegroups.com?utm_medium=email&utm_source=footer>. -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/849236C290751747BCBC92C1BED308077FBCD0B0%40UCEXMBX04-I.canterbury.ac.nz.
