Issues after upgrade to 5.10.4

BinaryAlps · July 12, 2024, 10:13am

I have recently upgraded to the latest version 5.10.4 and tried to make a change on the colors. An error appears on top and I had a look at the laravel.log:

[2024-07-12 10:03:11] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'smtp_host' in 'field list' (Connection: db-ninja-01, SQL: update `companies` set `convert_prod>
[stacktrace]

not quite sure what “db-ninja-01” is but my database is called differently.
In the installation root I tried running php artisan migrate but this is giving me the following errors:

How can I get rid of those errors?

BR
Fabian

hillel · July 12, 2024, 10:15am

Hi,

It should help to comment out the parts of this migration that have already run and try it again.

github.com

invoiceninja/invoiceninja/blob/v5-develop/database/migrations/2023_11_26_082959_add_bank_integration_id.php#L17


      
          use Illuminate\Support\Facades\Schema;
          
          return new class extends Migration {
              /**
               * Run the migrations.
               *
               * @return void
               */
              public function up()
              {
                  Schema::table('bank_integrations', function (Blueprint $table) {
                      $table->string('integration_type')->nullable();
                      $table->string('nordigen_account_id')->nullable();
                      $table->string('nordigen_institution_id')->nullable();
                  });
          
                  // migrate old account to be used with yodlee
                  BankIntegration::query()->whereNull('integration_type')->whereNotNull('account_id')->cursor()->each(function ($bank_integration) {
                      $bank_integration->integration_type = BankIntegration::INTEGRATION_TYPE_YODLEE;
                      $bank_integration->save();
                  });

BinaryAlps · July 12, 2024, 10:26am

Awesome! I needed to comment out lines 18, 19 & 20 and rerun the command:

Also changes in the frontend are now getting saved as intended - thank you for your quick help!

hillel · July 12, 2024, 10:29am

Glad to hear it, thanks for the update!