# Unknown column 'accountancy\_code\_buy\_intra' in 'field list'

**URL:** <https://www.dolibarr.org/forum/t/unknown-column-accountancy-code-buy-intra-in-field-list/19244>\
**Category:** Developing for Dolibarr\
**Created:** [July 5, 2020, 3:35am UTC](https://www.dolibarr.org/forum/t/unknown-column-accountancy-code-buy-intra-in-field-list/19244 "2020-07-05T03:35:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shaggy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/shaggy/32/2844_2.png) [@Shaggy](https://www.dolibarr.org/forum/u/Shaggy)\
**Post date:** [July 5, 2020, 3:35am UTC](https://www.dolibarr.org/forum/t/unknown-column-accountancy-code-buy-intra-in-field-list/19244/1 "2020-07-05T03:35:37Z")

</div>

Hi All,  
have Just upgraded to 12.0 and now I get this error when using REST API

Dolibarr has detected a technical error.  
This information can be useful for diagnostic purposes (you can set option $dolibarr\_main\_prod to ‘1’ to remove such notices):  
**Date:** 20200705125619  
**Dolibarr:** 12.0.0 - [https://www.dolibarr.org](https://www.dolibarr.org)  
**Level of features:** 0  
**PHP:** 7.3.19  
**Server:** LiteSpeed  
**OS:** Linux s403.s04.hostingplatform.net.au 3.10.0-962.3.2.lve1.5.35.el7.x86\_64 #1 SMP Tue Apr 14 15:56:28 EDT 2020 x86\_64  
**UserAgent:** Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36

**Requested URL:** /doli/product/card.php?id=79253  
**Referer:** [https://ahfcomputing.com.au/doli/product/index.php?mainmenu=products&leftmenu=&idmenu=22](https://ahfcomputing.com.au/doli/product/index.php?mainmenu=products&leftmenu=&idmenu=22)  
**Menu manager:** auguria\_menu.php

**Modules/Applications:** syslog, user, api, tax, comptabilite, export, product, import, commande, ecm, expensereport, facture, fournisseur, printing, societe, service, propal, expedition, ficheinter, workflow, banque, fckeditor  
**Database type manager:** mysqli  
**Latest database access request error:** SELECT rowid, ref, ref\_ext, label, description, url, note as note\_private, customcode, fk\_country, price, price\_ttc, price\_min, price\_min\_ttc, price\_base\_type, cost\_price, default\_vat\_code, tva\_tx, recuperableonly as tva\_npr, localtax1\_tx, localtax2\_tx, localtax1\_type, localtax2\_type, tosell, tobuy, fk\_product\_type, duration, fk\_default\_warehouse, seuil\_stock\_alerte, canvas, net\_measure, net\_measure\_units, weight, weight\_units, length, length\_units, width, width\_units, height, height\_units, surface, surface\_units, volume, volume\_units, barcode, fk\_barcode\_type, finished, accountancy\_code\_buy, accountancy\_code\_buy\_intra, accountancy\_code\_buy\_export, accountancy\_code\_sell, accountancy\_code\_sell\_intra, accountancy\_code\_sell\_export, stock, pmp, datec, tms, import\_key, entity, desiredstock, tobatch, fk\_unit, fk\_price\_expression, price\_autogen FROM llx\_product WHERE rowid = 79253  
**Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD  
**Information for latest database access request error:** Unknown column ‘accountancy\_code\_buy\_intra’ in ‘field list’

Any assistance would be great