Hi
I get the following error messages in laravel-error.log.
[2017-11-25 09:20:32] production.ERROR: Illuminate\Database\QueryException [42S21] : /srv/www/vhosts/mydomain.com/subdomains/invoice/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 729] => SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘company_id’ (SQL: alter table lookup_companies add company_id int unsigned not null) {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“url”:“http://mydomain.com/update",“previous”:“http://mydomain.com”,“user_agent”:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36”,“ip”:“10.9.0.6”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”} []
[2017-11-25 09:20:38] production.ERROR: Illuminate\Database\QueryException [42S21] : /srv/www/vhosts/mydomain.com/subdomains/invoice/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 729] => SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘company_id’ (SQL: alter table lookup_companies add company_id int unsigned not null) {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“GET”,“url”:“http://mydomain.com/update",“previous”:“http://mydomain.com”,“user_agent”:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36”,“ip”:“10.9.0.6”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”} []
[2017-11-25 09:20:47] production.ERROR: Illuminate\Contracts\Encryption\DecryptException [0] : /srv/www/vhosts/mydomain.com/subdomains/invoice/bootstrap/cache/compiled.php [Line 13310] => The MAC is invalid. {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“Stefan”,“method”:“POST”,“url”:“http://mydomain.com/login",“previous”:“http://mydomain.com/login”,“user_agent”:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36”,“ip”:“10.9.0.6”,“count”:2,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”} []
[2017-11-25 09:20:51] production.ERROR: Illuminate\Database\QueryException [42S22] : /srv/www/vhosts/mydomain.com/subdomains/invoice/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 729] => SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘invoices.partial_due_date’ in ‘field list’ (SQL: select coalesce(invoices.partial_due_date, invoices.due_date) due_date, invoices.balance, invoices.public_id, invoices.invoice_number, clients.name as client_name, contacts.email, contacts.first_name, contacts.last_name, clients.currency_id, clients.public_id as client_public_id, clients.user_id as client_user_id, invoice_type_id from invoices left join clients on clients.id = invoices.client_id left join contacts on contacts.client_id = clients.id where invoices.account_id = 1 and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = 0 and invoices.quote_invoice_id is null and invoices.balance > 0 and invoices.is_deleted = 0 and invoices.deleted_at is null and invoices.is_public = 1 and contacts.is_primary = 1 and coalesce(invoices.partial_due_date, invoices.due_date) < 2017-11-25 order by invoices.due_date asc limit 50) {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“Stefan”,“method”:“GET”,“url”:“http://mydomain.com/dashboard",“previous”:“http://mydomain.com”,“user_agent”:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36”,“ip”:“10.9.0.6”,“count”:3,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”} []
I tried to reset the database with:
php artisan migrate:reset
php artisan migrate --seed
and deleted all cache with:
php artisan clear-compiled
php artisan cache:clear
php artisan config:clear
php artisan view:clear
but nothinhg works…
When I try to run /update the I get the following error message in browser:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘company_id’ (SQL: alter table lookup_companies add company_id int unsigned not null)
Can anybody help me with this problem?