<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I want to add that we started to investigate a vanilla install of 1.5</div><div><br class="webkit-block-placeholder"></div><div>After creating new communities, collections and adding a few reconds, we realized that we experience internal errors as mentioned before when using the Titles Search, Issue date and items withdrawn. When I deleted the records (thus cleaning the DB of actual records), I don't receive internal errors.</div><div><br class="webkit-block-placeholder"></div><br><div><div>On 23 Apr 2008, at 3:35 PM, Munro, LG, Mr <<a href="mailto:munrol@sun.ac.za">munrol@sun.ac.za</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div lang="EN-US" link="blue" vlink="blue"><div class="Section1"><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><o:p> </o:p></span></font></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Hello,</span></font><o:p></o:p></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "> <o:p></o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">We managed to do a fresh install 1.5 successfully without the issues mentioned below, thus a stable and solid system.<o:p></o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; "><o:p> </o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">But whilst testing the upgrading process, we encountered a few issues. I am also following/proofreading the dspace manual, so I am pretty sure I am not missing anything.<o:p></o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; "><o:p> </o:p></span></font></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">We sucessfully ran the SQL indexing update scripts for upgrading our Dspace 1.3.2 installation to 1.4 and then to 1.5, but noticed the following:<o:p></o:p></span></font></div><div style="text-indent: -18pt; margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Symbol"><span style="font-size: 12pt; font-family: Symbol; "><span>·<font size="1" face="Times New Roman"><span style="font: normal normal normal 7pt/normal 'Times New Roman'; "> <span class="Apple-converted-space"> </span></span></font></span></span></font><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">the additional Bit Stream Registries that are included with 1.5, are not in our PostgreSQL database<span class="Apple-converted-space"> </span><br>(we know there are 73 Bit Stream registries because we did a separate test install of 1.5). <span class="Apple-converted-space"> </span><br>It seems these additional rows in the Postgres database are not included in the update sql scripts like they<br>are present in the create database schema sql scripts for fresh installations. <span class="Apple-converted-space"> </span><br><br></span></font><o:p></o:p></div><div style="text-indent: -18pt; margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Symbol"><span style="font-size: 12pt; font-family: Symbol; "><span>·<font size="1" face="Times New Roman"><span style="font: normal normal normal 7pt/normal 'Times New Roman'; "> <span class="Apple-converted-space"> </span></span></font></span></span></font><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">In addition, we receive internal errors on the following links:</span></font><o:p></o:p></div><div style="text-indent: -18pt; margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Courier New"><span style="font-size: 12pt; font-family: 'Courier New'; "><span>o<font size="1" face="Times New Roman"><span style="font: normal normal normal 7pt/normal 'Times New Roman'; "> <span class="Apple-converted-space"> </span></span></font></span></span></font><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Titles search/sort</span></font><o:p></o:p></div><div style="text-indent: -18pt; margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Courier New"><span style="font-size: 12pt; font-family: 'Courier New'; "><span>o<font size="1" face="Times New Roman"><span style="font: normal normal normal 7pt/normal 'Times New Roman'; "> <span class="Apple-converted-space"> </span></span></font></span></span></font><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Item Issue indexes don't work with our upgraded data, but they do work on the fresh install</span></font><o:p></o:p></div><div style="text-indent: -18pt; margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Courier New"><span style="font-size: 12pt; font-family: 'Courier New'; "><span>o<font size="1" face="Times New Roman"><span style="font: normal normal normal 7pt/normal 'Times New Roman'; "> <span class="Apple-converted-space"> </span></span></font></span></span></font><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Withdrawn Items</span></font><o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><o:p> </o:p></span></font></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">In regard to the SQL problem we need to know if we have missed something, or is an additional step omitted from the upgrade instructions? If not either, how does one go about updating your tables? We are also confident that the other issues are sql related, especially withdrawn items, which should be empty…<o:p></o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; "><o:p> </o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; "><o:p> </o:p></span></font></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Trust to hear from the community,<o:p></o:p></span></font></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "> <o:p></o:p></span></font></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Regards,</span></font><o:p></o:p></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial; ">Laurence</span></font><o:p></o:p></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "> <o:p></o:p></span></font></div></div><div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "> <o:p></o:p></span></font></div></div></div>_______________________________________________<br>Dspace-general mailing list<br><a href="mailto:Dspace-general@mit.edu" style="color: blue; text-decoration: underline; ">Dspace-general@mit.edu</a><br><a href="http://mailman.mit.edu/mailman/listinfo/dspace-general" style="color: blue; text-decoration: underline; ">http://mailman.mit.edu/mailman/listinfo/dspace-general</a><br></div></span></blockquote></div><br></body></html>