When adding line items to an order, I am getting the following error: I am using 10.0.7
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: 20200405060636
Dolibarr: 10.0.7
Level of features: 0
PHP: 5.5.12
Server: Apache/2.4.9 (Win32) PHP/5.5.12
OS: Windows NT FSERVER 6.2 build 9200 (Windows Server 2012) i586
UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36
Requested URL: /dolibarr/commande/card.php?id=10
Referer: http://localhost/dolibarr/commande/card.php?id=10
Menu manager: eldy_menu.php
Modules/Applications: user, website, fckeditor, factory, fournisseur, societe, product, stock, bom, productbatch, expedition, commande, variants, multicurrency, mailing, paypal, stripe, facture, tax, salaries, loan, margin, propal, ecm, categorie, import, export
Database type manager: mysqli
Latest database access request error: SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=697:720:Hampshire AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
Return code for latest database access request error: DB_ERROR_SYNTAX
Information for latest database access request error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:720:Hampshire AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.cod’ at line 1
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: 20200405060636
Dolibarr: 10.0.7
Level of features: 0
PHP: 5.5.12
Server: Apache/2.4.9 (Win32) PHP/5.5.12
OS: Windows NT FSERVER 6.2 build 9200 (Windows Server 2012) i586
UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36
Requested URL: /dolibarr/commande/card.php?id=10
Referer: http://localhost/dolibarr/commande/card.php?id=10
Menu manager: eldy_menu.php
Modules/Applications: user, website, fckeditor, factory, fournisseur, societe, product, stock, bom, productbatch, expedition, commande, variants, multicurrency, mailing, paypal, stripe, facture, tax, salaries, loan, margin, propal, ecm, categorie, import, export
Database type manager: mysqli
Latest database access request error: SELECT d.rowid as id, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.code_region as region_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and d.rowid=697:720:Hampshire AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
Return code for latest database access request error: DB_ERROR_SYNTAX
Information for latest database access request error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:720:Hampshire AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.cod’ at line 1
