Everything else works fine and I can create tasks, invoices, users etc…
But I cannot save changes after editing any company settings, I get a popup which reads:
“Error
500: Server Error”
With 2 buttons “COPY” and “DISMISS”
It is a fresh V5 install (not migrated from 4), I tend to do all the version updates as soon as they come out.
2 versions ago (about 3-4 weeks ago) this problem started.
I’ve tried some things already:
- re-asigning permissions
- php artisan optimize
- php artisan config:cache
- php artisan config:clear
- php artisan clear-compiled
- php artisan optimiz
- chmod -R 775 /var/www/invoiceninja
- chown -R www-data:www-data /var/www/invoiceninja
- I’ve added a new line: “DB_STRICT=false” to the .env file
All these seem to complete properly, but nothing changes…
This other commands returns an error tho:
php /var/www/invoiceninja/artisan migrate
APPLICATION IN PRODUCTION.
Do you really wish to run this command? (yes/no) [no]
❯ yes
INFO Running migrations.
2023_04_27_045639_add_kmher_language … 12ms FAIL
In Connection.php line 760:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP COLUMN enable_e_invoice
; check that it exists (SQL: alter table companies
drop e nable_e_invoice
)
In Connection.php line 545:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP COLUMN enable_e_invoice
; check that it exists
For some reason, it seems that:
2023_04_27_045639_add_kmher_language … 12ms FAIL
and then I also get:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP COLUMN enable_e_invoice
; check that it exists
I’ve tried to
php artisan migrate:refresh
php artisan migrate
php artisan migrate:fresh
And it was able to reinstall everything just fine, but I ended with an empty database, so I had to roll back…
Any help or pointers greatly appreciated.