Not creating pdfs after updates

AartJansen

Just get an error pop up during pdf generation
500: Internal Server Error • Unable to generate the raw PDF

Jan 08 08:45:00 2025-01-07 19:45:00 Running [queue-size-job] .................. 11.89ms DONE
Jan 08 08:45:00 2025-01-07 19:45:00 Running [Callback] ......................... 6.49ms DONE
Jan 08 08:45:00 2025-01-07T19:45:00Z
Jan 08 08:45:01 2025-01-07 19:45:01 App\Jobs\Ninja\QueueSize ....................... RUNNING
Jan 08 08:45:01 2025-01-07 19:45:01 App\Jobs\Ninja\QueueSize ................... 4.72ms DONE
Jan 08 08:45:10 172.18.0.1 - - [07/Jan/2025:19:45:10 +0000] "GET / HTTP/1.1" 302 2055 "-" "Mozilla (CloudronHealth)"
Jan 08 08:45:13 172.18.0.1 - - [07/Jan/2025:19:45:13 +0000] "POST /api/v1/refresh?&first_load=true&include_static=true&einvoice=true HTTP/1.1" 200 1458783 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:14 172.18.0.1 - - [07/Jan/2025:19:45:14 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:14 172.18.0.1 - - [07/Jan/2025:19:45:14 +0000] "GET /api/v1/clients?per_page=5000&page=1&t=1736279114993 HTTP/1.1" 200 876154 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:14 172.18.0.1 - - [07/Jan/2025:19:45:14 +0000] "GET /api/v1/products?per_page=5000&page=1&t=1736279115402 HTTP/1.1" 200 93828 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:15 172.18.0.1 - - [07/Jan/2025:19:45:14 +0000] "GET /api/v1/invoices?per_page=5000&page=1&created_at=1641671115&filter_deleted_clients=true HTTP/1.1" 200 2182259 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:15 172.18.0.1 - - [07/Jan/2025:19:45:15 +0000] "GET /api/v1/recurring_invoices?per_page=5000&page=1&filter_deleted_clients=true&t=1736279116193 HTTP/1.1" 200 5083 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:15 172.18.0.1 - - [07/Jan/2025:19:45:15 +0000] "GET /api/v1/payments?per_page=5000&page=1&created_at=1641671116&filter_deleted_clients=true HTTP/1.1" 200 638748 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:16 172.18.0.1 - - [07/Jan/2025:19:45:16 +0000] "GET /api/v1/quotes?per_page=5000&page=1&created_at=1641671117&filter_deleted_clients=true HTTP/1.1" 200 147751 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:16 172.18.0.1 - - [07/Jan/2025:19:45:16 +0000] "GET /api/v1/credits?created_at=1641671117&filter_deleted_clients=true&per_page=999999 HTTP/1.1" 200 1019 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:16 172.18.0.1 - - [07/Jan/2025:19:45:16 +0000] "GET /api/v1/projects?&filter_deleted_clients=true&per_page=999999&t=1736279117250 HTTP/1.1" 200 1019 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:16 172.18.0.1 - - [07/Jan/2025:19:45:16 +0000] "GET /api/v1/tasks?per_page=5000&page=1&created_at=1641671117 HTTP/1.1" 200 1019 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:16 172.18.0.1 - - [07/Jan/2025:19:45:16 +0000] "GET /api/v1/vendors?per_page=5000&page=1&t=1736279117448 HTTP/1.1" 200 326228 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:16 172.18.0.1 - - [07/Jan/2025:19:45:16 +0000] "GET /api/v1/purchase_orders?per_page=5000&page=1&created_at=1641671118 HTTP/1.1" 200 1019 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:17 172.18.0.1 - - [07/Jan/2025:19:45:17 +0000] "GET /api/v1/expenses?per_page=5000&page=1&created_at=1641671118 HTTP/1.1" 200 9279 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:17 172.18.0.1 - - [07/Jan/2025:19:45:17 +0000] "GET /api/v1/recurring_expenses?&per_page=999999&t=1736279118057 HTTP/1.1" 200 1019 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:17 172.18.0.1 - - [07/Jan/2025:19:45:17 +0000] "GET /api/v1/bank_transactions?per_page=5000&page=1&created_at=1641671118 HTTP/1.1" 200 7801 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:19 172.18.0.1 - - [07/Jan/2025:19:45:19 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:20 172.18.0.1 - - [07/Jan/2025:19:45:20 +0000] "GET / HTTP/1.1" 302 2055 "-" "Mozilla (CloudronHealth)"
Jan 08 08:45:20 2025-01-07 19:45:20,157 INFO reaped unknown pid 134 (exit status 0)
Jan 08 08:45:20 2025-01-07 19:45:20,157 INFO reaped unknown pid 136 (exit status 0)
Jan 08 08:45:20 172.18.0.1 - - [07/Jan/2025:19:45:18 +0000] "POST /api/v1/live_preview?entity=invoice&entity_id=Opnell5eKB HTTP/1.1" 500 812 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:20 172.18.0.1 - - [07/Jan/2025:19:45:20 +0000] "GET /api/v1/clients/kQBeXWdyK8?include=gateway_tokens,activities,ledger,system_logs,documents&per_page=999999&t=1736279121334 HTTP/1.1" 200 71545 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:20 172.18.0.1 - - [07/Jan/2025:19:45:20 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:20 172.18.0.1 - - [07/Jan/2025:19:45:20 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:20 172.18.0.1 - - [07/Jan/2025:19:45:20 +0000] "POST /api/v1/templates? HTTP/1.1" 200 9764 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:21 172.18.0.1 - - [07/Jan/2025:19:45:20 +0000] "GET /client/invoice/qC5VZY8LtLI8vBEPdJfLiWQ72yW0nMRj/download?t=1736279121337 HTTP/1.1" 500 1744 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:21 2025-01-07 19:45:21,632 INFO reaped unknown pid 144 (exit status 0)
Jan 08 08:45:21 2025-01-07 19:45:21,632 INFO reaped unknown pid 146 (exit status 0)
Jan 08 08:45:30 172.18.0.1 - - [07/Jan/2025:19:45:30 +0000] "GET / HTTP/1.1" 302 2055 "-" "Mozilla (CloudronHealth)"
Jan 08 08:45:32 172.18.0.1 - - [07/Jan/2025:19:45:32 +0000] "POST /api/v1/emails? HTTP/1.1" 200 5484 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:32 172.18.0.1 - - [07/Jan/2025:19:45:32 +0000] "POST /api/v1/refresh?current_company=true&updated_at=1736277618&first_load=true HTTP/1.1" 200 370120 "-" "Dart/3.3 (dart:io)"
Jan 08 08:45:34 2025-01-07 19:45:34 Laravel\Scout\Jobs\MakeSearchable .............. RUNNING
Jan 08 08:45:34 2025-01-07 19:45:34 Laravel\Scout\Jobs\MakeSearchable ......... 34.61ms DONE
Jan 08 08:45:34 2025-01-07 19:45:34 App\Services\Email\Email ....................... RUNNING
Jan 08 08:45:34 172.18.0.1 - - [07/Jan/2025:19:45:34 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:34 172.18.0.1 - - [07/Jan/2025:19:45:34 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:35 2025-01-07 19:45:35 App\Services\Email\Email2025-01-07 19:45:35,742 INFO reaped unknown pid 153 (exit status 0)
Jan 08 08:45:35 2025-01-07 19:45:35,742 INFO reaped unknown pid 155 (exit status 0)
Jan 08 08:45:35 ....................... 1s FAIL
Jan 08 08:45:35 2025-01-07 19:45:35 Laravel\Scout\Jobs\MakeSearchable .............. RUNNING
Jan 08 08:45:35 2025-01-07 19:45:35 Laravel\Scout\Jobs\MakeSearchable .......... 2.71ms DONE
Jan 08 08:45:36 12:M 07 Jan 2025 19:45:36.082 * 10 changes in 300 seconds. Saving...
Jan 08 08:45:36 12:M 07 Jan 2025 19:45:36.082 * Background saving started by pid 4541
Jan 08 08:45:36 4541:C 07 Jan 2025 19:45:36.088 * DB saved on disk
Jan 08 08:45:36 4541:C 07 Jan 2025 19:45:36.088 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB
Jan 08 08:45:36 12:M 07 Jan 2025 19:45:36.183 * Background saving terminated with success
Jan 08 08:45:38 2025-01-07 19:45:38 App\Jobs\Ledger\ClientLedgerBalanceUpdate ...... RUNNING
Jan 08 08:45:38 2025-01-07 19:45:38 App\Jobs\Ledger\ClientLedgerBalanceUpdate . 14.51ms DONE
Jan 08 08:45:38 2025-01-07 19:45:38 App\Listeners\Invoice\InvoiceEmailActivity ..... RUNNING
Jan 08 08:45:38 2025-01-07 19:45:38 App\Listeners\Invoice\InvoiceEmailActivity 13.20ms DONE
Jan 08 08:45:40 172.18.0.1 - - [07/Jan/2025:19:45:40 +0000] "GET / HTTP/1.1" 302 2055 "-" "Mozilla (CloudronHealth)"
Jan 08 08:45:44 2025-01-07 19:45:44 App\Listeners\Invoice\UpdateInvoiceActivity .... RUNNING
Jan 08 08:45:45 172.18.0.1 - - [07/Jan/2025:19:45:45 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:45 2025-01-07 19:45:45 App\Listeners\Invoice\UpdateInvoiceActivity 496.66ms DONE
Jan 08 08:45:45 2025-01-07 19:45:45 App\Listeners\Invoice\InvoiceEmailedNotification RUNNING
Jan 08 08:45:45 2025-01-07 19:45:45 App\Listeners\Invoice\InvoiceEmailedNotification 11.18ms DONE
Jan 08 08:45:48 2025-01-07 19:45:48 App\Services\Email\Email ....................... RUNNING
Jan 08 08:45:48 172.18.0.1 - - [07/Jan/2025:19:45:48 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:48 172.18.0.1 - - [07/Jan/2025:19:45:48 +0000] "GET /storage/wy7367YjZKJ1MeibNz7hWcqVUuzfvlYV/RE1ZVEX72zOe7y3YneTYcG4Y9oae9HMlDUOZg95d.png HTTP/1.1" 200 9907 "-" "-"
Jan 08 08:45:49 2025-01-07 19:45:49 App\Services\Email\Email2025-01-07 19:45:49,773 INFO reaped unknown pid 164 (exit status 0)
Jan 08 08:45:49 2025-01-07 19:45:49,773 INFO reaped unknown pid 162 (exit status 0)
Jan 08 08:45:49 ....................... 1s FAIL

girish

Thanks for reporting. I probably broke it with https://git.cloudron.io/packages/invoiceninja-app/-/commit/ceb2f0e238c1306e7cbf18021d2601065e38d2ab . Investigating

girish

It seems it broke upstream . Several reports - https://github.com/invoiceninja/invoiceninja/discussions/10466 https://github.com/invoiceninja/invoiceninja/issues/10467 https://github.com/invoiceninja/dockerfiles/issues/683 etc

AartJansen

As a work around I changed a line in the env file to:
PHANTOMJS_PDF_GENERATION=true

Now my pdf's generate and invoices email sucessfully ( the non-generation also stopped email sending).

girish

I have a fix at https://git.cloudron.io/packages/invoiceninja-app/-/merge_requests/40

humptydumpty

voiced my concern upstream and linked Girish's merge request for visibility

humptydumpty

@AartJansen Is the template design all messed up for you?

I'm using the clean template, and all the fields are squished to the left in the actual PDF and in the preview.

girish

@humptydumpty I think there are reports like https://github.com/invoiceninja/invoiceninja/issues/10478

humptydumpty

@girish I checked my PDF's (I send a copy to myself) and it started with 5.11.11. I'm not sure what they're doing upstream, but PDF issues keep recurring every few updates ‍️

humptydumpty

LOL so I'm using a Logitech MX Mini keyboard and the F7 button also doubles as an emoji window/tool thing. Nodebb doesn't have a male facepalm icon so it tossed a female facepalm and the male symbol

AartJansen

@humptydumpty No they look the same with either generated for me. (thankfully)

AartJansen

Now my workaround doesn't work either, the invoices are unreadable/blank for mail recipients.

jdaviescoates

@humptydumpty said in Not creating pdfs after updates:

Nodebb doesn't have a male facepalm icon so it tossed a female facepalm and the male symbol

this happens me when using emojis on mobile but I eventually worked out you can then edit your post and delete the extra symbol

jdaviescoates

@humptydumpty said in Not creating pdfs after updates:

@girish I checked my PDF's (I send a copy to myself) and it started with 5.11.11. I'm not sure what they're doing upstream, but PDF issues keep recurring every few updates

See, I just quoted your post with the extra symbol then deleted it and it change to the above

humptydumpty

This post is deleted!

girish

@AartJansen are you using the latest package 1.16.0 ? The package has now switched to google chrome stable like upstream. Can you check if a fresh installation works for you?

humptydumpty

I'm on 1.16.0 (upgraded existing app) and PDFs weren't generating for me which in turn causes invoice emails not to send. I changed false to true in the .env file and it's all working now. PHANTOMJS_PDF_GENERATION=true

Do existing apps upgrade properly to the new Chrome thing or should I go with a fresh install? If so, does the normal backup restore/import work in this case or should I use the built-in app's export/import function?

girish

@humptydumpty it should be like below and atleast for new packages it works

PDF_GENERATOR=snappdf
SNAPPDF_CHROMIUM_PATH=/usr/bin/google-chrome-stable

humptydumpty

I'll give those a try soon. Thanks!

humptydumpty

@girish I compared my existing .env file to fresh install to see what else has changed and noticed a few things:

In my existing env file, there was a double entry of this section:

DB_HOST=mysql
DB_DATABASE=blablabla
DB_USERNAME=blablabla
DB_PASSWORD=blablabla
DB_PORT=3306

Then, we have:

Existing env DB_CONNECTION=db-ninja-01
Fresh env DB_CONNECTION=mysql

Existing env TRUSTED_PROXIES=
Fresh env TRUSTED_PROXIES=*

Lastly, we have a few additions that didn't exist before, such as:

PHANTOMJS_KEY='a-demo-key-with-low-quota-per-ip-address'
PHANTOMJS_SECRET=secret

DELETE_PDF_DAYS=60
DELETE_BACKUP_DAYS=60

GOOGLE_PLAY_PACKAGE_NAME=
APPSTORE_PASSWORD=

MICROSOFT_CLIENT_ID=
MICROSOFT_CLIENT_SECRET=
MICROSOFT_REDIRECT_URI=

APPLE_CLIENT_ID=
APPLE_CLIENT_SECRET=
APPLE_REDIRECT_URI=

NORDIGEN_SECRET_ID=
NORDIGEN_SECRET_KEY=

# https://invoiceninja.github.io/en/self-host-installation/#supervisor-for-invoice-ninja-ubuntu-22-04-lts

I hope copy/pasting these new additions won't mess anything up in the database.

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Cloudron Forum

Not creating pdfs after updates