cmcam
January 11, 2024, 4:04am
1
Hello,
I am trying to generate a PO to one of my vendors for a project. Their address shows up properly, however if I go to settings and assign the PO to the client, the vendor’s city will change to the client’s city.
For example, Vendor1 in NYC will show up 123 9th ave, NYC 10001. Assigning PO to client XY who is based in Ft Lauderdale FL will result in Vendor1’s address being changed to 123 9th ave, Ft Lauderdale FL.
Is this expected behavior, or am I doing something incorrectly?
hillel
January 11, 2024, 6:59am
2
Hi,
Are you using a standard design?
cmcam
January 11, 2024, 1:17pm
3
Yes, I am using the Business design for this. If I try to change to a different design, the PDF will reload, but the design always stays on business no matter what is selected.
hillel
January 11, 2024, 1:23pm
4
Are you changing the design on Settings > Invoice Design or in the settings tab on the edit invoice/purchase order screen?
cmcam
January 11, 2024, 1:25pm
5
Within the PO/Invoice itself. If I change it in the Settings menu and click update all records, it does push out to everything. However Changing the design still results in the same issue.
Thanks
hillel
January 11, 2024, 1:34pm
6
@david I’m able to reproduce the problem where changing the PO design doesn’t update the preview in both the Flutter and React apps.
I haven’t been able to reproduce the address issue though.
cmcam
January 11, 2024, 2:04pm
7
@hillel I have done a screen recording, if it helps. Here is the link .
cmcam
January 11, 2024, 4:27pm
8
I am trying to send a PO and got this in the logs, accompanied by a 500 error on the desktop app.
2024-01-11 16:23:14] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninja.purchaseO>
[stacktrace]
#0 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\\Database\\Conn>
#1 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\\Database\\Conn>
#2 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\\Database\\>
#3 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\\Database\\>
#4 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\\Database\\>
#5 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\\Database\\>
#6 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3221): Illuminate\\Database\\>
#7 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3149): Illuminate\\Database\\>
#8 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/DatabasePresenceVerifier.php(54): Illuminate\>
#9 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(903): Illumi>
#10 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(874): Illum>
#11 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(657): Illuminate\\Validation\\>
#12 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(457): Illuminate\\Validation\\>
#13 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(492): Illuminate\\Validation\\>
#14 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Validation/ValidatesWhenResolvedTrait.php(31): Illumina>
#15 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Providers/FormRequestServiceProvider.php(30)>
#16 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(1302): Illuminate\\Foundation\\>
#17 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(1266): Illuminate\\Container\\C>
#18 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(1252): Illuminate\\Container\\C>
#19 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(813): Illuminate\\Container\\Co>
#20 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(957): Illuminate\\Container\>
#21 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Container/Container.php(731): Illuminate\\Foundation\\A>
#22 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(942): Illuminate\\Container\>
#23 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ResolvesRouteDependencies.php(85): Illuminate\\>
#24 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ResolvesRouteDependencies.php(50): Illuminate\\>
#25 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ResolvesRouteDependencies.php(29): Illuminate\\>
#26 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(59): Illuminate\\Routi>
#27 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(40): Illuminate\\Routi>
#28 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTrac>
#29 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php(19>
#30 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTrac>
#31 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Sentry\\Laravel\\Tracing\\Routi>
#32 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->run>
#33 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\\Routing\\Route->ru>
#34 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Routing\\Router>
#35 /var/www/invoiceninja/app/Http/Middleware/UserVerified.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\>
#36 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\User>
#37 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(122): Illuminat>
#38 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(87): Illuminate>
#39 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middle>
#40 /var/www/invoiceninja/app/Http/Middleware/QueryLogging.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\>
#41 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Quer>
#42 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illumina>
#43 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Routing\\Middle>
#44 /var/www/invoiceninja/app/Http/Middleware/Locale.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{clos>
#45 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Loca>
#46 /var/www/invoiceninja/app/Http/Middleware/TokenAuth.php(101): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{>
#47 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Toke>
#48 /var/www/invoiceninja/app/Http/Middleware/SetDb.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closu>
#49 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\SetD>
#50 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipel>
#51 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\\Pipeline\\Pipeline>
#52 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\\Routing\\Router->r>
#53 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\\Routing\\Router->r>
#54 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\\Routing\\Router->d>
#55 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\R>
#56 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Foundation\\Htt>
#57 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestIpMiddleware.php(45): Illuminate>
#58 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetR>
#59 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Http/SetRequestMiddleware.php(31): Illuminate\\>
#60 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Http\\SetR>
#61 /var/www/invoiceninja/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMid>
#62 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\\Features\\Support>
#63 /var/www/invoiceninja/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closur>
#64 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\\Http\\Middleware\\Cors>
#65 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipel>
#66 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Http\\Middlewar>
#67 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): I>
#68 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.ph>
#69 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#70 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): I>
#71 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illumin>
#72 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#73 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Il>
#74 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#75 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMainten>
#76 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\\Foundation\\Htt>
#77 /var/www/invoiceninja/vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Middleware.php(87): Illuminate\\Pipelin>
#78 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Sentry\\Laravel\\Tracing\\M>
#79 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipel>
#80 /var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\>
#/var/www/invoiceninja/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation>
#82 /var/www/invoiceninja/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle()
#83 {main}
hillel
January 11, 2024, 4:48pm
9
I believe this is the same issue:
I am getting this error when sending a purchase order. What I can see is the purchase order table has a mismatched name:
Table on error: ninja_ninj222.purchaseOrders
Table on MyAdmin: ninja_ninj222.purchase_Orders
How do I fix this?
[2024-01-08 12:53:03] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ninja_ninj222.purchaseOrders’ doesn’t exist (Connection: mysql, SQL: select count() as aggregate from purchaseOrders where id = 2 and company_id = 3) {“userId”:1,“e…
cmcam
January 11, 2024, 4:56pm
10
Yes, it looks like it. I ran artisan migrate, and get the same “nothing to migrate” message. I will monitor the other thread for updates. Thanks.
david
January 12, 2024, 1:14am
11
I’ve checked in a fix for the po preview
1 Like
cmcam
January 12, 2024, 5:53pm
12
I am not sure if it is related, but the PO is still showing the balance, even if expensing it and marking the expense as paid. I just updated to v5.8.10 and the previews are working for changing designs.
Additionally, vendor portal is showing as empty.