dan0
April 19, 2023, 6:59pm
1
Hi,
I added a new user under Settings => User Management and it shows “An email has been sent to confirm the email address” when I click on the user, but no email has arrived in the user’s inbox.
I did check the mailserver to see if InvoiceNinja tried to send the email, and I restarted the artisan queue and watched the laravel.log and tried “Resend Invite” but no email appears to be sent and no error appeared in laravel.log.
The mailservers also show no login attempt from InvoiceNinja when I attempt to Resend Invite.
We are currently on InvoiceNinja version 5.5.89, and when I try to upgrade to 5.5.104 I do see the following error:
[2023-04-19 18:56:40] production.ERROR: Cannot update system because ee2f842aa7bb1f53edf3a2ed2c09a1807ffa6c90 is not writable {"userId":1,"exception":"[object] (App\\Exceptions\\FilePermissionsFailure(code: 0):
Cannot update system because ee2f842aa7bb1f53edf3a2ed2c09a1807ffa6c90 is not writable at /var/www/invoiceninja-v5/app/Http/Controllers/SelfUpdateController.php:222)
[stacktrace]
#0 /var/www/invoiceninja-v5/app/Http/Controllers/SelfUpdateController.php(82): App\\Http\\Controllers\\SelfUpdateController->testWritable()
#1 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\SelfUpdateController->update()
#2 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#3 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#4 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#5 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#6 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#7 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(89): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#8 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter()
#9 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle()
#10 /var/www/invoiceninja-v5/app/Http/Middleware/QueryLogging.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\QueryLogging->handle()
#12 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#13 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#14 /var/www/invoiceninja-v5/app/Http/Middleware/Locale.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#15 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Locale->handle()
#16 /var/www/invoiceninja-v5/app/Http/Middleware/PasswordProtection.php(114): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#17 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\PasswordProtection->handle()
#18 /var/www/invoiceninja-v5/app/Http/Middleware/TokenAuth.php(100): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#19 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\TokenAuth->handle()
#20 /var/www/invoiceninja-v5/app/Http/Middleware/SetDb.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#21 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetDb->handle()
#22 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#23 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then()
#24 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack()
#25 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute()
#26 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute()
#27 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch()
#28 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#29 /var/www/invoiceninja-v5/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\\DisableBrowserCache->handle()
#31 /var/www/invoiceninja-v5/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle()
#33 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#35 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#37 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#38 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#39 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#40 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#41 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#43 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#45 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#46 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then()
#47 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#48 /var/www/invoiceninja-v5/public/index.php(57): Illuminate\\Foundation\\Http\\Kernel->handle()
#49 {main}
"}
hillel
April 19, 2023, 7:10pm
2
Hi,
Are you able to email invoices?
It may help to set the file permissions:
The leading free source available online invoicing app for freelancers & businesses. Invoice, accept payments, track expenses, & time-tasks
dan0
April 19, 2023, 8:04pm
3
Invoice Emailing has been working thankfully
I completed the upgrade to 5.5.104 after running those commands, but the Invite email is still not being sent to the new user, and there is no error in the Laravel.log and no attempt to log into the mailservers from InvoiceNinja to send this email.
hillel
April 19, 2023, 8:05pm
4
@david do you have any suggestions?
david
April 19, 2023, 10:45pm
5
Are the queues running? You may want to try setting QUEUE_CONNECTION=sync and then update the cache or get the queue’s running with
php artisan queue:listen
dan0
April 20, 2023, 8:07am
6
The queues are running, QUEUE_CONNECTION=Database was set and I see supervisord is configured but was logging to a different part of the disk.
Looks like some jobs are failing though? These are just the ones that failed recently, most queued jobs today and yesterday succeeded.
2023-04-18 16:40:24 App\Listeners\Payment\PaymentBalanceActivity 42.35ms FAIL
2023-04-18 16:40:24 App\Listeners\Payment\PaymentBalanceActivity 81.59ms FAIL
2023-04-19 01:47:43 App\Listeners\Payment\PaymentBalanceActivity 31.74ms FAIL
2023-04-19 01:47:43 App\Listeners\Payment\PaymentBalanceActivity 40.85ms FAIL
2023-04-19 01:47:43 App\Listeners\Payment\PaymentBalanceActivity 60.36ms FAIL
2023-04-19 11:00:09 App\Listeners\Payment\PaymentBalanceActivity 63.80ms FAIL
2023-04-19 11:00:11 App\Listeners\Payment\PaymentBalanceActivity 18.63ms FAIL
2023-04-19 11:00:11 App\Listeners\Payment\PaymentBalanceActivity 41.21ms FAIL
2023-04-19 11:00:11 App\Listeners\Payment\PaymentBalanceActivity 48.01ms FAIL
2023-04-19 11:00:12 App\Listeners\Payment\PaymentBalanceActivity 100.86ms FAIL
2023-04-19 11:00:14 App\Listeners\Payment\PaymentBalanceActivity 85.38ms FAIL
2023-04-19 11:00:17 App\Listeners\Payment\PaymentBalanceActivity 22.57ms FAIL
2023-04-19 11:00:19 App\Listeners\Payment\PaymentBalanceActivity 37.74ms FAIL
2023-04-19 11:00:19 App\Listeners\Payment\PaymentBalanceActivity 129.19ms FAIL
2023-04-19 11:00:22 App\Listeners\Payment\PaymentBalanceActivity 32.59ms FAIL
2023-04-19 11:00:22 App\Listeners\Payment\PaymentBalanceActivity 16.77ms FAIL
2023-04-19 11:00:22 App\Listeners\Payment\PaymentBalanceActivity 38.48ms FAIL
2023-04-19 15:46:15 App\Listeners\Payment\PaymentBalanceActivity 39.69ms FAIL
2023-04-19 15:46:15 App\Listeners\Payment\PaymentBalanceActivity 47.36ms FAIL
2023-04-19 15:46:15 App\Listeners\Payment\PaymentBalanceActivity 55.15ms FAIL
2023-04-19 15:48:09 App\Listeners\Payment\PaymentBalanceActivity 34.82ms FAIL
2023-04-19 15:48:09 App\Listeners\Payment\PaymentBalanceActivity 33.83ms FAIL
2023-04-19 15:48:09 App\Listeners\Payment\PaymentBalanceActivity 52.94ms FAIL
2023-04-19 16:31:13 App\Jobs\Mail\NinjaMailerJob 2023-04-19 16:31:13 App\Jobs\Mail\NinjaMailerJob .............. 11.65ms FAIL
.............. 14.18ms FAIL
2023-04-19 16:46:29 App\Jobs\Mail\NinjaMailerJob ............... 9.04ms FAIL
2023-04-19 17:15:37 App\Jobs\Mail\NinjaMailerJob ............... 8.17ms FAIL
2023-04-19 17:18:16 App\Jobs\Mail\NinjaMailerJob ............... 9.10ms FAIL
2023-04-19 17:29:25 App\Listeners\Payment\PaymentBalanceActivity 79.02ms FAIL
2023-04-19 17:29:25 App\Listeners\Payment\PaymentBalanceActivity 26.04ms FAIL
2023-04-19 17:29:25 App\Listeners\Payment\PaymentBalanceActivity 27.88ms FAIL
2023-04-19 17:31:14 App\Listeners\Payment\PaymentBalanceActivity 23.70ms FAIL
2023-04-19 17:31:14 App\Listeners\Payment\PaymentBalanceActivity 18.47ms FAIL
2023-04-19 17:31:14 App\Listeners\Payment\PaymentBalanceActivity 25.61ms FAIL
2023-04-19 17:39:56 App\Listeners\Payment\PaymentBalanceActivity 34.47ms FAIL
2023-04-19 17:39:56 App\Listeners\Payment\PaymentBalanceActivity 37.87ms FAIL
2023-04-19 17:39:56 App\Listeners\Payment\PaymentBalanceActivity 40.03ms FAIL
2023-04-19 17:44:05 App\Listeners\Payment\PaymentBalanceActivity 24.69ms FAIL
2023-04-19 17:44:05 App\Listeners\Payment\PaymentBalanceActivity 19.57ms FAIL
2023-04-19 17:44:05 App\Listeners\Payment\PaymentBalanceActivity 26.20ms FAIL
2023-04-19 17:47:32 App\Listeners\Payment\PaymentBalanceActivity 31.79ms FAIL
2023-04-19 17:47:32 App\Listeners\Payment\PaymentBalanceActivity 32.00ms FAIL
2023-04-19 17:47:32 App\Listeners\Payment\PaymentBalanceActivity 55.63ms FAIL
2023-04-19 17:54:10 App\Listeners\Payment\PaymentBalanceActivity 38.94ms FAIL
2023-04-19 17:54:11 App\Listeners\Payment\PaymentBalanceActivity 33.25ms FAIL
2023-04-19 17:54:11 App\Listeners\Payment\PaymentBalanceActivity 38.79ms FAIL
2023-04-19 18:59:32 App\Jobs\Mail\NinjaMailerJob .............. 11.20ms FAIL
2023-04-19 20:02:47 App\Jobs\Mail\NinjaMailerJob .............. 15.78ms FAIL
2023-04-19 20:06:02 App\Listeners\Payment\PaymentBalanceActivity 84.79ms FAIL
2023-04-19 20:06:02 App\Listeners\Payment\PaymentBalanceActivity 27.92ms FAIL
2023-04-19 20:06:03 App\Listeners\Payment\PaymentBalanceActivity 52.14ms FAIL
Worker Config:
[program:laravel-worker]
process_name=%(program_name)s_%(process_num)02d
command=/usr/bin/php8.1 /var/www/invoiceninja-v5/artisan queue:work --sleep=3 --tries=3 --max-time=3600
autostart=true
autorestart=true
stopasgroup=true
killasgroup=true
user=www-data
numprocs=8
redirect_stderr=true
stdout_logfile=/var/log/invoiceninja-v5/worker.log
stopwaitsecs=3600
david
April 21, 2023, 12:46am
7
What are the errors in storage/logs/laravel.log
dan0
April 23, 2023, 1:39am
8
Hi @david , below are the errors in storage/logs/laravel.log, and we are also seeing a few quotes that were generated not be viewable when we are logged in as administrator nor are they viewable using the link we sent the client. I also checked the Ledger, Activity and System Log for the client and these are all blank, not reflecting the creation of said quote.
Laravel.log
[2023-03-13 06:17:48] production.ERROR: Undefined constant App\Models\GatewayType::BACS {"exception":"[object] (Error(code: 0): Undefined constant App\\Models\\GatewayType::BACS at /var/www/invoiceninja-v5/app/Models/CompanyGateway.php:144)
[2023-03-13 06:20:03] production.ERROR: Undefined constant App\Models\GatewayType::BACS {"exception":"[object] (Error(code: 0): Undefined constant App\\Models\\GatewayType::BACS at /var/www/invoiceninja-v5/app/Models/CompanyGateway.php:144)
[2023-04-19 16:57:47] production.ERROR: Cannot update system because ee2f842aa7bb1f53edf3a2ed2c09a1807ffa6c90 is not writable {"userId":1,"exception":"[object] (App\\Exceptions\\FilePermissionsFailure(code: 0): Cannot update system because ee2f842aa7bb1f53edf3a2ed2c09a1807ffa6c90 is not writable at /var/www/invoiceninja-v5/app/Http/Controllers/SelfUpdateController.php:222)
[2023-04-19 18:56:40] production.ERROR: Cannot update system because ee2f842aa7bb1f53edf3a2ed2c09a1807ffa6c90 is not writable {"userId":1,"exception":"[object] (App\\Exceptions\\FilePermissionsFailure(code: 0): Cannot update system because ee2f842aa7bb1f53edf3a2ed2c09a1807ffa6c90 is not writable at /var/www/invoiceninja-v5/app/Http/Controllers/SelfUpdateController.php:222)
I have this cron running as www-data
0 * * * * /usr/bin/php /var/www/invoiceninja/artisan ninja:send-invoices
0 * * * * /usr/bin/php /var/www/invoiceninja/artisan ninja:send-reminders
* * * * * /usr/bin/php8.1 /var/www/invoiceninja-v5/artisan schedule:run >> /dev/null 2>&1
This is the Supervisor service that is running:
[program:laravel-worker]
process_name=%(program_name)s_%(process_num)02d
command=/usr/bin/php8.1 /var/www/invoiceninja-v5/artisan queue:work --sleep=3 --tries=3 --max-time=3600
autostart=true
autorestart=true
stopasgroup=true
killasgroup=true
user=www-data
numprocs=8
redirect_stderr=true
stdout_logfile=/var/www/invoiceninja-v5/worker.log
stopwaitsecs=3600
dan0
April 23, 2023, 7:00am
9
Made some progress by updating the laravel-worker to numprocs=1 then chown & chmod’ing the InvoiceNinja folder then doing systemctl restart supervisor as I was getting an error that worker.log was not writable when upgrading to InvoiceNinja 5.5.106 (from 5.5.104), now worker.log has entries from my two attempts to “Resend Invite” to this user:
2023-04-23 06:09:19 App\Jobs\Mail\NinjaMailerJob ................... RUNNING
2023-04-23 06:09:19 App\Jobs\Mail\NinjaMailerJob .............. 10.15ms FAIL
2023-04-23 06:21:20 App\Jobs\Mail\NinjaMailerJob ................... RUNNING
2023-04-23 06:21:24 App\Jobs\Mail\NinjaMailerJob ........... 3,051.67ms DONE
2023-04-23 06:21:30 App\Jobs\Mail\NinjaMailerJob ................... RUNNING
2023-04-23 06:21:32 App\Jobs\Mail\NinjaMailerJob ........... 2,016.12ms DONE
2023-04-23 06:21:44 App\Jobs\Mail\NinjaMailerJob ................... RUNNING
2023-04-23 06:21:44 App\Jobs\Mail\NinjaMailerJob .............. 13.14ms DONE
2023-04-23 06:22:14 App\Jobs\Mail\NinjaMailerJob ................... RUNNING
2023-04-23 06:22:15 App\Jobs\Mail\NinjaMailerJob ........... 1,012.92ms DONE
2023-04-23 06:25:15 App\Jobs\Entity\CreateEntityPdf ................ RUNNING
2023-04-23 06:25:16 App\Jobs\Entity\CreateEntityPdf ........ 1,573.94ms DONE
2023-04-23 06:25:16 App\Jobs\Invoice\CreateEInvoice ................ RUNNING
2023-04-23 06:25:17 App\Jobs\Invoice\CreateEInvoice .......... 178.43ms FAIL
2023-04-23 06:25:17 App\Listeners\Invoice\UpdateInvoiceActivity .... RUNNING
2023-04-23 06:25:17 App\Listeners\Invoice\UpdateInvoiceActivity 787.44ms DONE
2023-04-23 06:25:17 App\Services\Email\Email ....................... RUNNING
2023-04-23 06:25:21 App\Services\Email\Email ............... 3,920.58ms DONE
2023-04-23 06:25:21 App\Listeners\Invoice\InvoiceEmailActivity ..... RUNNING
2023-04-23 06:25:21 App\Listeners\Invoice\InvoiceEmailActivity 14.80ms DONE
2023-04-23 06:25:21 App\Jobs\Invoice\CreateEInvoice ................ RUNNING
2023-04-23 06:25:21 App\Jobs\Invoice\CreateEInvoice .......... 130.35ms FAIL
2023-04-23 06:25:21 App\Listeners\Mail\MailSentListener ............ RUNNING
2023-04-23 06:25:22 App\Listeners\Mail\MailSentListener ....... 40.88ms DONE
2023-04-23 06:25:22 App\Jobs\Invoice\CreateEInvoice ................ RUNNING
2023-04-23 06:25:22 App\Jobs\Invoice\CreateEInvoice .......... 100.51ms FAIL
2023-04-23 06:25:25 App\Listeners\Invoice\InvoiceEmailedNotification RUNNING
2023-04-23 06:25:25 App\Listeners\Invoice\InvoiceEmailedNotification 18.93ms DONE
2023-04-23 06:25:28 App\Jobs\Ledger\ClientLedgerBalanceUpdate ...... RUNNING
2023-04-23 06:25:28 App\Jobs\Ledger\ClientLedgerBalanceUpdate . 23.10ms DONE
2023-04-23 06:26:16 App\Jobs\Mail\NinjaMailerJob ................... RUNNING
2023-04-23 06:26:16 App\Jobs\Mail\NinjaMailerJob ............... 9.07ms FAIL
There is nothing new in laravel.log when I try “Resend Invite”.
When I tried to email an invoice the error below occured, looks like I need to figure out how to set the country (iso_3166_2) value for every client?
[2023-04-23 06:25:17] production.ERROR: Attempt to read property "iso_3166_2" on null {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"iso_3166_2\" on null at /var/www/invoiceninja-v5>
[stacktrace]
#0 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(266): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /var/www/invoiceninja-v5/app/Services/Invoice/EInvoice/ZugferdEInvoice.php(79): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /var/www/invoiceninja-v5/app/Jobs/Invoice/CreateEInvoice.php(66): App\\Services\\Invoice\\EInvoice\\ZugferdEInvoice->run()
#3 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\Invoice\\CreateEInvoice->handle()
#4 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#5 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#6 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#7 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#8 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()
#9 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()
#10 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()
#12 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()
#13 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()
#14 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#15 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\\Pipeline\\Pipeline->then()
#16 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()
#17 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call()
#18 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\\Queue\\Jobs\\Job->fire()
#19 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\\Queue\\Worker->process()
#20 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\\Queue\\Worker->runJob()
#21 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#22 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#23 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#24 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#25 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#26 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#27 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#28 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call()
#29 /var/www/invoiceninja-v5/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#30 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\\Component\\Console\\Command\\Command->run()
#31 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(1022): Illuminate\\Console\\Command->run()
#32 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#33 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#34 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#35 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run()
#36 /var/www/invoiceninja-v5/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#37 {main}
"}
[2023-04-23 06:25:21] production.ERROR: Attempt to read property "iso_3166_2" on null {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"iso_3166_2\" on null at /var/www/invoiceninja-v5>
[stacktrace]
#0 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(266): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /var/www/invoiceninja-v5/app/Services/Invoice/EInvoice/ZugferdEInvoice.php(79): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /var/www/invoiceninja-v5/app/Jobs/Invoice/CreateEInvoice.php(66): App\\Services\\Invoice\\EInvoice\\ZugferdEInvoice->run()
#3 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\Invoice\\CreateEInvoice->handle()
#4 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#5 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#6 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#7 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#8 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()
#9 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()
#10 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()
#12 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()
#13 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()
#14 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#15 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\\Pipeline\\Pipeline->then()
#16 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()
#17 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call()
#18 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\\Queue\\Jobs\\Job->fire()
#19 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\\Queue\\Worker->process()
#20 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\\Queue\\Worker->runJob()
#21 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#22 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#23 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#24 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#25 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#26 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#27 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#28 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call()
#29 /var/www/invoiceninja-v5/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#30 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\\Component\\Console\\Command\\Command->run()
#31 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(1022): Illuminate\\Console\\Command->run()
#32 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#33 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#34 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#35 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run()
#36 /var/www/invoiceninja-v5/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#37 {main}
"}
[2023-04-23 06:25:22] production.ERROR: Attempt to read property "iso_3166_2" on null {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"iso_3166_2\" on null at /var/www/invoiceninja-v5>
[stacktrace]
#0 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(266): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /var/www/invoiceninja-v5/app/Services/Invoice/EInvoice/ZugferdEInvoice.php(79): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /var/www/invoiceninja-v5/app/Jobs/Invoice/CreateEInvoice.php(66): App\\Services\\Invoice\\EInvoice\\ZugferdEInvoice->run()
#3 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\Invoice\\CreateEInvoice->handle()
#4 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#5 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#6 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#7 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#8 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()
#9 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()
#10 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()
#12 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()
#13 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()
#14 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#15 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\\Pipeline\\Pipeline->then()
#16 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()
#17 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call()
#18 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\\Queue\\Jobs\\Job->fire()
#19 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\\Queue\\Worker->process()
#20 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\\Queue\\Worker->runJob()
#21 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#22 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#23 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#24 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#25 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#26 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#27 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#28 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call()
#29 /var/www/invoiceninja-v5/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#30 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\\Component\\Console\\Command\\Command->run()
#31 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(1022): Illuminate\\Console\\Command->run()
#32 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#33 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#34 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#35 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run()
#36 /var/www/invoiceninja-v5/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#37 {main}
"}
Additionally, when I tried to update the timezone under Settings => Localization => Timezone to US/Pacific I get a “500: Server Error” shown onscreen too.
Trying to remedy this issue I tried a php artisan migrate based on this post’s recommendation , but it failed (pictured below).
david
April 23, 2023, 10:40pm
10
@dan0
From your description there may be a couple of issues happening.
You can run the following command which will update any clients with a missing iso_3166_2
php artisan ninja:check-data --fix=true
Ensure the webuser owns everything: (assuming www-data is the user)
sudo chown -R www-data:www-data the_root_folder_of_invoice_ninja
Finally for the migrations, It looks like you may have inadvertantly created another migration file. You can safely delete the file in the error screen.
database/migrations/2023_02_09_04........
and then reattempt the migration
dan0
April 23, 2023, 11:06pm
11
I followed your instructions, the migration seems successful but it looks like I have an issue with client #1912 ’s balance not being correct?
The New User Invite sent successfully and I was able to update the timezone to US/Pacific!
Viewing the ledger on client 0917 no longer generates an error but I am not seeing the quote I created for this client in June 2022 still,
root@billing:/var/www/invoiceninja-v5# chown -R www-data:www-data /var/www/invoiceninja-v5
root@billing:/var/www/invoiceninja-v5# rm database/migrations/2023_02_09_045217_create_failed_jobs_table
root@billing:/var/www/invoiceninja-v5# php artisan ninja:check-data --fix=true
2023-04-23 10:48:42 2023-04-23 10:48:42 Running CheckData... on Connected to Default DB Fix Status = Fixing Issues
2023-04-23 10:48:42 0 clients with incorrect balances
2023-04-23 10:48:42 Redacted Company Name id = # 1912 - Client Paid To Date = 5486.300000 != Invoice Payments = 6251.5 - 5191.230000 + 1060.2700
2023-04-23 10:48:42 1 clients with incorrect paid to dates
2023-04-23 10:48:42 0 contacts without a contact_key
2023-04-23 10:48:42 0 clients without any contacts
2023-04-23 10:48:42 0 contacts without a contact_key
2023-04-23 10:48:42 0 vendors without any contacts
2023-04-23 10:48:42 0 wrong invoices with bad balance state
2023-04-23 10:48:42 Fixing country for # 1973
2023-04-23 10:48:42 Fixing country for # 1974
2023-04-23 10:48:42 Fixing country for # 1975
2023-04-23 10:48:42 Fixing country for # 1976
2023-04-23 10:48:42 0 users with duplicate oauth ids
2023-04-23 10:48:42 Done: FAILURE
2023-04-23 10:48:42 Total execution time in seconds: 0.31597590446472
Issues still occurring
Error on client #1912 ’s balance not reconciling properly
Quote still missing for client 0917
Fixed by setting Shipping Address - Emailing invoice to myself (test client # 0093) throws the error below about the country code not being set
[2023-04-23 23:01:11] production.ERROR: Attempt to read property "iso_3166_2" on null {"exception":"[object] (ErrorException(code: 0): Attempt to read property \"iso_3166_2\" on null at /var/www/invoiceninja-v5/app/Services/Invoice/EInvoice/ZugferdEInvoice.php:79)
[stacktrace]
#0 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(266): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()
#1 /var/www/invoiceninja-v5/app/Services/Invoice/EInvoice/ZugferdEInvoice.php(79): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}()
#2 /var/www/invoiceninja-v5/app/Jobs/Invoice/CreateEInvoice.php(66): App\\Services\\Invoice\\EInvoice\\ZugferdEInvoice->run()
#3 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\Invoice\\CreateEInvoice->handle()
#4 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#5 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#6 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#7 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#8 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()
#9 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()
#10 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#11 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()
#12 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()
#13 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()
#14 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#15 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(126): Illuminate\\Pipeline\\Pipeline->then()
#16 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()
#17 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call()
#18 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(425): Illuminate\\Queue\\Jobs\\Job->fire()
#19 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\\Queue\\Worker->process()
#20 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(173): Illuminate\\Queue\\Worker->runJob()
#21 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\\Queue\\Worker->daemon()
#22 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\\Queue\\Console\\WorkCommand->runWorker()
#23 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#24 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#25 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#26 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#27 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Container/Container.php(661): Illuminate\\Container\\BoundMethod::call()
#28 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\\Container\\Container->call()
#29 /var/www/invoiceninja-v5/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#30 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Command.php(153): Symfony\\Component\\Console\\Command\\Command->run()
#31 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(1022): Illuminate\\Console\\Command->run()
#32 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#33 /var/www/invoiceninja-v5/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#34 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Console/Application.php(102): Symfony\\Component\\Console\\Application->run()
#35 /var/www/invoiceninja-v5/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(155): Illuminate\\Console\\Application->run()
#36 /var/www/invoiceninja-v5/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#37 {main}
"}
david
April 24, 2023, 7:13am
12
@dan0 ,
I’ll tag another release now with fixes for the EInvoice issue.
dan0
April 24, 2023, 7:14am
13
Thanks @david , I really appreciate your help!
Let me know when to test it out and I will give it a spin.
david
April 24, 2023, 7:26am
14
@dan0
i’ve tagged it now, should be available shortly
dan0
April 24, 2023, 7:47am
15
Awesome, I force upgraded and the only issue I’m left with is the error on client # 1912’s balance not reconciling.
Any suggestions on how I would go about correcting this data error?
root@billing:/var/www/invoiceninja-v5# php artisan ninja:check-data --fix=true
2023-04-24 07:44:56 2023-04-24 07:44:56 Running CheckData... on Connected to Default DB Fix Status = Fixing Issues
2023-04-24 07:44:56 0 clients with incorrect balances
2023-04-24 07:44:56 Redacted Client Name id = # 1912 - Client Paid To Date = 5486.300000 != Invoice Payments = 6251.5 - 5191.230000 + 1060.2700
2023-04-24 07:44:56 1 clients with incorrect paid to dates
2023-04-24 07:44:56 0 contacts without a contact_key
2023-04-24 07:44:56 0 clients without any contacts
2023-04-24 07:44:56 0 contacts without a contact_key
2023-04-24 07:44:56 0 vendors without any contacts
2023-04-24 07:44:56 0 wrong invoices with bad balance state
2023-04-24 07:44:56 0 users with duplicate oauth ids
2023-04-24 07:44:56 Done: FAILURE
2023-04-24 07:44:56 Total execution time in seconds: 0.2820188999176
dan0
April 24, 2023, 9:34am
16
Hmm, I took a peek at Recurring Invoices and there are 17 invoices with a Next Send Date that has already passed, looks like all are between April 20th and April 23rd 2023.
Do I need both the cronjob running as www-data and the supervisor service to create these recurring invoices and process autopay?
david
April 24, 2023, 9:45am
17
@dan0
Try running this:
php artisan ninja:check-data --fix=true --paid_to_date=true
dan0
April 24, 2023, 9:47am
18
Edit: It failed the first time, but worked when ran again :
2023-04-24 09:46:10 2023-04-24 09:46:10 Running CheckData... on Connected to Default DB Fix Status = Fixing Issues
2023-04-24 09:46:10 0 clients with incorrect balances
2023-04-24 09:46:10 Redacted Client Name id = # 1912 - Client Paid To Date = 5486.300000 != Invoice Payments = 6251.5 - 5191.230000 + 1060.2700
2023-04-24 09:46:10 # 1912 Redacted Client Name - 0946 Fixing 5486.300000 to 6251.5
2023-04-24 09:46:10 1 clients with incorrect paid to dates
2023-04-24 09:46:10 0 contacts without a contact_key
2023-04-24 09:46:10 0 clients without any contacts
2023-04-24 09:46:10 0 contacts without a contact_key
2023-04-24 09:46:10 0 vendors without any contacts
2023-04-24 09:46:10 0 wrong invoices with bad balance state
2023-04-24 09:46:10 0 users with duplicate oauth ids
2023-04-24 09:46:10 Done: FAILURE
2023-04-24 09:46:10 Total execution time in seconds: 0.32226586341858