# Unknown column 'u.note' in 'field list'

**URL:** <https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896>\
**Category:** Installing my Dolibarr\
**Created:** [October 10, 2022, 12:14pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896 "2022-10-10T12:14:00Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![AvonKury](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@AvonKury](https://www.dolibarr.org/forum/u/AvonKury)\
**Post date:** [October 10, 2022, 12:14pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/1 "2022-10-10T12:14:00Z")

</div>

Hi All,

since my provider stopped PHP7.4 they moved to 8. With my current install Alpha 17.0.0 (15.0.03) I received too many errors running Dollibar. It still worked though just very ugly to work with. I tried to upgrade to 16.0.1. and i got this message upon pressing the log in button/  
Unknown column ‘u.note’ in ‘field list’

how to fix this?

thanks  
Albi

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 10, 2022, 1:16pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/2 "2022-10-10T13:16:04Z")

</div>

Hello,

Basically, you have a V16 program with a V17 database.  
It will create a lot of issues.

> [@Can't disable install tools after upgrade to 16 "UPDATED"](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/10):
>
> Hello, This means that the note column doesn’t exist in llx\_user table. Most probably it is due to the fact that your DB is now in V17 : In V17, the note has been rename to note\_private Using a V17 Database with V15 program won’t work.

If you do not have a V16 backup, then you need to install a fresh V16, and re-create everything (or import/export)

---

<div class="post-metadata">

**Author:** ![AvonKury](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@AvonKury](https://www.dolibarr.org/forum/u/AvonKury)\
**Post date:** [October 10, 2022, 1:29pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/3 "2022-10-10T13:29:49Z")

</div>

i dont have V16 backup since i wanted to install a V16 on the V17. Is it possible just to overwrite all htdocs again with V17 and it will work or needs a complete new install and import of V17?

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 10, 2022, 1:51pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/4 "2022-10-10T13:51:33Z")

</div>

V17 is in development, should not be used.

---

<div class="post-metadata">

**Author:** ![AvonKury](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@AvonKury](https://www.dolibarr.org/forum/u/AvonKury)\
**Post date:** [October 10, 2022, 3:37pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/5 "2022-10-10T15:37:13Z")

</div>

this is too late now, my latest backup is from V12.0.03, then upgrade to the V15.0.03 because of the PHP 8 issues. This turned out to be the V17. So what to do the V12 update is more than a months old.

still my answer was if i can just overwrite everything in htdcos with 17 and it will work again or will the error remain?

thanks

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 10, 2022, 7:58pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/6 "2022-10-10T19:58:30Z")

</div>

V17 is unstable, so you will not have the same issue, but you will probably get others…

---

<div class="post-metadata">

**Author:** ![AvonKury](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@AvonKury](https://www.dolibarr.org/forum/u/AvonKury)\
**Post date:** [October 10, 2022, 10:20pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/7 "2022-10-10T22:20:39Z")

</div>

somehow it is running now again once i overwrite all htdocs with V17. Is there a way to downgrade the 17 to 16 without having a 16 backup?

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 10, 2022, 10:50pm UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/8 "2022-10-10T22:50:52Z")

</div>

Hello,

Unfortunately no

---

<div class="post-metadata">

**Author:** ![AvonKury](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@AvonKury](https://www.dolibarr.org/forum/u/AvonKury)\
**Post date:** [October 11, 2022, 6:42am UTC](https://www.dolibarr.org/forum/t/unknown-column-u-note-in-field-list/22896/9 "2022-10-11T06:42:42Z")

</div>

Hi KSar,

ok so nothing i can do but wait for the new 17+ version.

thanks for the help.

Albi
