Error when adding a product with price 0 EUR

Using my Dolibarr
1

Hi,

this is the error I get when adding product with price = 0€.

> Fout ontdekt: > Database Type Manager: mysql > Verzoek voor laatste database toegang in fout: UPDATE llx_commandedet SET description=’’,price=‘0’,subprice=‘0’,remise=‘0’,remise_percent=‘0’,tva_tx=‘21’,localtax1_tx=’’,localtax2_tx=’’,qty=‘1’,product_type=‘0’,info_bits=‘0’,total_ht=‘0’,total_tva=‘0’,total_localtax1=‘0’,total_localtax2=‘0’,total_ttc=‘0’,date_start=null,date_end=null WHERE rowid = 162 > Return code for last database access in error: DB_ERROR_1265 > Information for last database access in error: Data truncated for column ‘localtax1_tx’ at row 1 > Message: Data truncated for column ‘localtax1_tx’ at row 1

KR,
Guillaume

2

This is fixed in CVS some time ago

3

I’m using the latest stable version … so it must be another problem ?

4

Can you reproduce pb on demo.dolibarr.org ?

5

I seem to have the problem when I change the price of a product-line to another amount. (customer order, customer invoice, …)
Please I need this sorted out.

> Fout ontdekt: > Database Type Manager: mysql > Verzoek voor laatste database toegang in fout: UPDATE llx_commandedet SET description=‘1560mm RAL9001(70) RAL9001(70) Beige’,price=‘50’,subprice=‘50’,remise=‘0’,remise_percent=‘0’,tva_tx=‘21’,localtax1_tx=’’,localtax2_tx=’’,qty=‘3’,product_type=‘0’,info_bits=‘0’,total_ht=‘150’,total_tva=‘31.5’,total_localtax1=‘0’,total_localtax2=‘0’,total_ttc=‘181.5’,date_start=null,date_end=null WHERE rowid = 13 > Return code for last database access in error: DB_ERROR_1265 > Information for last database access in error: Data truncated for column ‘localtax1_tx’ at row 1 > Message: Data truncated for column ‘localtax1_tx’ at row 1

6

I can not reproduce it in CVS, After v2.9, we detect this error and solved it.

7

so the stable version 2.9 still contains the bug ?

8

the error also appears on the CSV 3.0 version
I think it is a database issue … but what issue ?

Dolibarr heeft een technische fout.
Informatie die kan helpen bij het vaststellen:
Datum: 20110126121548
Dolibarr: 3.1.0-alpha
Niveau van de functies: 0
PHP: 5.3.4
Server: Microsoft-IIS/7.0

Aangevraagd Url:
Referer: http://tunal.fxit.be/commande/fiche.php?id=7&action=editline&lineid=14
Menu manager: eldy_backoffice.php

Database Type Manager: mysql
Verzoek voor laatste database toegang in fout: UPDATE llx_commandedet SET description=‘1650mm RAL9001(70) RAL9001(70) Beige’,price=‘90’,subprice=‘90’,remise=‘0’,remise_percent=’’,tva_tx=‘21’,localtax1_tx=’’,localtax2_tx=’’,qty=‘3’,info_bits=‘0’,total_ht=‘270’,total_tva=‘56.7’,total_localtax1=‘0’,total_localtax2=‘0’,total_ttc=‘326.7’,date_start=null,date_end=null WHERE rowid = 14
Return code for last database access in error: DB_ERROR_1265
Information for last database access in error: Data truncated for column ‘remise_percent’ at row 1

Message: Data truncated for column ‘remise_percent’ at row 1
PHP Notice: Undefined index: DOCUMENT_ROOT in C:\inetpub\wwwroot\tunal\htdocs\main.inc.php on line 120

9

I have solved the problem myself by changing the mode of the MySQL database to 4.0.
I was using the latest stable version of mySQL. :side:

10

Fixed in CVS today.

11

I am having this problem too. I just installed and starting using dolibarr but when I change the VAT for an item and try to save, I get this error.

I see eldy says “Fixed in CVS today.” but I have no clue what than means or even how to fix the issue.

I also see that you can change the MySQL mode to fix, but how?

Thanks for the product and the help!