Hello…
I hope this is a quick fix, and I am not wasting anybody’s time.
I have had a problem with upgrading my Softaculous installation of Invoice ninja for a while.
every time I upgrade through the various versions I get the good old
“Whoops, looks like something went wrong.”
Whoops, looks like something went wrong. QueryException in Connection.php line 725: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoices.invoice_type_id' in 'where clause' (SQL: select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= 1 andclients
.is_deleted
= 0 andinvoices
.is_deleted
= 0 andinvoices
.is_recurring
= 0 andinvoices
.invoice_type_id
= 1 group byaccounts
.id
limit 1) 1. in Connection.php line 725 2. at Connection> runQueryCallback('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 681 3. at Connection> run('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 347 4. at Connection> select('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1'), true) in Builder.php line 1583 5. at Builder> runSelect() in Builder.php line 1569 6. at Builder> get(array('*')) in Builder.php line 1550 7. at Builder> first() in DashboardController.php line 50 8. at DashboardController> index() 9. at call_user_func_array(array(object(DashboardController), 'index'), array()) in compiled.php line 9479 10. at Controller> callAction('index', array()) in compiled.php line 9541 11. at ControllerDispatcher> call(object(DashboardController), object(Route), 'index') in compiled.php line 9521 12. at ControllerDispatcher> Illuminate\Routing\{closure}(object(Request)) 13. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 14. at Pipeline> Illuminate\Routing\{closure}(object(Request)) 15. at call_user_func(object(Closure), object(Request)) in compiled.php line 10004 16. at Pipeline> then(object(Closure)) in compiled.php line 9522 17. at ControllerDispatcher> callWithinStack(object(DashboardController), object(Route), object(Request), 'index') in compiled.php line 9509 18. at ControllerDispatcher> dispatch(object(Route), object(Request), 'App\Http\Controllers\DashboardController', 'index') in compiled.php line 8579 19. at Route> runController(object(Request)) in compiled.php line 8566 20. at Route> run(object(Request)) in compiled.php line 8280 21. at Router> Illuminate\Routing\{closure}(object(Request)) 22. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 23. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 90 24. at Authenticate> handle(object(Request), object(Closure), 'user') 25. at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure), 'user')) in compiled.php line 10019 26. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 27. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 28. at Pipeline> Illuminate\Routing\{closure}(object(Request)) 29. at call_user_func(object(Closure), object(Request)) in compiled.php line 10004 30. at Pipeline> then(object(Closure)) in compiled.php line 8281 31. at Router> runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8272 32. at Router> dispatchToRoute(object(Request)) in compiled.php line 8262 33. at Router> dispatch(object(Request)) in compiled.php line 2419 34. at Kernel> Illuminate\Foundation\Http\{closure}(object(Request)) 35. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 36. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in Debugbar.php line 49 37. at Debugbar> handle(object(Request), object(Closure)) 38. at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 39. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 40. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 41. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in StartupCheck.php line 193 42. at StartupCheck> handle(object(Request), object(Closure)) 43. at call_user_func_array(array(object(StartupCheck), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 44. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 45. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 1/2 at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 46. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in QueryLogging.php line 28 47. at QueryLogging> handle(object(Request), object(Closure)) 48. at call_user_func_array(array(object(QueryLogging), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 49. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 50. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 51. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41 52. at DuplicateSubmissionCheck> handle(object(Request), object(Closure)) 53. at call_user_func_array(array(object(DuplicateSubmissionCheck), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 54. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 55. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 56. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3225 57. at VerifyCsrfToken> handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 51 58. at VerifyCsrfToken> handle(object(Request), object(Closure)) 59. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 60. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 61. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 62. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13517 63. at ShareErrorsFromSession> handle(object(Request), object(Closure)) 64. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 65. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 66. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 67. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 12010 68. at StartSession> handle(object(Request), object(Closure)) 69. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 70. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 71. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 72. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13256 73. at AddQueuedCookiesToResponse> handle(object(Request), object(Closure)) 74. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 75. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 76. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 77. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13193 78. at EncryptCookies> handle(object(Request), object(Closure)) 79. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 80. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 81. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 82. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3286 83. at CheckForMaintenanceMode> handle(object(Request), object(Closure)) 84. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 85. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 86. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 87. at Pipeline> Illuminate\Routing\{closure}(object(Request)) 88. at call_user_func(object(Closure), object(Request)) in compiled.php line 10004 89. at Pipeline> then(object(Closure)) in compiled.php line 2366 90. at Kernel> sendRequestThroughRouter(object(Request)) in compiled.php line 2350 91. at Kernel> handle(object(Request)) in index.php line 52 PDOException in Connection.php line 333: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invoices.invoice_type_id' in 'where clause' 1. in Connection.php line 333 2. at PDO> prepare('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1') in Connection.php line 333 3. at Connection> Illuminate\Database\{closure}(object(MySqlConnection), 'select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1')) in Connection.php line 718 4. at Connection> runQueryCallback('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 681 5. at Connection> run('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 347 6. at Connection> select('select COUNT(DISTINCT CASE WHENinvoices
.id
IS NOT NULL THENclients
.id
ELSE null END) billed_clients, SUM(CASE WHENinvoices
.invoice_status_id
>= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCTclients
.id
) active_clients fromaccounts
left joinclients
onaccounts
.id
=clients
.account_id
left joininvoices
onclients
.id
=invoices
.client_id
whereaccounts
.id
= ? andclients
.is_deleted
= ? andinvoices
.is_deleted
= ? andinvoices
.is_recurring
= ? andinvoices
.invoice_type_id
= ? group byaccounts
.id
limit 1', array('1', false, false, false, '1'), true) in Builder.php line 1583 7. at Builder> runSelect() in Builder.php line 1569 8. at Builder> get(array('*')) in Builder.php line 1550 9. at Builder> first() in DashboardController.php line 50 10. at DashboardController> index() 11. at call_user_func_array(array(object(DashboardController), 'index'), array()) in compiled.php line 9479 12. at Controller> callAction('index', array()) in compiled.php line 9541 13. at ControllerDispatcher> call(object(DashboardController), object(Route), 'index') in compiled.php line 9521 14. at ControllerDispatcher> Illuminate\Routing\{closure}(object(Request)) 15. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 16. at Pipeline> Illuminate\Routing\{closure}(object(Request)) 17. at call_user_func(object(Closure), object(Request)) in compiled.php line 10004 18. at Pipeline> then(object(Closure)) in compiled.php line 9522 19. at ControllerDispatcher> callWithinStack(object(DashboardController), object(Route), object(Request), 'index') in compiled.php line 9509 20. at ControllerDispatcher> dispatch(object(Route), object(Request), 'App\Http\Controllers\DashboardController', 'index') in compiled.php line 8579 21. at Route> runController(object(Request)) in compiled.php line 8566 22. at Route> run(object(Request)) in compiled.php line 8280 23. at Router> Illuminate\Routing\{closure}(object(Request)) 24. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 25. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 90 26. at Authenticate> handle(object(Request), object(Closure), 'user') 27. at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure), 'user')) in compiled.php line 10019 28. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 29. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 30. at Pipeline> Illuminate\Routing\{closure}(object(Request)) 31. at call_user_func(object(Closure), object(Request)) in compiled.php line 10004 32. at Pipeline> then(object(Closure)) in compiled.php line 8281 33. at Router> runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8272 34. at Router> dispatchToRoute(object(Request)) in compiled.php line 8262 35. at Router> dispatch(object(Request)) in compiled.php line 2419 36. at Kernel> Illuminate\Foundation\Http\{closure}(object(Request)) 37. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52 38. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in Debugbar.php line 49 39. at Debugbar> handle(object(Request), object(Closure)) 40. at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 41. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 42. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 43. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in StartupCheck.php line 193 44. at StartupCheck> handle(object(Request), object(Closure)) 45. at call_user_func_array(array(object(StartupCheck), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 46. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 47. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 48. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in QueryLogging.php line 28 49. at QueryLogging> handle(object(Request), object(Closure)) 50. at call_user_func_array(array(object(QueryLogging), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 51. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 52. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 53. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in DuplicateSubmissionCheck.php line 41 54. at DuplicateSubmissionCheck> handle(object(Request), object(Closure)) 55. at call_user_func_array(array(object(DuplicateSubmissionCheck), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 56. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 57. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 58. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3225 59. at VerifyCsrfToken> handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 51 60. at VerifyCsrfToken> handle(object(Request), object(Closure)) 61. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 62. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 63. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 64. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13517 65. at ShareErrorsFromSession> handle(object(Request), object(Closure)) 66. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 67. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 68. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 69. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 12010 70. at StartSession> handle(object(Request), object(Closure)) 71. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 72. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 73. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 74. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13256 75. at AddQueuedCookiesToResponse> handle(object(Request), object(Closure)) 76. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 77. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 78. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 79. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 13193 80. at EncryptCookies> handle(object(Request), object(Closure)) 81. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 82. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 83. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 84. at Pipeline> Illuminate\Routing\{closure}(object(Request)) in compiled.php line 3286 85. at CheckForMaintenanceMode> handle(object(Request), object(Closure)) 86. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in compiled.php line 10019 87. at Pipeline> Illuminate\Pipeline\{closure}(object(Request)) 88. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32 89. at Pipeline> Illuminate\Routing\{closure}(object(Request)) 90. at call_user_func(object(Closure), object(Request)) in compiled.php line 10004 91. at Pipeline> then(object(Closure)) in compiled.php line 2366 92. at Kernel> sendRequestThroughRouter(object(Request)) in compiled.php line 2350 93. at Kernel> handle(object(Request)) in index.php line 52
I have also discovered that I can not change any of the invoice design settings in advanced settings without be booted with a similar error.
Whoops, looks like something went wrong.
2/2
QueryException in Connection.php line 669:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘page_size’ in ‘field list’ (SQL: update
accounts
setupdated_at
= 20160905 04:56:52,hide_quantity
= 1,
hide_paid_to_date
= 0,invoice_labels
=
{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"",“partial_due”:""},
all_pages_footer
= 0,all_pages_header
= 0,
invoice_embed_documents
= 1,page_size
= A4,live_preview
= 0 whereid
= 1)
- in Connection.php line 669
- at Connection>runQueryCallback(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
=
?,all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’), object(Closure)) in Connection.php
line 629- at Connection>run(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
= ?,
all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’), object(Closure)) in Connection.php
line 434- at Connection>affectingStatement(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
=
?,all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’)) in Connection.php line 377- at Connection>update(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
= ?,
all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’)) in Builder.php line 1904- at Builder>update(array(‘updated_at’ => ‘20160905 04:56:52’, ‘hide_quantity’ => true,
‘hide_paid_to_date’ => false, ‘invoice_labels’ =>
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, ‘all_pages_footer’ => false, ‘all_pages_header’ => false,
‘invoice_embed_documents’ => true, ‘page_size’ => ‘A4’, ‘live_preview’ => false)) in Builder.php
line 476- at Builder>update(array(‘updated_at’ => ‘20160905 04:56:52’, ‘hide_quantity’ => true,
‘hide_paid_to_date’ => false, ‘invoice_labels’ =>
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, ‘all_pages_footer’ => false, ‘all_pages_header’ => false,
‘invoice_embed_documents’ => true, ‘page_size’ => ‘A4’, ‘live_preview’ => false)) in compiled.php
line 10734- at Model>performUpdate(object(Builder), array()) in compiled.php line 10699
- at Model>save() in AccountController.php line 984
- at AccountController>saveInvoiceDesign() in AccountController.php line 679
- at AccountController>doSection(‘invoice_design’)
- at call_user_func_array(array(object(AccountController), ‘doSection’), array(‘section’ =>
‘invoice_design’)) in compiled.php line 9333- at Controller>callAction(‘doSection’, array(‘section’ => ‘invoice_design’)) in compiled.php
line 9395- at ControllerDispatcher>call(object(AccountController), object(Route), ‘doSection’) in
compiled.php line 9375- at ControllerDispatcher>Illuminate\Routing{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline>Illuminate\Routing{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
- at Pipeline>then(object(Closure)) in compiled.php line 9376
- at ControllerDispatcher>callWithinStack(object(AccountController), object(Route),
object(Request), ‘doSection’) in compiled.php line 9363- at ControllerDispatcher>dispatch(object(Route), object(Request),
‘App\Http\Controllers\AccountController’, ‘doSection’) in compiled.php line 8450- at Route>runController(object(Request)) in compiled.php line 8437
- at Route>run(object(Request)) in compiled.php line 8151
- at Router>Illuminate\Routing{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in PermissionsRequired.php line 44
- at PermissionsRequired>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(PermissionsRequired), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 69
- at Authenticate>handle(object(Request), object(Closure), ‘user’)
- at call_user_func_array(array(object(Authenticate), ‘handle’), array(object(Request),
object(Closure), ‘user’)) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
- at Pipeline>then(object(Closure)) in compiled.php line 8152
- at Router>runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8143
- at Router>dispatchToRoute(object(Request)) in compiled.php line 8133
- at Router>dispatch(object(Request)) in compiled.php line 2391
- at Kernel>Illuminate\Foundation\Http{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
- at Debugbar>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(Debugbar), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 190
- at StartupCheck>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(StartupCheck), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line
33- at DuplicateSubmissionCheck>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(DuplicateSubmissionCheck), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3163
- at VerifyCsrfToken>handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 43
- at VerifyCsrfToken>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 13290
- at ShareErrorsFromSession>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 11846
- at StartSession>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 13029
- at AddQueuedCookiesToResponse>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 12966
- at EncryptCookies>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3224
- at CheckForMaintenanceMode>handle(object(Request), object(Closure))
- at call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862- at Pipeline>Illuminate\Pipeline{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
- at Pipeline>Illuminate\Routing{closure}(object(Request))
- at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
- at Pipeline>then(object(Closure)) in compiled.php line 2338
- at Kernel>sendRequestThroughRouter(object(Request)) in compiled.php line 2322
- at Kernel>handle(object(Request)) in index.php line 53
1/2
PDOException in Connection.php line 429:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘page_size’ in ‘field list’
in Connection.php line 429
at PDO>prepare(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
= ?,
all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’) in Connection.php line 429at Connection>Illuminate\Database{closure}(object(MySqlConnection), ‘update
accounts
set
updated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
= ?,all_pages_footer
= ?,all_pages_header
= ?,
invoice_embed_documents
= ?,page_size
= ?,live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’)) in Connection.php line 662at Connection>runQueryCallback(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
=
?,all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’), object(Closure)) in Connection.php
line 629at Connection>run(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
= ?,
all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’), object(Closure)) in Connection.php
line 434at Connection>affectingStatement(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
=
?,all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’)) in Connection.php line 377at Connection>update(‘update
accounts
setupdated_at
= ?,hide_quantity
= ?,
hide_paid_to_date
= ?,invoice_labels
= ?,
all_pages_footer
= ?,all_pages_header
= ?,invoice_embed_documents
= ?,page_size
= ?,
live_preview
= ? whereid
= ?’, array(‘20160905 04:56:52’, true, false,
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, false, false, true, ‘A4’, false, ‘1’)) in Builder.php line 1904at Builder>update(array(‘updated_at’ => ‘20160905 04:56:52’, ‘hide_quantity’ => true,
‘hide_paid_to_date’ => false, ‘invoice_labels’ =>
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, ‘all_pages_footer’ => false, ‘all_pages_header’ => false,
‘invoice_embed_documents’ => true, ‘page_size’ => ‘A4’, ‘live_preview’ => false)) in Builder.php
line 476at Builder>update(array(‘updated_at’ => ‘20160905 04:56:52’, ‘hide_quantity’ => true,
‘hide_paid_to_date’ => false, ‘invoice_labels’ =>
‘{“item”:"",“description”:"",“unit_cost”:"",“quantity”:"",“line_total”:"",“terms”:"",“balance_due”:"
“,“partial_due”:”"}’, ‘all_pages_footer’ => false, ‘all_pages_header’ => false,
‘invoice_embed_documents’ => true, ‘page_size’ => ‘A4’, ‘live_preview’ => false)) in compiled.php
line 10734at Model>performUpdate(object(Builder), array()) in compiled.php line 10699
at Model>save() in AccountController.php line 984
at AccountController>saveInvoiceDesign() in AccountController.php line 679
at AccountController>doSection(‘invoice_design’)
at call_user_func_array(array(object(AccountController), ‘doSection’), array(‘section’ =>
‘invoice_design’)) in compiled.php line 9333at Controller>callAction(‘doSection’, array(‘section’ => ‘invoice_design’)) in compiled.php
line 9395at ControllerDispatcher>call(object(AccountController), object(Route), ‘doSection’) in
compiled.php line 9375at ControllerDispatcher>Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline>Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline>then(object(Closure)) in compiled.php line 9376
at ControllerDispatcher>callWithinStack(object(AccountController), object(Route),
object(Request), ‘doSection’) in compiled.php line 9363at ControllerDispatcher>dispatch(object(Route), object(Request),
‘App\Http\Controllers\AccountController’, ‘doSection’) in compiled.php line 8450at Route>runController(object(Request)) in compiled.php line 8437
at Route>run(object(Request)) in compiled.php line 8151
at Router>Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline>Illuminate\Routing{closure}(object(Request)) in PermissionsRequired.php line 44
at PermissionsRequired>handle(object(Request), object(Closure))
at call_user_func_array(array(object(PermissionsRequired), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 69
at Authenticate>handle(object(Request), object(Closure), ‘user’)
at call_user_func_array(array(object(Authenticate), ‘handle’), array(object(Request),
object(Closure), ‘user’)) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline>then(object(Closure)) in compiled.php line 8152
at Router>runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8143
at Router>dispatchToRoute(object(Request)) in compiled.php line 8133
at Router>dispatch(object(Request)) in compiled.php line 2391
at Kernel>Illuminate\Foundation\Http{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
at Pipeline>Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
at Debugbar>handle(object(Request), object(Closure))
at call_user_func_array(array(object(Debugbar), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 190
at StartupCheck>handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartupCheck), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line
33at DuplicateSubmissionCheck>handle(object(Request), object(Closure))
at call_user_func_array(array(object(DuplicateSubmissionCheck), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3163
at VerifyCsrfToken>handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 43
at VerifyCsrfToken>handle(object(Request), object(Closure))
at call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 13290
at ShareErrorsFromSession>handle(object(Request), object(Closure))
at call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 11846
at StartSession>handle(object(Request), object(Closure))
at call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 13029
at AddQueuedCookiesToResponse>handle(object(Request), object(Closure))
at call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 12966
at EncryptCookies>handle(object(Request), object(Closure))
at call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request),
object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3224
at CheckForMaintenanceMode>handle(object(Request), object(Closure))
at call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’),
array(object(Request), object(Closure))) in compiled.php line 9862at Pipeline>Illuminate\Pipeline{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
at Pipeline>Illuminate\Routing{closure}(object(Request))
at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
at Pipeline>then(object(Closure)) in compiled.php line 2338
at Kernel>sendRequestThroughRouter(object(Request)) in compiled.php line 2322
at Kernel>handle(object(Request)) in index.php line 53
I have only recently discovered the tick box for debuging and now have some meaty data to present for troubleshooting (I hope).
Does anyone have any ideas that could set me on my way ?
Thanks
Cyberone