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 :
> 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-jquery3.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-adodb5.20.9-1
> ii php-curl1:7.0+49
> ii php-gd 1:7.0+49
> ii php-ldap1: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
> 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