# Update from 6.8 to 6.8.01 with Deaccession Records

**URL:** <https://speciforum.org/t/update-from-6-8-to-6-8-01-with-deaccession-records/775>\
**Category:** Specify 6 Documentation\
**Tags:** Specify-6\
**Created:** [September 26, 2022, 5:57pm UTC](https://speciforum.org/t/update-from-6-8-to-6-8-01-with-deaccession-records/775 "2022-09-26T17:57:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [September 26, 2022, 5:57pm UTC](https://speciforum.org/t/update-from-6-8-to-6-8-01-with-deaccession-records/775/1 "2022-09-26T17:57:47Z")

</div>

For databases that contain Deaccession data that are trying to update to `6.8.01`, this error can commonly occur:

> #### Database Schema Update Error
> 
> ```bash
> The database schema cannot be updated because it contains deaccession data. Please contact Specify customer support.
> 
> ```

Due to the rework of how deaccession data is handled in Specify 6.8.01, all existing deaccession records must be exported from the database before the update occurs.

If you are familiar with querying the database in SQL, you can start by checking what data is present in the `deaccessionAgent` ,`deaccessionPreparation`, and `deaccession` tables. That data will need to be exported before the update occurs!

After the data is properly exported, it must be removed from the database before the update can proceed.

If you are unfamiliar, members can send Specify a SQL dump of the database and we can do the upgrade for you!

---

<div class="post-metadata">

**Author:** ![mcruz](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/mcruz/32/451_2.png) [@mcruz](https://speciforum.org/u/mcruz)\
**Post date:** [January 20, 2023, 4:42am UTC](https://speciforum.org/t/update-from-6-8-to-6-8-01-with-deaccession-records/775/2 "2023-01-20T04:42:12Z")

</div>

1. After export, how do we remove these records from the database?
2. How do these records get imported back into the database after the update has occurred?

---

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [January 20, 2023, 6:37pm UTC](https://speciforum.org/t/update-from-6-8-to-6-8-01-with-deaccession-records/775/3 "2023-01-20T18:37:06Z")

</div>

You need to remove all of the records from the `deaccessionAgent` ,`deaccessionPreparation`, and `deaccession` tables.

Once you have updated, we recommend manually entering them using Specify 6.