<html><head><base href="x-msg://221/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Ann,<div><br></div><div><div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; 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: 0px; "><div lang="EN-US" link="blue" vlink="purple" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div class="Section1"><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; ">We’re running 1.5.2. The error message reads: “</span><span style="font-size: 11pt; font-family: Calibri, sans-serif; ">org.postgresql.util.PSQLException: ERROR: Cannot insert a duplicate key into unique index community_name_key”<o:p></o:p></span></div><div><div><blockquote style="margin-top: 5pt; margin-bottom: 5pt; "><div><div><div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; ">I’m trying to create two sub-communities with the same name, but dspace doesn’t like it. These sub-communities are within two different communities [one is in a student community and one is in a faculty community], so I don’t see why it should be a problem; thus my query as to whether the issue is a bug, or something that just can’t be done.<o:p></o:p></span></div></div></div></div></blockquote></div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div></div><div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; ">Which version are you running? This bug was fixed in version 1.4. (<a href="http://wiki.dspace.org/index.php/DSpace_Release_1.4.0_Notes" style="color: blue; text-decoration: underline; ">http://wiki.dspace.org/index.php/DSpace_Release_1.4.0_Notes</a>)<o:p></o:p></div></div><div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p> </o:p></div></div><div><div style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman', serif; ">If you are using a later version: what sort of error message does DSpace show when trying to create the sub-communities?</div></div></div></div></span></blockquote><br></div><div>Is this an instance of DSpace that has been upgraded over the years from a version earlier than 1.4?</div><div><br></div><div>If so, then in the upgrade steps from 1.3 to 1.4, a bunch of SQL commands should have been run. One of these is:</div><div><br></div><div><div>ALTER TABLE community DROP CONSTRAINT community_name_key;</div><div><br></div><div>This should have removed that constraint that is stopping you from creating the identically-named sub-community. Try running that command in your database (subject to the usual advice of taking a backup of your system and database first!).</div><div><br></div><div>Thanks,</div><div><br></div></div><br><div>
Stuart Lewis<br>IT Innovations Analyst and Developer<br>Te Tumu Herenga The University of Auckland Library<br>Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand<br>Ph: 64 9 373-7599 x81928<br><a href="http://www.library.auckland.ac.nz/">http://www.library.auckland.ac.nz/</a>
</div>
<br></div></body></html>