# Error when upgrading from 5 to 7.2.2

**URL:** <https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926>\
**Category:** Questions\
**Created:** [June 14, 2019, 2:35pm UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926 "2019-06-14T14:35:57Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![emilsjog](https://avatars.discourse-cdn.com/v4/letter/e/ec9cab/32.png) [@emilsjog](https://forum.litium.com/u/emilsjog)\
**Post date:** [June 14, 2019, 2:35pm UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/1 "2019-06-14T14:35:57Z")

</div>

Getting this error when I’m running the upgrade command:

`Error-Could not convert Content Property "Text" in table dbo.CMS_PageTypeProperty to field because it has multiple definitions. Please make sure to have one defintion for each content property. Read more on https://docs.litium.com/documentation/upgrading-to-litium-7/upgrading-the-database#Fields`

I looked at the link but I can’t figure out how to solve it. Anyone fimiliar with this?

Litium version: 5.4.2-patch-1706131929

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [June 17, 2019, 7:35am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/2 "2019-06-17T07:35:03Z")

</div>

How are you upgrading your solution?  
Beginning on on new 7.2 Accelerator and lifting in code from v5 or are you trying to upgrade 5 accelerator directly to 7.2?

---

<div class="post-metadata">

**Author:** ![emilsjog](https://avatars.discourse-cdn.com/v4/letter/e/ec9cab/32.png) [@emilsjog](https://forum.litium.com/u/emilsjog)\
**Post date:** [June 17, 2019, 7:37am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/3 "2019-06-17T07:37:45Z")

</div>

First upgrade the database and then try it out with a new accelerator and see how it behaves.

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [June 17, 2019, 7:46am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/4 "2019-06-17T07:46:58Z")

</div>

You probebly have 2 properties with same name that you need to change.  
Check the ones with SimpleStringProperty och LongStringProperty.

You can find them with this query:  
`SELECT PropertyName, COUNT(DISTINCT PropertyType) AS NumberOfPropertyType FROM CMS_PageProperty GROUP BY PropertyName ORDER BY PropertyName DESC`

---

<div class="post-metadata">

**Author:** ![emilsjog](https://avatars.discourse-cdn.com/v4/letter/e/ec9cab/32.png) [@emilsjog](https://forum.litium.com/u/emilsjog)\
**Post date:** [June 17, 2019, 8:02am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/6 "2019-06-17T08:02:58Z")

</div>

Got these properties with the same name. Is it possible to change these from the BO or do I simply update them in DB?

```
ListingImage 2
Files	2
FirstImage	2
PageSize	2
SecondImage	2
Image1	2
```

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [June 17, 2019, 8:09am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/7 "2019-06-17T08:09:01Z")

</div>

If you can run BO then change it from there otherwise you need to alter DB directly.

---

<div class="post-metadata">

**Author:** ![emilsjog](https://avatars.discourse-cdn.com/v4/letter/e/ec9cab/32.png) [@emilsjog](https://forum.litium.com/u/emilsjog)\
**Post date:** [June 17, 2019, 8:21am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/8 "2019-06-17T08:21:43Z")

</div>

OK, i can run the BO. Where do I make the change? I’m only used to Litium 7 and it’s not quite the same

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [June 17, 2019, 8:51am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/9 "2019-06-17T08:51:27Z")

</div>

I think you might need to change the value directly in DB.

---

<div class="post-metadata">

**Author:** ![emilsjog](https://avatars.discourse-cdn.com/v4/letter/e/ec9cab/32.png) [@emilsjog](https://forum.litium.com/u/emilsjog)\
**Post date:** [June 17, 2019, 8:56am UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/10 "2019-06-17T08:56:54Z")

</div>

Updated a value in the `CMS_PageTypeProperty` and did run the upgrade with 0 errors. Thanks for input!

---

<div class="post-metadata">

**Author:** ![steve.redstorm](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/steve.redstorm/32/14_2.png) [@steve.redstorm](https://forum.litium.com/u/steve.redstorm)\
**Post date:** [June 17, 2019, 1:19pm UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/11 "2019-06-17T13:19:27Z")

</div>

Also check if Pages using that property got the value on upgrade, that “could” also be missing.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/12eddac3b8b661de1db86af10ac8151b571e6fb9.png) [@system](https://forum.litium.com/u/system)\
**Post date:** [July 15, 2019, 1:19pm UTC](https://forum.litium.com/t/error-when-upgrading-from-5-to-7-2-2/926/12 "2019-07-15T13:19:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
