# Can't disable install tools after upgrade to 16 "UPDATED" **URL:** \ **Category:** Maintaining my Dolibarr\ **Tags:** Issue\ **Created:** [September 14, 2022, 4:40pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782 "2022-09-14T16:40:04Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 14, 2022, 4:40pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/1 "2022-09-14T16:40:04Z")
Tried to upgrade from v15 to v16 following the steps provided and now I can’t get it off the install screen, algo I got: Latest version upgrade: **16.0.0** - Version program: **17.0.0-alpha** I installed the 16 stable version and now i asking to install the 17 alpha version, tried to install it to see if that fixes my problem but got this error: Error DB\_ERROR\_CANNOT\_ADD\_FOREIGN\_KEY\_CONSTRAINT: ALTER TABLE llxdo\_element\_categorie ADD CONSTRAINT fk\_element\_categorie\_fk\_categorie FOREIGN KEY (fk\_categorie) REFERENCES llxdo\_fk\_categorie(rowid); Cannot add foreign key constraint I need to create some proposals and I’m stuck, please help. UPDATE: Reinstall Dolibarr 16 and now my user password doesnt work. I get this error when I enter my correct username and password: Unknown column ‘u.note’ in ‘field list’ ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [September 14, 2022, 7:53pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/2 "2022-09-14T19:53:03Z")
I have same problem but try server is working and that is install with Ubuntu 22.04 from start my normal server have started with 18.04 → 20.04 → 22.04 and that give same error as you have. Tomorrow i will try to re install my old server with Ubuntu 22.04 hope that will work ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 14, 2022, 8:17pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/3 "2022-09-14T20:17:54Z")
Let me know if that helps, will keep trying to figure out how to fix it, right now I just can’t login, like there’s a column missing in the users table ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [September 15, 2022, 12:28pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/4 "2022-09-15T12:28:29Z")
I have now install Ubuntu as a new install and re install Dolibarr v16 this have solved problem for me it is running like before ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 15, 2022, 3:57pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/5 "2022-09-15T15:57:52Z")
Does this fix the DB but don’t lose the actuall data? ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 15, 2022, 4:17pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/6 "2022-09-15T16:17:28Z")
I just tried a fresh install and got another errors on the table, I think I wll try creating a complete new DB ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 15, 2022, 4:26pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/7 "2022-09-15T16:26:28Z")
I got this error: Create foreign keys and indexes for table llx\_element\_categorie.key Request 653 : ALTER TABLE llxdo\_element\_categorie ADD CONSTRAINT fk\_element\_categorie\_fk\_categorie FOREIGN KEY (fk\_categorie) REFERENCES llxdo\_fk\_categorie(rowid) SQL Error DB\_ERROR\_CANNOT\_ADD\_FOREIGN\_KEY\_CONSTRAINT Cannot add foreign key constraint ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/8/8df5179717a9fd1f38165e51791b73ebf695b84c.png) ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [September 15, 2022, 5:37pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/8 "2022-09-15T17:37:28Z")
i have always a backup from before upgrade and i normal try upgrade my test server and then i know when i install my backup and file backup from main server on test server and upgrade works i will always have the chance to go back. I can see it mysql you have install that one have had problems with on ubuntu 22.04 so i use mariaDB instead ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 22, 2022, 6:40pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/9 "2022-09-22T18:40:44Z")
Just reinstalled 15.0.3 version and replaced DB and got this error when trying to login Unknown column ‘u.note’ in ‘field list’ Dont know what that mean or how to fix it, please help, need to get this back online ASAP ---
**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:** [September 22, 2022, 7:09pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/10 "2022-09-22T19:09:13Z")
Hello, > [@ibustamanter](#): > > Unknown column ‘u.note’ in ‘field list’ 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. ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 22, 2022, 7:30pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/11 "2022-09-22T19:30:35Z")
I just wanted to update to the newer version but I messed it up, now I have a backed up database that has a user table with a column note\_private and my system is looking for a note column. If I change the column name will fix this? or there’s a lot other column names that has been changed? Or, how can I change my backed database V17 to V15 so the system can read all of this info (after that I will try to update to the newer Dolibarr version again) UPDATE: Just renamed the note\_private column with note and is working ok, now I would like to update to the newer version but i am scared lol ---
**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:** [September 22, 2022, 7:47pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/12 "2022-09-22T19:47:38Z")
Hello, Before doing any update/upgrade : BACKUP is mandatory ! If you do not have a database backup before the upgrade, I would recommend you to : 1. install V16 program 2. Revert the database changes that has been done by V17 : [dolibarr/16.0.0-17.0.0.sql at develop · Dolibarr/dolibarr · GitHub](https://github.com/Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/migration/16.0.0-17.0.0.sql) V17 is not stable at all, so should not be used. ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 22, 2022, 7:54pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/13 "2022-09-22T19:54:18Z")
my backed up database is already on v17, is there a way to downgrade to v16? ---
**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:** [September 22, 2022, 8:02pm UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/14 "2022-09-22T20:02:27Z")
The only way to revert to V16 is to revert the changes made by this script : [dolibarr/16.0.0-17.0.0.sql at develop · Dolibarr/dolibarr · GitHub](https://github.com/Dolibarr/dolibarr/blob/develop/htdocs/install/mysql/migration/16.0.0-17.0.0.sql) ---
**Author:** ![ibustamanter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ibustamanter/32/5575_2.png) [@ibustamanter](https://www.dolibarr.org/forum/u/ibustamanter)\ **Post date:** [September 23, 2022, 3:50am UTC](https://www.dolibarr.org/forum/t/cant-disable-install-tools-after-upgrade-to-16-updated/22782/15 "2022-09-23T03:50:54Z")
Just went manually over that script and created a new one that reverts all of the changes from that file and looks like it worked ok, the only thing is that when I updated to Dolibarr v16 the top dashboard info is missing, I am not sure this can be repaired since some of the data was deleted when the DB was updated to v17 and I don’t know exactly what table is the one with that data, please let me know if this can be fixed (attached an image from the before and after of the missing data). At least I didn’t lost all of the info from my system ![dolibarr16](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/8/864f72b5911209c9f632301f3baee1a51b09f197.png) ![dolibarr15](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/5/5296cf85d394a5ee0dd7b2759c5d904fecce3c1f.png) .