Cannot update custom invoice design due to 500 error

Self-Hosted | v5
1

Hi there!
I’m running v5.7.63-C146 selfhosted and trying to update my custom invoice design. However once I click on save I get a 500 Server error.

The log contains the following messages:

[2024-01-02 11:06:01] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_template' in 'field list' (Connection: db-ninja-01, SQL: update `designs` set `is_template` = 0, `entities` = , `designs`.`updated_at` = 2024-01-02 11:06:01.298667 where `id` = 10) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_template' in 'field list' (Connection: db-ninja-01, SQL: update `designs` set `is_template` = 0, `entities` = , `designs`.`updated_at` = 2024-01-02 11:06:01.298667 where `id` = 10) at /var/www/rechnungen/vendor/laravel/framework/src/Illuminate/Database/Connection.php:822)
[stacktrace]
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_template' in 'field list' at /var/www/rechnungen/vendor/laravel/framework/src/Illuminate/Database/Connection.php:601)
[stacktrace]

How can I resolve this error?

BR,
Fabian

2

Hi,

It may help to run php artisan migrate

3

This gives me the following error:

image
image3332×660 284 KB

4

It looks like a migration didn’t complete, you can fix this by commenting out the lines which have already been run and try again.

5

Can you help me figure out where I have to comment out some lines?

6

The migration file is shown in the screenshot, it’s in the database/migrations folder.

7

Thanks!
To resolve it I had to completely comment out these four blocks:

image
image2370×1262 470 KB

After that the migrate command was running through:

image
image1920×896 185 KB

And now I can also save my changes in the invoice design as well :slight_smile:

Thanks for your help!

BR,
Fabian

8

Glad to hear it, thanks for the update!