Your message dated Sat, 24 Feb 2018 04:28:46 +0000 with message-id <e1eprs2-0004au...@fasolo.debian.org> and subject line Bug#890598: Removed package(s) from unstable has caused the Debian Bug report #862201, regarding dolibarr: Applying absolute discount in proposal fails to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 862201: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=862201 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---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 informationsignature.asc
Description: OpenPGP digital signature
--- End Message ---
--- Begin Message ---Version: 5.0.4+dfsg3-1+rm Dear submitter, as the package dolibarr has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see https://bugs.debian.org/890598 The version of this package that was in Debian prior to this removal can still be found using http://snapshot.debian.org/. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmas...@ftp-master.debian.org. Debian distribution maintenance software pp. Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---