# SQL Error during update Concrete 5 from 8.1.0 to 8.3.2 -

**URL:** <https://forums.concretecms.org/t/sql-error-during-update-concrete-5-from-8-1-0-to-8-3-2/5527>\
**Category:** Installation\
**Created:** [May 2, 2023, 4:56pm UTC](https://forums.concretecms.org/t/sql-error-during-update-concrete-5-from-8-1-0-to-8-3-2/5527 "2023-05-02T16:56:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mendesknabepr](https://forums.concretecms.org/user_avatar/forums.concretecms.org/mendesknabepr/32/3541_2.png) [@mendesknabepr](https://forums.concretecms.org/u/mendesknabepr)\
**Post date:** [May 2, 2023, 4:56pm UTC](https://forums.concretecms.org/t/sql-error-during-update-concrete-5-from-8-1-0-to-8-3-2/5527/1 "2023-05-02T16:56:25Z")

</div>

Hello everyone,  
I have a problem updating from Concrete 8.1.0 to 8.3.2. The update aborts with a SQL error.

Error message: “An exception occurred while executing ‘DELETE FROM AttributeValues WHERE avID = ?’ with params [105]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`mp_cms`.`userattributevalues`, CONSTRAINT `FK_4DB68CA6A2A82A5D` FOREIGN KEY (`avID`) REFERENCES `attributevalues` (`avID`))”.

Does anyone of you have an idea to solve this problem?  
Thanks in advance for any help.  
Paulo

---

<div class="post-metadata">

**Author:** ![EvanCooper](https://forums.concretecms.org/user_avatar/forums.concretecms.org/evancooper/32/4597_2.png) [@EvanCooper](https://forums.concretecms.org/u/EvanCooper)\
**Post date:** [May 5, 2023, 4:02pm UTC](https://forums.concretecms.org/t/sql-error-during-update-concrete-5-from-8-1-0-to-8-3-2/5527/2 "2023-05-05T16:02:09Z")

</div>

Hi @mendesknabepr - maybe you can give us a little more detail about your environment - I’m noticing your table names are all lower case, are you on Windows?

---

<div class="post-metadata">

**Author:** ![mendesknabepr](https://forums.concretecms.org/user_avatar/forums.concretecms.org/mendesknabepr/32/3541_2.png) [@mendesknabepr](https://forums.concretecms.org/u/mendesknabepr)\
**Post date:** [May 8, 2023, 10:23am UTC](https://forums.concretecms.org/t/sql-error-during-update-concrete-5-from-8-1-0-to-8-3-2/5527/3 "2023-05-08T10:23:30Z")

</div>

Hi Evan, first of all thank you very much for your feedback. I hope that the following information about the environment will help.

The production version Concrete runs on Ubuntu/Apache(2.4.41) with PHP 7.1.4 and MariaDB 10.11.2. Since we generally do not carry out any updates in the productive environment, we always install this version for the update under localhost. This is a MS Windows 10 machine. Here we use Laragon with Apache(2.4.41); PHP 7.1.4 and MariaDB 10.11.2. If I run the remote update from Concrete 5 8.1.0 to 8.3.2 here under localhost, it is aborted with the error described. After that, the localhost version is no longer executable.  
Best regards,  
Paulo