-->
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 5 months 3 weeks ago #36747

  • Texaco
  • Texaco's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 2
  • 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 5 months 3 weeks ago #36748

  • eldy
  • eldy's Avatar
  • OFFLINE
  • Administrateur
  • Open Source ERP CRM expert.
  • Posts: 1727
  • Thank you received: 129
  • Karma: 183
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.

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

  • Texaco
  • Texaco's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 2
  • Karma: 0
Since you requested upgrading the Dolibarr Version, I thought I should first create a backup and then go for the upgrade. Backup from the dolibarr link was not working as it was showing some php error. But then I logged in to my host services and took backup of the database. It took me some time to figure all this out. And now that I am on new Dolibarr Version, I do not see the above error, but I have another issue. I just created a new vendor and a new product and selected VAT rate as 18% by adding a Buying Price. Finally when I create a Purchase Order and select the new Product that I just created, I do not see the correct Sales Tax rate. I see options for 0, 4, 6 as the options in the dropdown list for the Sales Tax rates.
The administrator has disabled public write access.
Time to create page: 0.064 seconds