crater-invoice / crater

Open Source Invoicing Solution for Individuals & Businesses
https://craterapp.com
GNU Affero General Public License v3.0
7.85k stars 1.57k forks source link

Any PDF is always blank with PostgreSQL DBMS #842

Open Procsiab opened 2 years ago

Procsiab commented 2 years ago

Describe the bug Regardless of the operation that also produces a PDF file, the product is a blank PDF. This happens without any error that I could track down (no Laravel log errors, no errors in the browser console, no errors in the reverse proxy log or the app log). I am running with debug log verbosity, and APP_DEBUG set to true.

Expected behavior The PDF file has some content in it, or some error is shown if it cannot be populated.

Screenshots Crater blank estimate PDF

Please complete the following information:

Environment info

Procsiab commented 2 years ago

Update: PostgreSQL vs MariaDB

I have a follow up to this issue: using the docker.io/amd64/mariadb:10.7.3-focal container image for the DB service, and installing the required dependency in my Alpine-based container image (mariadb-client from the package manager and pdo_mysql with the command docker-php-ext-install), I was not able to reproduce this issue anymore. I believe that the culprit is the DBMS of choice, and that PostgreSQL is causing issues with the PDF generation. If you have any time and this has some priority I'm willing to help diagnose this issue, but I am not familiar with the application's internals and I don;t know where to start looking for something.

alexandru0-dev commented 1 year ago

I have the same issue