[ https://issues.apache.org/jira/browse/ROL-1739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Glen Mazza resolved ROL-1739. ----------------------------- Resolution: Fixed Fix Version/s: 5.1 Added to createdb.vm script (for new databases) in order to trap the potential error in the code; not adding to the 500-to-510 migration script in case legacy invalid data exists in those tables. > Missing constraint on weblogentrytagagg table > --------------------------------------------- > > Key: ROL-1739 > URL: https://issues.apache.org/jira/browse/ROL-1739 > Project: Apache Roller > Issue Type: Bug > Components: Data Model & JPA Backend > Reporter: David Johnson > Assignee: Glen Mazza > Fix For: 5.1 > > > from Tatsuya Noyori on the Roller user list: > "I have had an error on Roller that is caused by duplicated records on > roller_weblogentrytagagg when I post an entry by AtomPub. > Thus, I would like to suggest to add the following SQL to dbscript of > create.sql in Roller." > alter table roller_weblogentrytagagg add constraint rweta_name_uq > unique ( websiteid, name ); -- This message was sent by Atlassian JIRA (v6.2#6252)