Whoops, looks like something went wrong. When upgrading from 2.5.2.2

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 WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = 1 and clients.is_deleted = 0 and invoices.is_deleted = 0 and invoices.is_recurring = 0 and invoices.invoice_type_id = 1 group by accounts.id limit 1) 1. in Connection.php line 725 2. at Connection> runQueryCallback('select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.id limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 681 3. at Connection> run('select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.id limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 347 4. at Connection> select('select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.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 WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.id limit 1') in Connection.php line 333 3. at Connection> Illuminate\Database\{closure}(object(MySqlConnection), 'select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.id limit 1', array('1', false, false, false, '1')) in Connection.php line 718 4. at Connection> runQueryCallback('select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.id limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 681 5. at Connection> run('select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.id limit 1', array('1', false, false, false, '1'), object(Closure)) in Connection.php line 347 6. at Connection> select('select COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients, SUM(CASE WHEN invoices.invoice_status_id >= 2 THEN 1 ELSE 0 END) invoices_sent, COUNT(DISTINCT clients.id) active_clients from accounts left join clients on accounts.id = clients.account_id left join invoices on clients.id = invoices.client_id where accounts.id = ? and clients.is_deleted = ? and invoices.is_deleted = ? and invoices.is_recurring = ? and invoices.invoice_type_id = ? group by accounts.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 set updated_at = 2016­09­05 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 where id = 1)

  1. in Connection.php line 669
  2. at Connection­>runQueryCallback(‘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 = ? where id = ?’, array(‘2016­09­05 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
  3. at Connection­>run(‘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 = ? where id = ?’, array(‘2016­09­05 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
  4. at Connection­>affectingStatement(‘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 = ? where id = ?’, array(‘2016­09­05 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
  5. at Connection­>update(‘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 = ? where id = ?’, array(‘2016­09­05 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
  6. at Builder­>update(array(‘updated_at’ => ‘2016­09­05 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
  7. at Builder­>update(array(‘updated_at’ => ‘2016­09­05 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
  8. at Model­>performUpdate(object(Builder), array()) in compiled.php line 10699
  9. at Model­>save() in AccountController.php line 984
  10. at AccountController­>saveInvoiceDesign() in AccountController.php line 679
  11. at AccountController­>doSection(‘invoice_design’)
  12. at call_user_func_array(array(object(AccountController), ‘doSection’), array(‘section’ =>
    ‘invoice_design’)) in compiled.php line 9333
  13. at Controller­>callAction(‘doSection’, array(‘section’ => ‘invoice_design’)) in compiled.php
    line 9395
  14. at ControllerDispatcher­>call(object(AccountController), object(Route), ‘doSection’) in
    compiled.php line 9375
  15. at ControllerDispatcher­>Illuminate\Routing{closure}(object(Request))
  16. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  17. at Pipeline­>Illuminate\Routing{closure}(object(Request))
  18. at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
  19. at Pipeline­>then(object(Closure)) in compiled.php line 9376
  20. at ControllerDispatcher­>callWithinStack(object(AccountController), object(Route),
    object(Request), ‘doSection’) in compiled.php line 9363
  21. at ControllerDispatcher­>dispatch(object(Route), object(Request),
    ‘App\Http\Controllers\AccountController’, ‘doSection’) in compiled.php line 8450
  22. at Route­>runController(object(Request)) in compiled.php line 8437
  23. at Route­>run(object(Request)) in compiled.php line 8151
  24. at Router­>Illuminate\Routing{closure}(object(Request))
  25. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  26. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in PermissionsRequired.php line 44
  27. at PermissionsRequired­>handle(object(Request), object(Closure))
  28. at call_user_func_array(array(object(PermissionsRequired), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862
  29. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  30. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  31. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 69
  32. at Authenticate­>handle(object(Request), object(Closure), ‘user’)
  33. at call_user_func_array(array(object(Authenticate), ‘handle’), array(object(Request),
    object(Closure), ‘user’)) in compiled.php line 9862
  34. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  35. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  36. at Pipeline­>Illuminate\Routing{closure}(object(Request))
  37. at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
  38. at Pipeline­>then(object(Closure)) in compiled.php line 8152
  39. at Router­>runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8143
  40. at Router­>dispatchToRoute(object(Request)) in compiled.php line 8133
  41. at Router­>dispatch(object(Request)) in compiled.php line 2391
  42. at Kernel­>Illuminate\Foundation\Http{closure}(object(Request))
  43. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  44. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49
  45. at Debugbar­>handle(object(Request), object(Closure))
  46. at call_user_func_array(array(object(Debugbar), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862
  47. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  48. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  49. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in StartupCheck.php line 190
  50. at StartupCheck­>handle(object(Request), object(Closure))
  51. at call_user_func_array(array(object(StartupCheck), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862
  52. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  53. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  54. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in DuplicateSubmissionCheck.php line
    33
  55. at DuplicateSubmissionCheck­>handle(object(Request), object(Closure))
  56. at call_user_func_array(array(object(DuplicateSubmissionCheck), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862
  57. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  58. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  59. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3163
  60. at VerifyCsrfToken­>handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 43
  61. at VerifyCsrfToken­>handle(object(Request), object(Closure))
  62. at call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862
  63. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  64. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  65. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 13290
  66. at ShareErrorsFromSession­>handle(object(Request), object(Closure))
  67. at call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862
  68. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  69. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  70. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 11846
  71. at StartSession­>handle(object(Request), object(Closure))
  72. at call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862
  73. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  74. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  75. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 13029
  76. at AddQueuedCookiesToResponse­>handle(object(Request), object(Closure))
  77. at call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862
  78. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  79. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  80. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 12966
  81. at EncryptCookies­>handle(object(Request), object(Closure))
  82. at call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862
  83. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  84. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  85. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3224
  86. at CheckForMaintenanceMode­>handle(object(Request), object(Closure))
  87. at call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862
  88. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))
  89. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  90. at Pipeline­>Illuminate\Routing{closure}(object(Request))
  91. at call_user_func(object(Closure), object(Request)) in compiled.php line 9852
  92. at Pipeline­>then(object(Closure)) in compiled.php line 2338
  93. at Kernel­>sendRequestThroughRouter(object(Request)) in compiled.php line 2322
  94. 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’

  1. in Connection.php line 429

  2. at PDO­>prepare(‘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 = ? where id = ?’) in Connection.php line 429

  3. at 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 = ? where id = ?’, array(‘2016­09­05 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 662

  4. at Connection­>runQueryCallback(‘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 = ? where id = ?’, array(‘2016­09­05 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

  5. at Connection­>run(‘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 = ? where id = ?’, array(‘2016­09­05 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

  6. at Connection­>affectingStatement(‘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 = ? where id = ?’, array(‘2016­09­05 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

  7. at Connection­>update(‘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 = ? where id = ?’, array(‘2016­09­05 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

  8. at Builder­>update(array(‘updated_at’ => ‘2016­09­05 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

  9. at Builder­>update(array(‘updated_at’ => ‘2016­09­05 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

  10. at Model­>performUpdate(object(Builder), array()) in compiled.php line 10699

  11. at Model­>save() in AccountController.php line 984

  12. at AccountController­>saveInvoiceDesign() in AccountController.php line 679

  13. at AccountController­>doSection(‘invoice_design’)

  14. at call_user_func_array(array(object(AccountController), ‘doSection’), array(‘section’ =>
    ‘invoice_design’)) in compiled.php line 9333

  15. at Controller­>callAction(‘doSection’, array(‘section’ => ‘invoice_design’)) in compiled.php
    line 9395

  16. at ControllerDispatcher­>call(object(AccountController), object(Route), ‘doSection’) in
    compiled.php line 9375

  17. at ControllerDispatcher­>Illuminate\Routing{closure}(object(Request))

  18. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52

  19. at Pipeline­>Illuminate\Routing{closure}(object(Request))

  20. at call_user_func(object(Closure), object(Request)) in compiled.php line 9852

  21. at Pipeline­>then(object(Closure)) in compiled.php line 9376

  22. at ControllerDispatcher­>callWithinStack(object(AccountController), object(Route),
    object(Request), ‘doSection’) in compiled.php line 9363

  23. at ControllerDispatcher­>dispatch(object(Route), object(Request),
    ‘App\Http\Controllers\AccountController’, ‘doSection’) in compiled.php line 8450

  24. at Route­>runController(object(Request)) in compiled.php line 8437

  25. at Route­>run(object(Request)) in compiled.php line 8151

  26. at Router­>Illuminate\Routing{closure}(object(Request))

  27. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52

  28. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in PermissionsRequired.php line 44

  29. at PermissionsRequired­>handle(object(Request), object(Closure))

  30. at call_user_func_array(array(object(PermissionsRequired), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862

  31. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))

  32. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32

  33. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in Authenticate.php line 69

  34. at Authenticate­>handle(object(Request), object(Closure), ‘user’)

  35. at call_user_func_array(array(object(Authenticate), ‘handle’), array(object(Request),
    object(Closure), ‘user’)) in compiled.php line 9862

  36. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))

  37. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32

  38. at Pipeline­>Illuminate\Routing{closure}(object(Request))

  39. at call_user_func(object(Closure), object(Request)) in compiled.php line 9852

  40. at Pipeline­>then(object(Closure)) in compiled.php line 8152

  41. at Router­>runRouteWithinStack(object(Route), object(Request)) in compiled.php line 8143

  42. at Router­>dispatchToRoute(object(Request)) in compiled.php line 8133

  43. at Router­>dispatch(object(Request)) in compiled.php line 2391

  44. at Kernel­>Illuminate\Foundation\Http{closure}(object(Request))

  45. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52

  46. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in Debugbar.php line 49

  47. at Debugbar­>handle(object(Request), object(Closure))

  48. at call_user_func_array(array(object(Debugbar), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862

  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 StartupCheck.php line 190

  52. at StartupCheck­>handle(object(Request), object(Closure))

  53. at call_user_func_array(array(object(StartupCheck), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862

  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 DuplicateSubmissionCheck.php line
    33

  57. at DuplicateSubmissionCheck­>handle(object(Request), object(Closure))

  58. at call_user_func_array(array(object(DuplicateSubmissionCheck), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862

  59. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))

  60. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32

  61. at Pipeline­>Illuminate\Routing{closure}(object(Request)) in compiled.php line 3163

  62. at VerifyCsrfToken­>handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 43

  63. at VerifyCsrfToken­>handle(object(Request), object(Closure))

  64. at call_user_func_array(array(object(VerifyCsrfToken), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862

  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 13290

  68. at ShareErrorsFromSession­>handle(object(Request), object(Closure))

  69. at call_user_func_array(array(object(ShareErrorsFromSession), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862

  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 11846

  73. at StartSession­>handle(object(Request), object(Closure))

  74. at call_user_func_array(array(object(StartSession), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862

  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 13029

  78. at AddQueuedCookiesToResponse­>handle(object(Request), object(Closure))

  79. at call_user_func_array(array(object(AddQueuedCookiesToResponse), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862

  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 12966

  83. at EncryptCookies­>handle(object(Request), object(Closure))

  84. at call_user_func_array(array(object(EncryptCookies), ‘handle’), array(object(Request),
    object(Closure))) in compiled.php line 9862

  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)) in compiled.php line 3224

  88. at CheckForMaintenanceMode­>handle(object(Request), object(Closure))

  89. at call_user_func_array(array(object(CheckForMaintenanceMode), ‘handle’),
    array(object(Request), object(Closure))) in compiled.php line 9862

  90. at Pipeline­>Illuminate\Pipeline{closure}(object(Request))

  91. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32

  92. at Pipeline­>Illuminate\Routing{closure}(object(Request))

  93. at call_user_func(object(Closure), object(Request)) in compiled.php line 9852

  94. at Pipeline­>then(object(Closure)) in compiled.php line 2338

  95. at Kernel­>sendRequestThroughRouter(object(Request)) in compiled.php line 2322

  96. 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

Try manually running the update by loading /update (or /public/update) in your browser.

Thanks Hillel…

I gave that a go but got this error

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘refunded’ (SQL: alter table payments add refunded decimal(13, 2) not null, add payment_status_id int unsigned not null default ‘4’, add routing_number int unsigned null, add last4 smallint unsigned null, add expiration date null, add gateway_error text null, add email varchar(255) null, add payment_method_id int unsigned null)

Thanks

Cyberone.

Thanks, that’s helpful. We’re working a new dot release to fix this problem.

You can patch the code by commenting out lines 80,81,82, 91 and 112 in database/migrations/2016_04_23_182223_payments_changes.php

Thanks Hillel.

I did try that a few Upgrades ago and found that it made no difference producing the same SQLSTATE[42S21] Error same as if you manually run the update.

I have enclosed the file (2016_04_23_182223_payments_changes.php) in case it is different as line 82 is a blank line.

thanks

Cyberone

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class PaymentsChanges extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::dropIfExists(‘payment_statuses’);

    Schema::create('payment_statuses', function($table)
    {
        $table-&gt;increments('id');
        $table-&gt;string('name');
    });

    (new \PaymentStatusSeeder())-&gt;run();

    Schema::dropIfExists('payment_methods');

    Schema::create('payment_methods', function($table)
    {
        $table-&gt;increments('id');
        $table-&gt;unsignedInteger('account_id');
        $table-&gt;unsignedInteger('user_id');
        $table-&gt;unsignedInteger('contact_id')-&gt;nullable();
        $table-&gt;unsignedInteger('account_gateway_token_id');
        $table-&gt;unsignedInteger('payment_type_id');
        $table-&gt;string('source_reference');

        $table-&gt;unsignedInteger('routing_number')-&gt;nullable();
        $table-&gt;smallInteger('last4')-&gt;unsigned()-&gt;nullable();
        $table-&gt;date('expiration')-&gt;nullable();
        $table-&gt;string('email')-&gt;nullable();
        $table-&gt;unsignedInteger('currency_id')-&gt;nullable();
        $table-&gt;string('status')-&gt;nullable();

        $table-&gt;timestamps();
        $table-&gt;softDeletes();

        $table-&gt;foreign('account_id')-&gt;references('id')-&gt;on('accounts')-&gt;onDelete('cascade');
        $table-&gt;foreign('user_id')-&gt;references('id')-&gt;on('users')-&gt;onDelete('cascade');
        $table-&gt;foreign('contact_id')-&gt;references('id')-&gt;on('contacts')-&gt;onDelete('cascade');
        $table-&gt;foreign('account_gateway_token_id')-&gt;references('id')-&gt;on('account_gateway_tokens');
        $table-&gt;foreign('payment_type_id')-&gt;references('id')-&gt;on('payment_types');
        $table-&gt;foreign('currency_id')-&gt;references('id')-&gt;on('currencies');

        $table-&gt;unsignedInteger('public_id')-&gt;index();
        $table-&gt;unique( array('account_id','public_id') );
    });

    Schema::table('payments', function($table)
    {
        $table-&gt;decimal('refunded', 13, 2);
        $table-&gt;unsignedInteger('payment_status_id')-&gt;default(PAYMENT_STATUS_COMPLETED);
        $table-&gt;foreign('payment_status_id')-&gt;references('id')-&gt;on('payment_statuses');

        $table-&gt;unsignedInteger('routing_number')-&gt;nullable();
        $table-&gt;smallInteger('last4')-&gt;unsigned()-&gt;nullable();
        $table-&gt;date('expiration')-&gt;nullable();
        $table-&gt;text('gateway_error')-&gt;nullable();
        $table-&gt;string('email')-&gt;nullable();

        $table-&gt;unsignedInteger('payment_method_id')-&gt;nullable();
        $table-&gt;foreign('payment_method_id')-&gt;references('id')-&gt;on('payment_methods');
    });

    Schema::table('invoices', function($table)
    {
        $table-&gt;boolean('client_enable_auto_bill')-&gt;default(false);
    });

    \DB::table('invoices')
        -&gt;where('auto_bill', '=', 1)
        -&gt;update(array('client_enable_auto_bill' =&gt; 1, 'auto_bill' =&gt; AUTO_BILL_OPT_OUT));

    \DB::table('invoices')
        -&gt;where('auto_bill', '=', 0)
        -&gt;where('is_recurring', '=', 1)
        -&gt;update(array('auto_bill' =&gt; AUTO_BILL_OFF));


    Schema::table('account_gateway_tokens', function($table)
    {
        $table-&gt;unsignedInteger('default_payment_method_id')-&gt;nullable();
        $table-&gt;foreign('default_payment_method_id')-&gt;references('id')-&gt;on('payment_methods');

    });
    
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('payments', function($table)
    {
        $table-&gt;dropColumn('refunded');
        $table-&gt;dropForeign('payments_payment_status_id_foreign');
        $table-&gt;dropColumn('payment_status_id');

        $table-&gt;dropColumn('routing_number');
        $table-&gt;dropColumn('last4');
        $table-&gt;dropColumn('expiration');
        $table-&gt;dropColumn('gateway_error');
        $table-&gt;dropColumn('email');

        $table-&gt;dropForeign('payments_payment_method_id_foreign');
        $table-&gt;dropColumn('payment_method_id');
    });

    \DB::table('invoices')
        -&gt;where('auto_bill', '=', AUTO_BILL_OFF)
        -&gt;update(array('auto_bill' =&gt; 0));

    \DB::table('invoices')
        -&gt;where(function($query){
            $query-&gt;where('auto_bill', '=', AUTO_BILL_ALWAYS);
            $query-&gt;orwhere(function($query){
                $query-&gt;where('auto_bill', '!=', 0);
                $query-&gt;where('client_enable_auto_bill', '=', 1);
            });
        })
        -&gt;update(array('auto_bill' =&gt; 1));

    \DB::table('invoices')
        -&gt;where('auto_bill', '!=', 1)
        -&gt;update(array('auto_bill' =&gt; 0));

    Schema::table('invoices', function ($table) {
        $table-&gt;dropColumn('client_enable_auto_bill');
    });

    Schema::dropIfExists('payment_statuses');

    Schema::table('account_gateway_tokens', function($table)
    {
        $table-&gt;dropForeign('account_gateway_tokens_default_payment_method_id_foreign');
        $table-&gt;dropColumn('default_payment_method_id');
    });

    Schema::dropIfExists('payment_methods');
}

}

Here are the five lines to comment out:

$table->decimal(‘refunded’, 13, 2);

$table->unsignedInteger(‘payment_status_id’)->default(PAYMENT_STATUS_COMPLETED);

$table->foreign(‘payment_status_id’)->references(‘id’)->on(‘payment_statuses’);

$table->foreign(‘payment_method_id’)->references(‘id’)->on(‘payment_methods’);

$table->foreign(‘default_payment_method_id’)->references(‘id’)->on(‘payment_methods’);

ok…

I know now where I was going wrong with the commenting out of the lines…
It needs to be done after the attempted upgrade not before…

sorry.

I have commented out the lines shown above.

Makes no difference, still getting the same errors posted in my initial post.

When trying the update manually, I get the same SQL error.

Thank you Hillel

Cyberone

The last time your ran /update I believe you saw:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘refunded’

Are you still the error for the same field, refunded should now be commented out.

yes…
When I run /public/update I get the same SQL Error as stated above.
When I run /public I get the same Errors stated in my initial post.

Thanks Hillel

Cyberone

Can you check the line containing ‘refunded’ is commented out in 2016_04_23_182223_payments_changes.php

Yes…

Please refer to the snipet below.

    Schema::table('payments', function($table)
    {

/** $table->decimal(‘refunded’, 13, 2);
$table->unsignedInteger(‘payment_status_id’)->default(PAYMENT_STATUS_COMPLETED);
$table->foreign(‘payment_status_id’)->references(‘id’)->on(‘payment_statuses’);
*/
$table->unsignedInteger(‘routing_number’)->nullable();
$table->smallInteger(‘last4’)->unsigned()->nullable();
$table->date(‘expiration’)->nullable();
$table->text(‘gateway_error’)->nullable();
$table->string(‘email’)->nullable();

        $table-&gt;unsignedInteger('payment_method_id')-&gt;nullable();

/** //$table->foreign(‘payment_method_id’)->references(‘id’)->on(‘payment_methods’);
*/ });

    Schema::table('invoices', function($table)
    {
        $table-&gt;boolean('client_enable_auto_bill')-&gt;default(false);
    });

    \DB::table('invoices')
        -&gt;where('auto_bill', '=', 1)
        -&gt;update(array('client_enable_auto_bill' =&gt; 1, 'auto_bill' =&gt; AUTO_BILL_OPT_OUT));

    \DB::table('invoices')
        -&gt;where('auto_bill', '=', 0)
        -&gt;where('is_recurring', '=', 1)
        -&gt;update(array('auto_bill' =&gt; AUTO_BILL_OFF));


    Schema::table('account_gateway_tokens', function($table)
    {
        $table-&gt;unsignedInteger('default_payment_method_id')-&gt;nullable();

/** $table->foreign(‘default_payment_method_id’)->references(‘id’)->on(‘payment_methods’);
*/
});

}

Thanks

Cyberone

Can you send me what you see when running /update

After doing the Softaculous Auto Installer and running /public/update returns

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘routing_number’ (SQL: alter table payments add routing_number int unsigned null, add last4 smallint unsigned null, add expiration date null, add gateway_error text null, add email varchar(255) null, add payment_method_id int unsigned null)

Thanks

Cyberone

Try commenting out the routing_number through email lines

No change Sorry Hillel…

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('payments', function($table)
    {
        $table-&gt;dropColumn('refunded');
        $table-&gt;dropForeign('payments_payment_status_id_foreign');
        $table-&gt;dropColumn('payment_status_id');

/** $table->dropColumn(‘routing_number’);
$table->dropColumn(‘last4’);
$table->dropColumn(‘expiration’);
$table->dropColumn(‘gateway_error’);
$table->dropColumn(‘email’);
*/
$table->dropForeign(‘payments_payment_method_id_foreign’);
$table->dropColumn(‘payment_method_id’);
});

    \DB::table('invoices')
        -&gt;where('auto_bill', '=', AUTO_BILL_OFF)
        -&gt;update(array('auto_bill' =&gt; 0));

Thanks

Cyberone

Please post the error shown on /update, it’s likely a similar but different error.

Note: you need to comment out the lines in the up function not the down function.

Ok … Commented out the up function rather then the down function

    Schema::create('payment_methods', function($table)
    {
        $table-&gt;increments('id');
        $table-&gt;unsignedInteger('account_id');
        $table-&gt;unsignedInteger('user_id');
        $table-&gt;unsignedInteger('contact_id')-&gt;nullable();
        $table-&gt;unsignedInteger('account_gateway_token_id');
        $table-&gt;unsignedInteger('payment_type_id');
        $table-&gt;string('source_reference');

/** $table->unsignedInteger(‘routing_number’)->nullable();
$table->smallInteger(‘last4’)->unsigned()->nullable();
$table->date(‘expiration’)->nullable();
$table->string(‘email’)->nullable();
*/ $table->unsignedInteger(‘currency_id’)->nullable();
$table->string(‘status’)->nullable();

        $table-&gt;timestamps();
        $table-&gt;softDeletes();

this is the error I get when running /public/update

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘routing_number’ (SQL: alter table payments add routing_number int unsigned null, add last4 smallint unsigned null, add expiration date null, add gateway_error text null, add email varchar(255) null, add payment_method_id int unsigned null)

There’s another group of lines starting with routing_number further down the file which will also need to be commented out

ok…

I have done that …

Now the error I get when trying to update manually is…

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘payment_method_id’ (SQL: alter table payments add payment_method_id int unsigned null)

Cyberone