Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

unable to generate PDF #16504

Closed
r9guy opened this issue Mar 1, 2021 · 3 comments
Closed

unable to generate PDF #16504

r9guy opened this issue Mar 1, 2021 · 3 comments
Labels
Bug This is a bug (something does not work as expected)

Comments

@r9guy
Copy link

r9guy commented Mar 1, 2021

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
@r9guy r9guy added the Bug This is a bug (something does not work as expected) label Mar 1, 2021
@eldy
Copy link
Member

eldy commented Mar 1, 2021

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

eldy added a commit that referenced this issue Mar 1, 2021
@r9guy
Copy link
Author

r9guy commented Mar 2, 2021

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
Copy link
Author

r9guy commented Mar 2, 2021

the above commit fixed the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug This is a bug (something does not work as expected)
Projects
None yet
Development

No branches or pull requests

3 participants