# DB Field Not found Error - V 13.0.2 **URL:** \ **Category:** Using my Dolibarr\ **Tags:** Windows\ **Created:** [April 3, 2021, 3:08pm UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500 "2021-04-03T15:08:39Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![RiseValInfotech](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/41988e/32.png) [@RiseValInfotech](https://www.dolibarr.org/forum/u/RiseValInfotech)\ **Post date:** [April 3, 2021, 3:08pm UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500/1 "2021-04-03T15:08:39Z")
Hi, I am getting this error when a user level login clicks on “Third-Party \> list” in the left menu. ![Untitled](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/4/4f3890bb45b715416e36dca153cc1866c83c7c31.jpeg) Can you please help …? ---
**Author:** ![Dolisupport.nl](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/dolisupport.nl/32/3564_2.png) [@Dolisupport.nl](https://www.dolibarr.org/forum/u/Dolisupport.nl)\ **Post date:** [April 4, 2021, 2:17pm UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500/2 "2021-04-04T14:17:22Z")
Maybe a bug of 13.0.2, can you maybe change ORDER BY statut → ORDER BY status. Hopefully is this a quick fix for now. ---
**Author:** ![RiseValInfotech](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/41988e/32.png) [@RiseValInfotech](https://www.dolibarr.org/forum/u/RiseValInfotech)\ **Post date:** [April 7, 2021, 7:52am UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500/3 "2021-04-07T07:52:16Z")
Hi, Thank you for the answer. Can you please help where to change the string (file / directory) thanks again ---
**Author:** ![RiseValInfotech](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/41988e/32.png) [@RiseValInfotech](https://www.dolibarr.org/forum/u/RiseValInfotech)\ **Post date:** [April 7, 2021, 8:12am UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500/4 "2021-04-07T08:12:01Z")
Hi Dolisupport, I have changed the ORDER BY statut to ORDER BY status in the line 477 of file htdocs/core/class/html.formother.class.php and it seem to work fine. Thank you. Also, I am trying to create an AUDITOR user who can just read all transactions for auditing purpose. But when logged in using the AUDITOR username and password Dolibarr is listing only his name in the list of third parties and not all the users. I have given all read rights and also Extend access to all third parties (not only third parties for which that user is a sale representative). Not effective for external users (always limited to themselves for proposals, orders, invoices, contracts, etc.). But its not effective. How can we achieve an auditor can see all of the users, thirdparty memebers and transactions for READ ONLY. thank you ---
**Author:** ![Dolisupport.nl](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/dolisupport.nl/32/3564_2.png) [@Dolisupport.nl](https://www.dolibarr.org/forum/u/Dolisupport.nl)\ **Post date:** [April 23, 2021, 12:01am UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500/5 "2021-04-23T00:01:05Z")
I suppose you have fixed this already, in post: [How to create an User Role for External Auditors and Internal Auditors](https://www.dolibarr.org/forum/t/how-to-create-an-user-role-for-external-auditors-and-internal-auditors/20522) kind regards, Hans ---
**Author:** ![RiseValInfotech](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/41988e/32.png) [@RiseValInfotech](https://www.dolibarr.org/forum/u/RiseValInfotech)\ **Post date:** [April 23, 2021, 3:15pm UTC](https://www.dolibarr.org/forum/t/db-field-not-found-error-v-13-0-2/20500/6 "2021-04-23T15:15:44Z")
Hi Dolisupport, Yes, this got fixed by creating an internal user and mapping to the third party auditor. thanks a ton. regards, yesbee