error after updating to the latest 4.01

Self-Hosted | v4/Legacy
1

Whoops, looks like something went wrong.
3/3
QueryException in Connection.php line 770:
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-12-24 order by invoices.due_date asc limit 50)
in Connection.php line 770
at Connection->runQueryCallback(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), object(Closure)) in Connection.php line 726
at Connection->run(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), object(Closure)) in Connection.php line 351
at Connection->select(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), true) in Builder.php line 1648
at Builder->runSelect() in Builder.php line 1634
at Builder->get() in DashboardRepository.php line 321
at DashboardRepository->pastDue(‘1’, ‘1’, true) in DashboardController.php line 39
at DashboardController->index()
at call_user_func_array(array(object(DashboardController), ‘index’), array()) in compiled.php line 9584
at Controller->callAction(‘index’, array()) in compiled.php line 9611
at ControllerDispatcher->dispatch(object(Route), object(DashboardController), ‘index’) in compiled.php line 8665
at Route->runController() in compiled.php line 8646
at Route->run(object(Request)) in compiled.php line 8355
at Router->Illuminate\Routing{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 103
at Authenticate->handle(object(Request), object(Closure), ‘user’) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DatabaseLookup.php line 20
at DatabaseLookup->handle(object(Request), object(Closure), ‘user’) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 220
at StartupCheck->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in QueryLogging.php line 32
at QueryLogging->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41
at DuplicateSubmissionCheck->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3312
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 44
at VerifyCsrfToken->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13749
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 12155
at StartSession->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13495
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13432
at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 10054
at Pipeline->then(object(Closure)) in compiled.php line 8356
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8347
at Router->dispatchToRoute(object(Request)) in compiled.php line 8338
at Router->dispatch(object(Request)) in compiled.php line 2575
at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 51
at Debugbar->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3374
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in HandlePreflight.php line 46
at HandlePreflight->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 10054
at Pipeline->then(object(Closure)) in compiled.php line 2519
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2503
at Kernel->handle(object(Request)) in index.php line 51
2/3
PDOException in PDOConnection.php line 79:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘invoices.partial_due_date’ in ‘field list’
in PDOConnection.php line 79
at PDOConnection->prepare(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’) in Connection.php line 333
at Connection->Illuminate\Database{closure}(object(MySqlConnection), ‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’)) in Connection.php line 763
at Connection->runQueryCallback(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), object(Closure)) in Connection.php line 726
at Connection->run(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), object(Closure)) in Connection.php line 351
at Connection->select(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), true) in Builder.php line 1648
at Builder->runSelect() in Builder.php line 1634
at Builder->get() in DashboardRepository.php line 321
at DashboardRepository->pastDue(‘1’, ‘1’, true) in DashboardController.php line 39
at DashboardController->index()
at call_user_func_array(array(object(DashboardController), ‘index’), array()) in compiled.php line 9584
at Controller->callAction(‘index’, array()) in compiled.php line 9611
at ControllerDispatcher->dispatch(object(Route), object(DashboardController), ‘index’) in compiled.php line 8665
at Route->runController() in compiled.php line 8646
at Route->run(object(Request)) in compiled.php line 8355
at Router->Illuminate\Routing{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 103
at Authenticate->handle(object(Request), object(Closure), ‘user’) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DatabaseLookup.php line 20
at DatabaseLookup->handle(object(Request), object(Closure), ‘user’) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 220
at StartupCheck->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in QueryLogging.php line 32
at QueryLogging->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41
at DuplicateSubmissionCheck->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3312
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 44
at VerifyCsrfToken->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13749
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 12155
at StartSession->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13495
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13432
at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 10054
at Pipeline->then(object(Closure)) in compiled.php line 8356
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8347
at Router->dispatchToRoute(object(Request)) in compiled.php line 8338
at Router->dispatch(object(Request)) in compiled.php line 2575
at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 51
at Debugbar->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3374
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in HandlePreflight.php line 46
at HandlePreflight->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 10054
at Pipeline->then(object(Closure)) in compiled.php line 2519
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2503
at Kernel->handle(object(Request)) in index.php line 51
1/3
PDOException in PDOConnection.php line 77:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘invoices.partial_due_date’ in ‘field list’
in PDOConnection.php line 77
at PDO->prepare(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array()) in PDOConnection.php line 77
at PDOConnection->prepare(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’) in Connection.php line 333
at Connection->Illuminate\Database{closure}(object(MySqlConnection), ‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’)) in Connection.php line 763
at Connection->runQueryCallback(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), object(Closure)) in Connection.php line 726
at Connection->run(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), object(Closure)) in Connection.php line 351
at Connection->select(‘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 = ? and clients.deleted_at is null and contacts.deleted_at is null and invoices.is_recurring = ? and invoices.quote_invoice_id is null and invoices.balance > ? and invoices.is_deleted = ? and invoices.deleted_at is null and invoices.is_public = ? and contacts.is_primary = ? and coalesce(invoices.partial_due_date, invoices.due_date) < ? order by invoices.due_date asc limit 50’, array(‘1’, false, ‘0’, false, true, true, ‘2017-12-24’), true) in Builder.php line 1648
at Builder->runSelect() in Builder.php line 1634
at Builder->get() in DashboardRepository.php line 321
at DashboardRepository->pastDue(‘1’, ‘1’, true) in DashboardController.php line 39
at DashboardController->index()
at call_user_func_array(array(object(DashboardController), ‘index’), array()) in compiled.php line 9584
at Controller->callAction(‘index’, array()) in compiled.php line 9611
at ControllerDispatcher->dispatch(object(Route), object(DashboardController), ‘index’) in compiled.php line 8665
at Route->runController() in compiled.php line 8646
at Route->run(object(Request)) in compiled.php line 8355
at Router->Illuminate\Routing{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 103
at Authenticate->handle(object(Request), object(Closure), ‘user’) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DatabaseLookup.php line 20
at DatabaseLookup->handle(object(Request), object(Closure), ‘user’) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 220
at StartupCheck->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in QueryLogging.php line 32
at QueryLogging->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41
at DuplicateSubmissionCheck->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3312
at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 44
at VerifyCsrfToken->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13749
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 12155
at StartSession->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13495
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 13432
at EncryptCookies->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 10054
at Pipeline->then(object(Closure)) in compiled.php line 8356
at Router->runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8347
at Router->dispatchToRoute(object(Request)) in compiled.php line 8338
at Router->dispatch(object(Request)) in compiled.php line 2575
at Kernel->Illuminate\Foundation\Http{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 51
at Debugbar->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 3374
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in HandlePreflight.php line 46
at HandlePreflight->handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline->Illuminate\Pipeline{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing{closure}(object(Request)) in compiled.php line 10054
at Pipeline->then(object(Closure)) in compiled.php line 2519
at Kernel->sendRequestThroughRouter(object(Request)) in compiled.php line 2503
at Kernel->handle(object(Request)) in index.php line 51

2

Try loading /update (or /public/update)

3

I got this…

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘credit_number_counter’ (SQL: alter table accounts add credit_number_counter int null default ‘0’, add credit_number_prefix text null, add credit_number_pattern text null)

4

From the error I think the following migration failed to complete:

database/migrations/2017_06_19_111515_update_dark_mode.php

You may be able to make it work by commenting out the parts that have already run and then reloading /update.

If you want to email us contact@invoiceninja.com with either the log file (storage/logs/laravel-error.log) or a copy of your database from before the upgrade and we can try to debug the problem.

5
...You may be able to make it work by commenting out the parts that have already run and then reloading /update...

Which one do i have to comment and how

6

seems too hard to fix it so i remove the installation (as its not for production yet) and make new installation, php7 and invoiceninja 4.01

now I got this error message…

Whoops, looks like something went wrong.
2/2 ErrorException in Utils.php line 535: number_format() expects parameter 2 to be integer, string given (View: /home/alatprom/public_html/order/resources/views/dashboard.blade.php)

in Utils.php line 535
at CompilerEngine-&gt;handleViewException(object(ErrorException), '0') in compiled.php line 15650
at PhpEngine-&gt;evaluatePath('/home/alatprom/public_html/order/storage/framework/views/59c4d7eac057a92d426872df3adce51fed4440f7.php', array('__env' =&gt; object(Factory), 'app' =&gt; object(Application), 'errors' =&gt; object(ViewErrorBag), 'account' =&gt; object(Account), 'user' =&gt; object(User), 'paidToDate' =&gt; object(Collection), 'balances' =&gt; object(Collection), 'averageInvoice' =&gt; object(Collection), 'invoicesSent' =&gt; '0', 'activeClients' =&gt; '0', 'activities' =&gt; object(Collection), 'pastDue' =&gt; object(Collection), 'upcoming' =&gt; object(Collection), 'payments' =&gt; object(Collection), 'title' =&gt; 'Dasbor', 'hasQuotes' =&gt; false, 'showBreadcrumbs' =&gt; false, 'currencies' =&gt; array('IDR'), 'expenses' =&gt; object(Collection), 'tasks' =&gt; object(Collection), 'showBlueVinePromo' =&gt; false, 'showWhiteLabelExpired' =&gt; false, 'showExpenses' =&gt; false, 'headerClass' =&gt; 'in-thin', 'footerClass' =&gt; 'in-thin')) in compiled.php line 15685
at CompilerEngine-&gt;get('/home/alatprom/public_html/order/resources/views/dashboard.blade.php', array('__env' =&gt; object(Factory), 'app' =&gt; object(Application), 'errors' =&gt; object(ViewErrorBag), 'account' =&gt; object(Account), 'user' =&gt; object(User), 'paidToDate' =&gt; object(Collection), 'balances' =&gt; object(Collection), 'averageInvoice' =&gt; object(Collection), 'invoicesSent' =&gt; '0', 'activeClients' =&gt; '0', 'activities' =&gt; object(Collection), 'pastDue' =&gt; object(Collection), 'upcoming' =&gt; object(Collection), 'payments' =&gt; object(Collection), 'title' =&gt; 'Dasbor', 'hasQuotes' =&gt; false, 'showBreadcrumbs' =&gt; false, 'currencies' =&gt; array('IDR'), 'expenses' =&gt; object(Collection), 'tasks' =&gt; object(Collection), 'showBlueVinePromo' =&gt; false, 'showWhiteLabelExpired' =&gt; false, 'showExpenses' =&gt; false, 'headerClass' =&gt; 'in-thin', 'footerClass' =&gt; 'in-thin')) in compiled.php line 15517
at View-&gt;getContents() in compiled.php line 15505
at View-&gt;renderContents() in compiled.php line 15489
at View-&gt;render() in compiled.php line 16762
at Response-&gt;setContent(object(View)) in compiled.php line 16249
at Response-&gt;__construct(object(View)) in compiled.php line 8509
at Router-&gt;prepareResponse(object(Request), object(View)) in compiled.php line 8355
at Router-&gt;Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 103
at Authenticate-&gt;handle(object(Request), object(Closure), 'user') in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in DatabaseLookup.php line 20
at DatabaseLookup-&gt;handle(object(Request), object(Closure), 'user') in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in StartupCheck.php line 220
at StartupCheck-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in QueryLogging.php line 32
at QueryLogging-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41
at DuplicateSubmissionCheck-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3312
at VerifyCsrfToken-&gt;handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 44
at VerifyCsrfToken-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13749
at ShareErrorsFromSession-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 12155
at StartSession-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13495
at AddQueuedCookiesToResponse-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13432
at EncryptCookies-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 10054
at Pipeline-&gt;then(object(Closure)) in compiled.php line 8356
at Router-&gt;runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8347
at Router-&gt;dispatchToRoute(object(Request)) in compiled.php line 8338
at Router-&gt;dispatch(object(Request)) in compiled.php line 2575
at Kernel-&gt;Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in Debugbar.php line 51
at Debugbar-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3374
at CheckForMaintenanceMode-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in HandlePreflight.php line 46
at HandlePreflight-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 10054
at Pipeline-&gt;then(object(Closure)) in compiled.php line 2519
at Kernel-&gt;sendRequestThroughRouter(object(Request)) in compiled.php line 2503
at Kernel-&gt;handle(object(Request)) in index.php line 51

1/2 ErrorException in Utils.php line 535: number_format() expects parameter 2 to be integer, string given

in Utils.php line 535
at HandleExceptions-&gt;handleError('2', 'number_format() expects parameter 2 to be integer, string given', '/home/alatprom/public_html/order/app/Libraries/Utils.php', '535', array('value' =&gt; '0', 'currencyId' =&gt; '27', 'countryId' =&gt; '360', 'decorator' =&gt; 'symbol', 'currency' =&gt; object(Currency), 'thousand' =&gt; '.', 'decimal' =&gt; ',', 'precision' =&gt; '', 'code' =&gt; 'IDR', 'swapSymbol' =&gt; false))
at number_format('0', '', ',', '.') in Utils.php line 535
at Utils::formatMoney('0') in 59c4d7eac057a92d426872df3adce51fed4440f7.php line 276
at include('/home/alatprom/public_html/order/storage/framework/views/59c4d7eac057a92d426872df3adce51fed4440f7.php') in compiled.php line 15648
at PhpEngine-&gt;evaluatePath('/home/alatprom/public_html/order/storage/framework/views/59c4d7eac057a92d426872df3adce51fed4440f7.php', array('__env' =&gt; object(Factory), 'app' =&gt; object(Application), 'errors' =&gt; object(ViewErrorBag), 'account' =&gt; object(Account), 'user' =&gt; object(User), 'paidToDate' =&gt; object(Collection), 'balances' =&gt; object(Collection), 'averageInvoice' =&gt; object(Collection), 'invoicesSent' =&gt; '0', 'activeClients' =&gt; '0', 'activities' =&gt; object(Collection), 'pastDue' =&gt; object(Collection), 'upcoming' =&gt; object(Collection), 'payments' =&gt; object(Collection), 'title' =&gt; 'Dasbor', 'hasQuotes' =&gt; false, 'showBreadcrumbs' =&gt; false, 'currencies' =&gt; array('IDR'), 'expenses' =&gt; object(Collection), 'tasks' =&gt; object(Collection), 'showBlueVinePromo' =&gt; false, 'showWhiteLabelExpired' =&gt; false, 'showExpenses' =&gt; false, 'headerClass' =&gt; 'in-thin', 'footerClass' =&gt; 'in-thin')) in compiled.php line 15685
at CompilerEngine-&gt;get('/home/alatprom/public_html/order/resources/views/dashboard.blade.php', array('__env' =&gt; object(Factory), 'app' =&gt; object(Application), 'errors' =&gt; object(ViewErrorBag), 'account' =&gt; object(Account), 'user' =&gt; object(User), 'paidToDate' =&gt; object(Collection), 'balances' =&gt; object(Collection), 'averageInvoice' =&gt; object(Collection), 'invoicesSent' =&gt; '0', 'activeClients' =&gt; '0', 'activities' =&gt; object(Collection), 'pastDue' =&gt; object(Collection), 'upcoming' =&gt; object(Collection), 'payments' =&gt; object(Collection), 'title' =&gt; 'Dasbor', 'hasQuotes' =&gt; false, 'showBreadcrumbs' =&gt; false, 'currencies' =&gt; array('IDR'), 'expenses' =&gt; object(Collection), 'tasks' =&gt; object(Collection), 'showBlueVinePromo' =&gt; false, 'showWhiteLabelExpired' =&gt; false, 'showExpenses' =&gt; false, 'headerClass' =&gt; 'in-thin', 'footerClass' =&gt; 'in-thin')) in compiled.php line 15517
at View-&gt;getContents() in compiled.php line 15505
at View-&gt;renderContents() in compiled.php line 15489
at View-&gt;render() in compiled.php line 16762
at Response-&gt;setContent(object(View)) in compiled.php line 16249
at Response-&gt;__construct(object(View)) in compiled.php line 8509
at Router-&gt;prepareResponse(object(Request), object(View)) in compiled.php line 8355
at Router-&gt;Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 103
at Authenticate-&gt;handle(object(Request), object(Closure), 'user') in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in DatabaseLookup.php line 20
at DatabaseLookup-&gt;handle(object(Request), object(Closure), 'user') in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in StartupCheck.php line 220
at StartupCheck-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in QueryLogging.php line 32
at QueryLogging-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41
at DuplicateSubmissionCheck-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3312
at VerifyCsrfToken-&gt;handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 44
at VerifyCsrfToken-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13749
at ShareErrorsFromSession-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 12155
at StartSession-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13495
at AddQueuedCookiesToResponse-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13432
at EncryptCookies-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 10054
at Pipeline-&gt;then(object(Closure)) in compiled.php line 8356
at Router-&gt;runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8347
at Router-&gt;dispatchToRoute(object(Request)) in compiled.php line 8338
at Router-&gt;dispatch(object(Request)) in compiled.php line 2575
at Kernel-&gt;Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in Debugbar.php line 51
at Debugbar-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3374
at CheckForMaintenanceMode-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in HandlePreflight.php line 46
at HandlePreflight-&gt;handle(object(Request), object(Closure)) in compiled.php line 10069
at Pipeline-&gt;Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline-&gt;Illuminate\Routing\{closure}(object(Request)) in compiled.php line 10054
at Pipeline-&gt;then(object(Closure)) in compiled.php line 2519
at Kernel-&gt;sendRequestThroughRouter(object(Request)) in compiled.php line 2503
at Kernel-&gt;handle(object(Request)) in index.php line 51

Please help

7

Oh… I fixed it the issue.

Thank you