search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.29k stars 2.74k forks source link

unable to generate PDF #16504

Closed r9guy closed 3 years ago

r9guy commented 3 years ago

when clicking generate pdf, I receive an error.

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: 20210301191736
Dolibarr: 13.0.1 - https://www.dolibarr.org
Level of features: 0
PHP: 7.3.23
Server: Apache
OS: Linux ecbiz224.inmotionhosting.com 3.10.0-962.3.2.lve1.5.31.el7.x86_64 #1 SMP Mon Feb 17 04:30:31 EST 2020 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0

Requested` URL: /compta/facture/card.php?facid=3
Referer: http://erp.replicant-ia.com/compta/facture/card.php?facid=3
Menu manager: eldy_menu.php

Modules/Applications: user, syslog, api, agenda, commande, ecm, facture, fournisseur, societe, service, variants, mailing, gravatar, oauth, propal, expedition, supplier_proposal, comptabilite, incoterm, banque, tax, product, margin, fckeditor, workflow, import, export, multicurrency
Database type manager: mysqli
Latest database access request error: SELECT p.rowid, p.ref, p.label as label, p.fk_product_type, pa.qty as qty, pa.fk_product_fils as id, pa.incdec FROM llx_product as p, llx_product_association as pa WHERE p.rowid = pa.fk_product_fils AND pa.fk_product_pere = AND pa.fk_product_fils !=
Return code for latest database access request error: DB_ERROR_SYNTAX
Information for latest database access request error: 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 'AND pa.fk_product_fils !=' at line 1
eldy commented 3 years ago

Which pdf template do you use ? Did you enabled some external modules ?

r9guy commented 3 years ago

The issue with PDF generation is only in invoice module. Regardless it's sponge or crabe template. I have tested from module manager as well as from issued invoice. No external modules used. FYI the installation is fresh but upgraded from 12.5⇾13.0.1

r9guy commented 3 years ago

the above commit fixed the issue.