-->
Welcome, Guest
Username: Password: Remember me

TOPIC: DB ERROR 1264 when VAT on product is 4 digits

DB ERROR 1264 when VAT on product is 4 digits 2 months 3 weeks ago #36747

  • Texaco
  • Texaco's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 1
  • Karma: 0
I am using the Indian GST system for taxation in dolibarr. I am able to add products and select different GST Rates (C+S-18, C+S-28, I-18, I-28) as required, while creating a Purchase Order. Sales Tax is displayed as 999/999% (C+S-18). But when the value of the Sales Tax in any row goes above 999 I get the error below. Any idea how to resolve?

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: 20190327163944
Dolibarr: 8.0.3
Level of features: 0
PHP: 5.6.40
Server: Apache
OS:
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:66.0) Gecko/20100101 Firefox/66.0

Requested URL: /dolibarr/fourn/commande/card.php?id=17
Referer: www.a.com/dolibarr/fourn/commande/card.p...n=editline&lineid=38
Menu manager: eldy_menu.php

Database type manager: mysqli
Latest database access request error: UPDATE llxy7_commande_fournisseurdet SET description='', ref='', subprice='8960', remise_percent='0', vat_src_code = 'C+S-18', tva_tx='0', localtax1_tx='2419.2', localtax2_tx='2419.2', localtax1_type='1', localtax2_type='1', qty='3', date_start=null, date_end=null, info_bits='0', total_ht='26880', total_tva='0', total_localtax1='2419.2', total_localtax2='2419.2', total_ttc='31718.4', product_type=0, special_code=0, fk_unit=null, multicurrency_subprice=8960, multicurrency_total_ht=26880, multicurrency_total_tva=0, multicurrency_total_ttc=31718.4 WHERE rowid = 38
Return code for latest database access request error: DB_ERROR_1264
Information for latest database access request error: Out of range value for column 'localtax1_tx' at row 1

Message: Out of range value for column 'localtax1_tx' at row 1
The administrator has disabled public write access.

DB ERROR 1264 when VAT on product is 4 digits 2 months 3 weeks ago #36748

  • eldy
  • eldy's Avatar
  • OFFLINE
  • Administrateur
  • Open Source ERP CRM expert.
  • Posts: 1706
  • Thank you received: 119
  • Karma: 181
The problem here is that the application try to store the amount of VAT (2419.2) instead of the vat rate (9) into field localtax1_tx.
Can you try to upgrade with 9.0.1 or at least 8.0.4 ?
The administrator has disabled public write access.
Time to create page: 0.109 seconds