404 — Not Found

mdsolutions · April 11, 2023, 2:41pm

No input file specified.
Status: 404 Not Found
X-Powered-By: PHP/8.1.17
Content-type: text/html; charset=UTF-8

No input file specified.

david · April 11, 2023, 11:04pm

I would try this a different way:

/usr/local/bin/ea-php81 /home/mdsolutions/public_html/boekhouding/artisan schedule:run

alphayash · April 12, 2023, 12:15pm

i am having the same issue, this isn’t woeking for me /usr/local/bin/ea-php81 /home/pvtagn/public_html/itaxlol/ && php artisan schedule:run >> -q

mdsolutions · April 19, 2023, 7:24am

know i have an 500 error, yesterday it was working the site, know the whole site is offline with an 500 error…

mdsolutions · April 19, 2023, 7:24am

i didnt change anything

mdsolutions · May 4, 2023, 9:09pm

2 problems:

emails dont send anymore, in the laravel log i see this everytime…

image735×102 4.46 KB

But where is the IBAN field?

second problem is that the crons still dont work…

mdsolutions · May 4, 2023, 9:10pm

/usr/local/bin/ea-php81 /home/mdsolutions/public_html/boekhouding/ && php artisan schedule:run >> /home/mdsolutions/public_html/testfile.txt 2>&1

/usr/local/bin/ea-php81 /home/mdsolutions/public_html/md-itsolutions.nl/ && php artisan schedule:run

this are my crons…

hillel · May 6, 2023, 8:46pm

@david any thoughts?

david · May 7, 2023, 12:02pm

Your crons don’t look right:

/usr/local/bin/ea-php81 /home/mdsolutions/public_html/boekhouding/ && php artisan schedule:run >> /home/mdsolutions/public_html/testfile.txt 2>&1

/usr/local/bin/ea-php81 /home/mdsolutions/public_html/md-itsolutions.nl/ && php artisan schedule:run

They should be something like

cd /home/mdsolutions/public_html/md-itsolutions.nl/ && /usr/local/bin/ea-php81 artisan schedule:run

mdsolutions · May 18, 2023, 8:13pm

No result…

david · May 18, 2023, 9:38pm

@mdsolutions

So if the command is working then you should see something like this:

   INFO  No scheduled commands are ready to run.

If you are not seeing this, then it is either an issue with a disabled extension that the webhost has enforced. I would create a ticket with your host and ask them whether their platform supports Laravel 9 applications, and advise that terminal commands to execute the cron scheduler doesn’t seem to be returning a response. They’ll be able to advise more.

mdsolutions · May 22, 2023, 11:25am

its my own VPS…

can whe make an remote session? that u can look with me?

mdsolutions · June 29, 2023, 6:45am

The credentials are good, but still i got this errors.
Previous week i get one time an email that was send, after that i dont recieve or costumers dont recieve mails…

invoiceninja log:

[2023-06-28 21:00:08] production.INFO: Mailer failed with Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com'  
[2023-06-28 21:00:59] production.INFO: net deletable amount - refunded = 3.03  
[2023-06-28 21:00:59] production.INFO: The IBAN field is required  
[2023-06-28 21:01:09] production.INFO: The IBAN field is required  
[2023-06-28 21:02:40] production.INFO: Test filesystem is writable  
[2023-06-28 21:02:41] production.INFO: Clear cache directory  
[2023-06-28 21:02:41] production.INFO: copying release file  
[2023-06-28 21:10:13] production.INFO: Test filesystem is writable  
[2023-06-28 21:10:13] production.INFO: Clear cache directory  
[2023-06-28 21:10:13] production.INFO: copying release file  
[2023-06-28 21:11:48] production.INFO: Test filesystem is writable  
[2023-06-28 21:11:49] production.INFO: Clear cache directory  
[2023-06-28 21:11:49] production.INFO: copying release file  
[2023-06-28 21:14:11] production.INFO: Test filesystem is writable  
[2023-06-28 21:14:11] production.INFO: Clear cache directory  
[2023-06-28 21:14:11] production.INFO: copying release file  
[2023-06-28 21:14:15] production.INFO: Copied file from URL  
[2023-06-28 21:14:15] production.INFO: Finished copying  
[2023-06-28 21:14:15] production.INFO: Extracting tar  
[2023-06-28 21:14:25] production.INFO: Finished extracting files  
[2023-06-28 21:14:25] production.INFO: Deleted release zip file  
[2023-06-28 21:14:25] production.INFO: Removing cache files  
[2023-06-28 21:14:49] production.INFO: The IBAN field is required  
[2023-06-28 21:14:50] production.INFO: The IBAN field is required  
[2023-06-28 21:15:02] production.INFO: The IBAN field is required  
[2023-06-28 21:15:02] production.INFO: The IBAN field is required  
[2023-06-28 21:15:04] production.INFO: Using mailer => smtp 2023-06-28 21:15:04  
[2023-06-28 21:15:08] production.INFO: Mailer failed with Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com'  
[2023-06-28 21:15:09] production.INFO: invoice  
[2023-06-28 21:15:09] production.INFO: Trying to send to info@md-solutions.nl 2023-06-28 21:15:09  
[2023-06-28 21:15:09] production.INFO: Using mailer => smtp  
[2023-06-28 21:15:13] production.INFO: Mailer failed with Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com'  
[2023-06-28 21:17:01] production.INFO: Test filesystem is writable  
[2023-06-28 21:17:01] production.INFO: Clear cache directory  
[2023-06-28 21:17:01] production.INFO: copying release file  
[2023-06-28 21:17:03] production.INFO: Copied file from URL  
[2023-06-28 21:17:03] production.INFO: Finished copying  
[2023-06-28 21:17:03] production.INFO: Extracting tar  
[2023-06-28 21:17:14] production.INFO: Finished extracting files  
[2023-06-28 21:17:14] production.INFO: Deleted release zip file  
[2023-06-28 21:17:14] production.INFO: Removing cache files  
[2023-06-28 21:42:04] production.INFO: Trying to send to mickygeurts@gmail.com 2023-06-28 21:42:04  
[2023-06-28 21:42:04] production.INFO: Using mailer => smtp  
[2023-06-28 21:42:08] production.INFO: Mailer failed with Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com'  
[2023-06-28 21:42:10] production.INFO: Trying to send to info@md-solutions.nl 2023-06-28 21:42:10  
[2023-06-28 21:42:10] production.INFO: Using mailer => smtp  
[2023-06-28 21:42:14] production.INFO: Mailer failed with Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com'

Laravel Log:

[2023-06-28 21:23:40] production.ERROR: Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com' {"userId":1,"exception":"[object] (Symfony\\Component\\Mailer\\Exception\\TransportException(code: 0): Unable to connect with STARTTLS: stream_socket_enable_crypto(): Peer certificate CN=`vps1.md-solutions.nl' did not match expected CN=`smtp.office365.com' at /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/Stream/SocketStream.php:171)
[stacktrace]
#0 [internal function]: Symfony\\Component\\Mailer\\Transport\\Smtp\\Stream\\SocketStream->Symfony\\Component\\Mailer\\Transport\\Smtp\\Stream\\{closure}(2, 'stream_socket_e...', '/home/mdsolutio...', 174)
#1 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/Stream/SocketStream.php(174): stream_socket_enable_crypto(Resource id #16, true)
#2 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/EsmtpTransport.php(139): Symfony\\Component\\Mailer\\Transport\\Smtp\\Stream\\SocketStream->startTLS()
#3 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/EsmtpTransport.php(105): Symfony\\Component\\Mailer\\Transport\\Smtp\\EsmtpTransport->doEhloCommand()
#4 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(254): Symfony\\Component\\Mailer\\Transport\\Smtp\\EsmtpTransport->executeCommand('HELO [127.0.0.1...', Array)
#5 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(277): Symfony\\Component\\Mailer\\Transport\\Smtp\\SmtpTransport->doHeloCommand()
#6 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(213): Symfony\\Component\\Mailer\\Transport\\Smtp\\SmtpTransport->start()
#7 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/AbstractTransport.php(69): Symfony\\Component\\Mailer\\Transport\\Smtp\\SmtpTransport->doSend(Object(Symfony\\Component\\Mailer\\SentMessage))
#8 /home/mdsolutions/public_html/boekhouding/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(137): Symfony\\Component\\Mailer\\Transport\\AbstractTransport->send(Object(Symfony\\Component\\Mime\\Email), Object(Symfony\\Component\\Mailer\\DelayedEnvelope))
#9 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(523): Symfony\\Component\\Mailer\\Transport\\Smtp\\SmtpTransport->send(Object(Symfony\\Component\\Mime\\Email), Object(Symfony\\Component\\Mailer\\DelayedEnvelope))
#10 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(287): Illuminate\\Mail\\Mailer->sendSymfonyMessage(Object(Symfony\\Component\\Mime\\Email))
#11 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/Mailable.php(204): Illuminate\\Mail\\Mailer->send('email.support.m...', Array, Object(Closure))
#12 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Support/Traits/Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()
#13 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/Mailable.php(197): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))
#14 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(309): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))
#15 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(253): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\SupportMessageSent))
#16 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Mail/PendingMail.php(124): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\SupportMessageSent))
#17 /home/mdsolutions/public_html/boekhouding/app/Http/Controllers/Support/Messages/SendingController.php(78): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\SupportMessageSent))
#18 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\Support\\Messages\\SendingController->__invoke(Object(Illuminate\\Http\\Request))
#19 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('__invoke', Array)
#20 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Support\\Messages\\SendingController), '__invoke')
#21 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#22 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#23 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#24 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(89): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#25 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(54): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure))
#26 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api')
#27 /home/mdsolutions/public_html/boekhouding/app/Http/Middleware/QueryLogging.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#28 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\QueryLogging->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#29 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#30 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#31 /home/mdsolutions/public_html/boekhouding/app/Http/Middleware/Locale.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#32 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Locale->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#33 /home/mdsolutions/public_html/boekhouding/app/Http/Middleware/TokenAuth.php(101): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#34 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\TokenAuth->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#35 /home/mdsolutions/public_html/boekhouding/app/Http/Middleware/SetDb.php(40): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#36 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\SetDb->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#37 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#38 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Router.php(797): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#39 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#40 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#41 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#42 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#43 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#44 /home/mdsolutions/public_html/boekhouding/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#45 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\\DisableBrowserCache->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#46 /home/mdsolutions/public_html/boekhouding/app/Http/Middleware/Cors.php(24): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#47 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\\Http\\Middleware\\Cors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#50 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#51 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#52 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#53 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#54 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#55 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#56 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#57 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#58 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#59 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#60 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#61 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#62 /home/mdsolutions/public_html/boekhouding/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#63 /home/mdsolutions/public_html/boekhouding/public/index.php(56): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#64 {main}
"}

mdsolutions · June 29, 2023, 6:45am

The IBAN field is required

Where to set?

mdsolutions · June 29, 2023, 6:49am

with everything i do…

mdsolutions · June 29, 2023, 6:56am

500: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘invoice_task_item_description’ in ‘field list’ (SQL: update companies set convert_products = 0, fill_products = 1, update_products = 1, show_product_details = 1, client_can_register = 1, custom_surcharge_taxes1 = 0, custom_surcharge_taxes2 = 0, custom_surcharge_taxes3 = 0, custom_surcharge_taxes4 = 0, enable_product_cost = 0, enable_product_quantity = 1, default_quantity = 1, google_analytics_key = ?, enable_shop_api = 0, mark_expenses_invoiceable = 0, mark_expenses_paid = 0, invoice_expense_documents = 0, auto_start_tasks = 0, invoice_task_timelog = 1, invoice_task_documents = 0, show_tasks_table = 0, is_disabled = 0, default_task_is_date_based = 0, enable_product_discount = 0, calculate_expense_tax_by_amount = 0, expense_inclusive_taxes = 0, oauth_password_required = 0, invoice_task_datelog = 1, show_task_end_date = 0, markdown_enabled = 1, use_comma_as_decimal_place = 0, report_include_drafts = 1, convert_rate_to_client = 1, markdown_email_enabled = 0, stop_on_unpaid_recurring = 0, use_quote_terms_on_conversion = 0, enable_applying_payments = 0, track_inventory = 0, stock_notification = 1, invoice_task_project = 0, report_include_deleted = 1, invoice_task_lock = 0, convert_payment_currency = 0, convert_expense_currency = 0, notify_vendor_when_paid = 0, invoice_task_hours = 0, calculate_taxes = 0, invoice_task_item_description = 0, invoice_task_project_header = 0, companies.updated_at = 2023-06-29 06:56:36.150714 where id = 1)

hillel · June 29, 2023, 8:22am

It may help to run php artisan migrate

mdsolutions · June 29, 2023, 10:07am

???

hillel · June 29, 2023, 10:12am

It should help to comment out this line and try again:

github.com

invoiceninja/invoiceninja/blob/v5-stable/database/migrations/2023_04_27_045639_add_kmher_language.php#L29


      
          
          
    Language::unguard();
          
          
    $language = Language::find(38);
          
          
    if (! $language) {
                  Language::create(['id' => 38, 'name' => 'Khmer', 'locale' => 'km_KH']);
              }
          
          
    Schema::table('companies', function (Blueprint $table) {
                  $table->dropColumn('enable_e_invoice');
              });
          
          
    Company::query()->cursor()->each(function ($company){
                  $company->tax_data = new TaxModel();
                  $company->save();
              });
          }
          
          
/**
           * Reverse the migrations.

@david what do you think about adding a property_exists check as in this file to prevent this problem.

github.com

invoiceninja/invoiceninja/blob/v5-stable/database/migrations/2023_05_03_023956_add_shopify_user_id.php#L22


      
           *
           * @return void
           */
          public function up()
          {
          
          
    Company::query()->cursor()->each(function ($company) {
          
          
        $settings = $company->settings;
          
          
        if(!property_exists($settings, 'enable_e_invoice')) {
          
          
            $company->saveSettings((array)$company->settings, $company);
          
          
        }
          
          
    });
          
          
    Schema::table('users', function (Illuminate\Database\Schema\Blueprint $table) {
                  $table->unsignedBigInteger('shopify_user_id')->index()->nullable();
              });

mdsolutions · June 29, 2023, 10:14am

i have made the table and now updating works.
but emailing not…

[2023-06-29 10:12:25] production.INFO: The IBAN field is required
[2023-06-29 10:12:29] production.INFO: The IBAN field is required
[2023-06-29 10:12:39] production.INFO: The IBAN field is required
[2023-06-29 10:12:44] production.INFO: The IBAN field is required
[2023-06-29 10:12:44] production.INFO: The IBAN field is required
[2023-06-29 10:12:46] production.INFO: Using mailer => office365 2023-06-29 10:12:46
[2023-06-29 10:12:46] production.INFO: Call to a member function getValue() on null

[2023-06-29 10:12:46] production.ERROR: Call to a member function getValue() on null {“userId”:1,“exception”:"[object] (Error(code: 0): Call to a member function getValue() on null at /home/mdsolutions/public_html/boekhouding/app/Helpers/Mail/Office365MailTransport.php:31)
[stacktrace]