search

sfu-dhil / wphp

Women's Print History Project database front end.
https://womensprinthistoryproject.com/
GNU General Public License v2.0
1 stars 8 forks source link

Unable to delete a contributor from a title record #284

Closed kkatemoffatt closed 2 years ago

kkatemoffatt commented 2 years ago

What isn’t working as expected on the website?

Unable to delete Lydia Maria Child as a "compiler" from title record 14412.

If you encountered an error message, please copy the relevant details or take a screenshot and paste it below.

2021-11-16T10:45:41-08:00 162.157.69.99 GET https://womensprinthistoryproject.com/title/14412/edit https://womensprinthistoryproject.com/title/14412/edit 500 - Doctrine\DBAL\Exception\UniqueConstraintViolationException An exception occurred while executing 'UPDATE title_role SET person_id = ?, role_id = ? WHERE id = ?' with params [4721, 1, 148261]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '14412-4721-1' for key 'titlerole_uniq' Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0

What is the URL of the page where you encountered the bug?

https://womensprinthistoryproject.com/title/14412/edit

What steps did you take before you encountered the bug?

  1. I went to "Database" and clicked on "Search Titles"
  2. I clicked "Advanced search" and typed 14412 into the title ID field, and clicked search
  3. I clicked on the record that came up and clicked "edit title"
  4. I hit the "delete" button beside the Lydia Maria Child, Compiler entry
  5. I hit submit, and got the error message

What browser, operating system, and device were you using when you encountered the error?

Chrome, Windows 10, desktop

Additional information

No response