# Error in Warehouses after update from 15 to 17.0.2 **URL:** \ **Category:** Using my Dolibarr\ **Tags:** Linux\ **Created:** [July 23, 2023, 1:40pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041 "2023-07-23T13:40:39Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 23, 2023, 1:40pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/1 "2023-07-23T13:40:39Z")
Hello after updating to ver 17 from ver 15 and when select Warehouse i found below Error: **Latest database access request error:** SELECT t.rowid, t.ref,t.lieu FROM llx\_entrepot as t WHERE 1=1 AND t.entity IN (1) AND ((status = 1 AND entity IN (1))) ORDER BY t.ref ASC, t.lieu ASC **Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD **Information for latest database access request error:** Unknown column ‘status’ in ‘where clause’ ---
**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:** [July 23, 2023, 8:52pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/2 "2023-07-23T20:52:12Z")
> [@New Warehouse page shows blank](https://www.dolibarr.org/forum/t/new-warehouse-page-shows-blank/23972): > > I cant add a new warehouse, it shows only the ref. line, same for stock movement. Got an error message, afterwards and i don’t understand it. Pls help ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 24, 2023, 10:10am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/3 "2023-07-24T10:10:36Z")
@ksar, Hi, This issue is resolved. Thanks ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 24, 2023, 10:41am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/4 "2023-07-24T10:41:07Z")
@Absmachin could you help in my problem? thanks ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 24, 2023, 10:48am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/5 "2023-07-24T10:48:39Z")
> [@Ghonz](#): > > **Latest database access request error:** SELECT t.rowid, t.ref,t.lieu FROM llx\_entrepot as t WHERE 1=1 AND t.entity IN (1) AND ((status = 1 AND entity IN (1))) ORDER BY t.ref ASC, t.lieu ASC > **Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD > **Information for latest database access request error:** Unknown column ‘status’ in ‘where clause’ You have to change the status = 1 to **statut** =1 from the server Thank you ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 24, 2023, 11:16am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/6 "2023-07-24T11:16:48Z")
do you mean $dolibarr\_main\_prod=‘0’ i case yes there is still error message without above details however all warehouses appears and the stock is ok but this error message need to be fixed Thanks ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 24, 2023, 11:47am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/7 "2023-07-24T11:47:40Z")
> [@Ghonz](#): > > llx\_entrepot You have to locate this file(entrepot.php) to correct the status to **statut** i was sent the path, let me see if i can get it ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 24, 2023, 11:50am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/8 "2023-07-24T11:50:29Z")
@Ghonz You need to open `/product/stock/class/entrepot.class.php` in your dolibarr directory Then locate the line 130, change the `status` by `statut` . ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 24, 2023, 2:49pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/9 "2023-07-24T14:49:12Z")
@Absmachin Solved Thank you very much ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 24, 2023, 2:55pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/10 "2023-07-24T14:55:52Z")
@Ghonz , U welcome, glad to have helped someone too 😀 ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 24, 2023, 7:51pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/11 "2023-07-24T19:51:19Z")
@Absmachin Hello Again i have several dolibarr installations one of them no show regenerate user password for users even after upgrading to latest version, i attached 2 screed shot for difference between 2 installations could you help? Thanks ![Screenshot 2023-07-24 at 10.49.07 PM](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/0/014e1463b2c424f4d53a29ba6fa47f728200e722.png) ![Screenshot 2023-07-24 at 10.30.45 PM](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/5/5d17be161c9a8b1781bd0a88b68bac7bf7ffc881.png) ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 24, 2023, 8:01pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/12 "2023-07-24T20:01:41Z")
@Ghonz , Weel from what i can deduce, it seems the 2 users have different user levels. The second seems to be an admin user or has right to create and modify users while the 1st doesnt have that level of access right - I maybe wrong. Check user permissions for both installations side by side and you should see where the difference is/ Hope this helps ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 24, 2023, 8:07pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/13 "2023-07-24T20:07:13Z")
no both users are admin you may noticed that delete is not active for the first because its the account used to login so cannot delete, dont worry about that the problem in regenerate password and regenerate and send password both bottoms not visible at all to any admin its very strange ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 24, 2023, 8:20pm UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/14 "2023-07-24T20:20:40Z")
@Absmachin you will notice in attached that in the installation having this problem you can read advanced permission and in the other good one less lines and there is no advanced permission module advanced permission i bought it from dolistore but i found it case some wrong permissions so i disabled it and delete it, when i find out that there is no regenerate password installed advanced permission module again but nothing changed. i need the reset permissions to not show advanced permission but dont know how ![Screenshot 2023-07-24 at 11.16.26 PM](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/c/cb4b23e636c1a66d2bdfd35b6efd7b966f268202.png) ![Screenshot 2023-07-24 at 11.16.02 PM](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/e/eb3225b9dda4e4bad2972396f9c0eaa8d58c7632.jpeg) ---
**Author:** ![Absmachin](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/3d9bf3/32.png) [@Absmachin](https://www.dolibarr.org/forum/u/Absmachin)\ **Post date:** [July 25, 2023, 11:05am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/15 "2023-07-25T11:05:38Z")
@Ghonz , Can u repeat the installation for the 1st? I suspect permission issue still for user ---
**Author:** ![Ghonz](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/9dc877/32.png) [@Ghonz](https://www.dolibarr.org/forum/u/Ghonz)\ **Post date:** [July 25, 2023, 11:31am UTC](https://www.dolibarr.org/forum/t/error-in-warehouses-after-update-from-15-to-17-0-2/24041/16 "2023-07-25T11:31:14Z")
no i have all available permission i am the installer of the system and admin