Bug was fixed in official version 4.0.6. An upstream must be done to debian package
2017-05-09 20:27 GMT+02:00 Maximilian Stein <m...@steiny.biz>: > Package: dolibarr > Version: 4.0.2+dfsg4-2 > Severity: normal > > Dear Maintainer, > > After having added a customer in Dolibarr, I gave this customer an > absolute discount. Then, I tried to create a proposal, however, applying > the discount fails with the error message: > > "You have an error in your SQL syntax; check the manual that corresponds > to your MariaDB server version for the right syntax to use near ' 0)' at > line 1 sql=INSERT INTO llx_propaldet (fk_propal, fk_parent_line, label, > description, fk_product, product_type, fk_remise_except, qty, tva_tx, > localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, subprice, > remise_percent, info_bits, total_ht, total_tva, total_localtax1, > total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, > special_code, rang, fk_unit, date_start, date_end, fk_multicurrency, > multicurrency_code, multicurrency_subprice, multicurrency_total_ht, > multicurrency_total_tva, multicurrency_total_ttc) VALUES (1, null, null, > 'test discount', null, '0', '1', 1, 19, 0, 0, '0', '0', -100, 0, '2', > -100, -19, 0, 0, -119, null, '0', 0, -1, NULL, null, null, null, '', 0, > 0, , 0)" > > Apparently, the SQL statement is invalid. I tried to manually execute > the statement through the mysql tool and added a value of '0' at the > last but one position in the value vector. This has actually worked, so > the discount is now correctly applied in the offer. > > I then tried to find a quickfix for this problem. The SQL statement is > crafted in the file > "/usr/share/dolibarr/htdocs/comm/propal/class/propal.class.php" on lines > 3252 and following. The class member "multicurrency_total_tva" seems to > be uninitialized, so I just changed line 3098 to: > > var $multicurrency_total_tva = 0; > > As I am not using multiple currency currently, this seems to be an > adequate fix for me now. > > Best, > Maximilian > > -- System Information: > Debian Release: 8.8 > APT prefers stable > APT policy: (900, 'stable'), (800, 'testing'), (500, 'stable-updates') > Architecture: amd64 (x86_64) > > Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores) > Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) > Shell: /bin/sh linked to /bin/dash > Init: systemd (via /run/systemd/system) > > Versions of packages dolibarr depends on: > ii fonts-dejavu-core 2.34-1 > ii javascript-common 11 > ii libapache2-mod-php 1:7.0+49 > ii libapache2-mod-php7.0 [libapache2-mod-php] 7.0.16-3 > ii libjs-jquery 3.1.1-2 > ii libjs-jquery-cookie 11-3 > ii libjs-jquery-flot 0.8.2+dfsg-1 > ii libjs-jquery-ui 1.10.1+dfsg-1 > ii libnusoap-php 0.9.5-3 > ii libphp-adodb 5.20.9-1 > ii php-curl 1:7.0+49 > ii php-gd 1:7.0+49 > ii php-ldap 1:7.0+49 > ii php-pclzip 2.8.2-4 > ii php-tcpdf 6.0.093+dfsg-1 > ii php7.0-cli [php-cli] 7.0.16-3 > ii php7.0-curl [php-curl] 7.0.16-3 > ii php7.0-gd [php-gd] 7.0.16-3 > ii php7.0-ldap [php-ldap] 7.0.16-3 > ii php7.0-mysql [php-mysqli] 7.0.16-3 > ii xdg-utils 1.1.0~rc1+git20111210-7.4 > > Versions of packages dolibarr recommends: > ii apache2 [httpd] 2.4.25-3 > ii default-mysql-client 1.0.2 > ii default-mysql-server 1.0.2 > > Versions of packages dolibarr suggests: > pn php-geoip <none> > ii w3m [www-browser] 0.5.3-19+deb8u1 > > -- no debconf information > > > -- EMail: e...@destailleur.fr Web: http://www.destailleur.fr ------------------------------------------------------------------------------------ Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/ Facebook: https://www.facebook.com/Destailleur.Laurent Twitter: http://www.twitter.com/eldy10 ------------------------------------------------------------------------------------ * Dolibarr (Project leader): https://www.dolibarr.org (make a donation for Dolibarr project via Paypal: cont...@destailleur.fr) * AWStats (Author) : http://awstats.sourceforge.net (make a donation for AWStats project via Paypal: cont...@destailleur.fr) * AWBot (Author) : http://awbot.sourceforge.net * CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
