search

ladybirdweb / faveo-helpdesk

Faveo Open source ticketing system build on Laravel framework
https://www.faveohelpdesk.com/online-demo/
Open Software License 3.0
1.15k stars 564 forks source link

Upgraded to 1.9.2: Messages won't load #375

Closed ningmu closed 7 years ago

ningmu commented 7 years ago

Hi,

Upgraded Faveo Helpdesk from 1.0.8.0RC to 1.9.2. Followed the upgrading instruction religiously. Updated the DB to 1.9.0 then 1.9.2.

Result... Login page: fine Submit/Open Ticket: fine Agent Dashboard: fine Admin Panel: fine All pages in Admin: fine Email system: fine

But only in Agent Panel, all pages related to messages, Inbox/Closed/Answered/My Tickets/etc won't really load.

Someone submitted a ticket to the frontpage, I received an email notification that someone opened a ticket, but as soon as I login to Agent Dashboard and proceed to Inbox, list of messages won't really load.

Already tried on every type of web browser with a cleared cache and cookies.

Please help. Thanks!

ticket-inbox-wontload

mverma16 commented 7 years ago

Please enable debugging mode and share the ajax response.

ningmu commented 7 years ago

Exceptions: Cannot add MailCollector to Laravel Debugbar: Missing argument 1 for Illuminate\Support\Manager::createDriver(), called in /home/userme/public_html/support/vendor/laravel/framework/src/Illuminate/Support/Manager.php on line 87 and defined /home/userme/public_html/support/vendor/barryvdh/laravel-debugbar/src/LaravelDebugbar.php#338 Exception Missing argument 1 for Illuminate\Support\Manager::createDriver(), called in /home/userme/public_html/support/vendor/laravel/framework/src/Illuminate/Support/Manager.php on line 87 and defined

Session: _token lT3cB6klpzTsUxkL3siCQo8dHIdDv6e2tXKTaCdl _previous array:1 [ "url" => "http://domain.net/support/public/ticket/inbox" ] flash array:2 [ "old" => [] "new" => [] ] loginAttempts 2 loginAttemptTime 1484302840 login_web_59ba36addc2b2f940158ddf014c7f58ea4e30989d 3 PHPDEBUGBAR_STACK_DATA []

Request: format html content_type text/html; charset=UTF-8 status_text OK status_code 200 request_query [] request_request [] request_headers array:10 [ "cookie" => array:1 [ 0 => "laravel_session=eyJpdiI6ImVsYXdDWmhFdmVFVzJDQkxsQjNKSXc... request_server array:41 [ "PATH" => "/usr/local/jdk/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/... request_cookies array:1 [ "laravel_session" => "133d3317bc8a06eda1894889634b41bfb5cfb363" ] response_headers array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0... path_info /ticket/inbox session_attributes array:7 [ "_token" => "lT3cB6klpzTsUxkL3siCQo8dHIdDv6e2tXKTaCdl" "_previous" => array:1 [ "u...

mverma16 commented 7 years ago

Still the problem is not clear. Please follow the steps below to see the ajax call response

By default it on elements and shows html code

here you have to navigate to XHR to see ajax calls 1

Last click on the "filter?data..." and check the response/preview 2

ningmu commented 7 years ago

Thanks for the guidance. Here it is:

RESPONSE: <!DOCTYPE

html>

Whoops, looks like something went wrong.

2/2 QueryException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket_source.css_class' in 'field list' (SQL: select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> 1 left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (1, 7) group by `tickets`.`id`) count_row_table)

  1. in Connection.php line 729
  2. at Connection->runQueryCallback('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 685
  3. at Connection->run('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 349
  4. at Connection->select('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), true) in Builder.php line 1610
  5. at Builder->runSelect() in Builder.php line 1596
  6. at Builder->get(array('*')) in Builder.php line 2002
  7. at Builder->aggregate('count', array('*')) in Builder.php line 1924
  8. at Builder->count() in QueryBuilderEngine.php line 104
  9. at QueryBuilderEngine->count() in QueryBuilderEngine.php line 85
  10. at QueryBuilderEngine->totalCount() in BaseEngine.php line 581
  11. at BaseEngine->make(false, false) in QueryBuilderEngine.php line 75
  12. at QueryBuilderEngine->make() in TicketController.php line 2545
  13. at TicketController::getTable(object(Builder)) in FilterController.php line 56
  14. at FilterController->getFilter(object(Request))
  15. at call_user_func_array(array(object(FilterController), 'getFilter'), array(object(Request))) in Controller.php line 80
  16. at Controller->callAction('getFilter', array(object(Request))) in ControllerDispatcher.php line 146
  17. at ControllerDispatcher->call(object(FilterController), object(Route), 'getFilter') in ControllerDispatcher.php line 94
  18. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  19. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  20. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckRoleAgent.php line 25
  21. at CheckRoleAgent->handle(object(Request), object(Closure))
  22. at call_user_func_array(array(object(CheckRoleAgent), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  23. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  24. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  25. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 54
  26. at Authenticate->handle(object(Request), object(Closure))
  27. at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 Pipeline.php line 103
  32. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  33. at ControllerDispatcher->callWithinStack(object(FilterController), object(Route), object(Request), 'getFilter') in ControllerDispatcher.php line 54
  34. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\Agent\helpdesk\Filter\FilterController', 'getFilter') in Route.php line 174
  35. at Route->runController(object(Request)) in Route.php line 140
  36. at Route->run(object(Request)) in Router.php line 724
  37. at Router->Illuminate\Routing\{closure}(object(Request))
  38. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  39. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckUpdate.php line 35
  40. at CheckUpdate->handle(object(Request), object(Closure))
  41. at call_user_func_array(array(object(CheckUpdate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  42. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  43. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  44. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in LanguageMiddleware.php line 21
  45. at LanguageMiddleware->handle(object(Request), object(Closure))
  46. at call_user_func_array(array(object(LanguageMiddleware), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 ShareErrorsFromSession.php line 49
  50. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  51. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 StartSession.php line 64
  55. at StartSession->handle(object(Request), object(Closure))
  56. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 AddQueuedCookiesToResponse.php line 37
  60. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  61. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 EncryptCookies.php line 59
  65. at EncryptCookies->handle(object(Request), object(Closure))
  66. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 CheckForMaintenanceMode.php line 44
  70. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  71. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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))
  75. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  76. at Pipeline->then(object(Closure)) in Router.php line 726
  77. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
  78. at Router->dispatchToRoute(object(Request)) in Router.php line 675
  79. at Router->dispatch(object(Request)) in Kernel.php line 246
  80. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  81. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  82. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Debugbar.php line 51
  83. at Debugbar->handle(object(Request), object(Closure))
  84. at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 CheckForMaintenanceMode.php line 44
  88. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  89. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 Pipeline.php line 103
  94. at Pipeline->then(object(Closure)) in Kernel.php line 132
  95. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  96. at Kernel->handle(object(Request)) in index.php line 53

1/2 PDOException in Connection.php line 333: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket_source.css_class' in 'field list'

  1. in Connection.php line 333
  2. at PDO->prepare('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table') in Connection.php line 333
  3. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7')) in Connection.php line 722
  4. at Connection->runQueryCallback('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 685
  5. at Connection->run('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 349
  6. at Connection->select('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), true) in Builder.php line 1610
  7. at Builder->runSelect() in Builder.php line 1596
  8. at Builder->get(array('*')) in Builder.php line 2002
  9. at Builder->aggregate('count', array('*')) in Builder.php line 1924
  10. at Builder->count() in QueryBuilderEngine.php line 104
  11. at QueryBuilderEngine->count() in QueryBuilderEngine.php line 85
  12. at QueryBuilderEngine->totalCount() in BaseEngine.php line 581
  13. at BaseEngine->make(false, false) in QueryBuilderEngine.php line 75
  14. at QueryBuilderEngine->make() in TicketController.php line 2545
  15. at TicketController::getTable(object(Builder)) in FilterController.php line 56
  16. at FilterController->getFilter(object(Request))
  17. at call_user_func_array(array(object(FilterController), 'getFilter'), array(object(Request))) in Controller.php line 80
  18. at Controller->callAction('getFilter', array(object(Request))) in ControllerDispatcher.php line 146
  19. at ControllerDispatcher->call(object(FilterController), object(Route), 'getFilter') in ControllerDispatcher.php line 94
  20. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  21. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  22. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckRoleAgent.php line 25
  23. at CheckRoleAgent->handle(object(Request), object(Closure))
  24. at call_user_func_array(array(object(CheckRoleAgent), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  25. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  26. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  27. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 54
  28. at Authenticate->handle(object(Request), object(Closure))
  29. at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  30. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  31. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  32. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  33. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  34. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  35. at ControllerDispatcher->callWithinStack(object(FilterController), object(Route), object(Request), 'getFilter') in ControllerDispatcher.php line 54
  36. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\Agent\helpdesk\Filter\FilterController', 'getFilter') in Route.php line 174
  37. at Route->runController(object(Request)) in Route.php line 140
  38. at Route->run(object(Request)) in Router.php line 724
  39. at Router->Illuminate\Routing\{closure}(object(Request))
  40. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  41. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckUpdate.php line 35
  42. at CheckUpdate->handle(object(Request), object(Closure))
  43. at call_user_func_array(array(object(CheckUpdate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  44. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  45. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  46. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in LanguageMiddleware.php line 21
  47. at LanguageMiddleware->handle(object(Request), object(Closure))
  48. at call_user_func_array(array(object(LanguageMiddleware), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 ShareErrorsFromSession.php line 49
  52. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  53. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 StartSession.php line 64
  57. at StartSession->handle(object(Request), object(Closure))
  58. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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 AddQueuedCookiesToResponse.php line 37
  62. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  63. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  64. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  65. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  66. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  67. at EncryptCookies->handle(object(Request), object(Closure))
  68. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  69. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  70. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  71. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  72. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  73. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  74. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  75. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  76. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  77. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  78. at Pipeline->then(object(Closure)) in Router.php line 726
  79. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
  80. at Router->dispatchToRoute(object(Request)) in Router.php line 675
  81. at Router->dispatch(object(Request)) in Kernel.php line 246
  82. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  83. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  84. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Debugbar.php line 51
  85. at Debugbar->handle(object(Request), object(Closure))
  86. at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  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)) in CheckForMaintenanceMode.php line 44
  90. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  91. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  92. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  93. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  94. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  95. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  96. at Pipeline->then(object(Closure)) in Kernel.php line 132
  97. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  98. at Kernel->handle(object(Request)) in index.php line 53
` PREVIEW: 1/2 PDOException in Connection.php line 333: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket_source.css_class' in 'field list' in Connection.php line 333 at PDO->prepare('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table') in Connection.php line 333 at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7')) in Connection.php line 722 at Connection->runQueryCallback('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 685 at Connection->run('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 349 at Connection->select('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), true) in Builder.php line 1610 at Builder->runSelect() in Builder.php line 1596 at Builder->get(array('*')) in Builder.php line 2002 at Builder->aggregate('count', array('*')) in Builder.php line 1924 at Builder->count() in QueryBuilderEngine.php line 104 at QueryBuilderEngine->count() in QueryBuilderEngine.php line 85 at QueryBuilderEngine->totalCount() in BaseEngine.php line 581 at BaseEngine->make(false, false) in QueryBuilderEngine.php line 75 at QueryBuilderEngine->make() in TicketController.php line 2545 at TicketController::getTable(object(Builder)) in FilterController.php line 56 at FilterController->getFilter(object(Request)) at call_user_func_array(array(object(FilterController), 'getFilter'), array(object(Request))) in Controller.php line 80 at Controller->callAction('getFilter', array(object(Request))) in ControllerDispatcher.php line 146 at ControllerDispatcher->call(object(FilterController), object(Route), 'getFilter') in ControllerDispatcher.php line 94 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)) in CheckRoleAgent.php line 25 at CheckRoleAgent->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckRoleAgent), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 54 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 Pipeline.php line 103 at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96 at ControllerDispatcher->callWithinStack(object(FilterController), object(Route), object(Request), 'getFilter') in ControllerDispatcher.php line 54 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\Agent\helpdesk\Filter\FilterController', 'getFilter') in Route.php line 174 at Route->runController(object(Request)) in Route.php line 140 at Route->run(object(Request)) in Router.php line 724 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 CheckUpdate.php line 35 at CheckUpdate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckUpdate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 LanguageMiddleware.php line 21 at LanguageMiddleware->handle(object(Request), object(Closure)) at call_user_func_array(array(object(LanguageMiddleware), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 StartSession.php line 64 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 AddQueuedCookiesToResponse.php line 37 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 EncryptCookies.php line 59 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 Pipeline.php line 103 at Pipeline->then(object(Closure)) in Router.php line 726 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699 at Router->dispatchToRoute(object(Request)) in Router.php line 675 at Router->dispatch(object(Request)) in Kernel.php line 246 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 51 at Debugbar->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 Pipeline.php line 103 at Pipeline->then(object(Closure)) in Kernel.php line 132 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99 at Kernel->handle(object(Request)) in index.php line 53 > QueryException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ticket_source.css_class' in 'field list' (SQL: select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> 1 left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (1, 7) group by `tickets`.`id`) count_row_table) in Connection.php line 729 at Connection->runQueryCallback('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 685 at Connection->run('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), object(Closure)) in Connection.php line 349 at Connection->select('select count(*) as aggregate from (select `tickets`.`id`, `ticket_thread`.`title`, `tickets`.`ticket_number`, `ticket_priority`.`priority`, `u`.`user_name` as `user_name`, `u1`.`user_name` as `assign_user_name`, max(ticket_thread.updated_at) as updated_at, min(ticket_thread.updated_at) as created_at, `u`.`first_name` as `first_name`, `u`.`last_name` as `last_name`, `u1`.`first_name` as `assign_first_name`, `u1`.`last_name` as `assign_last_name`, `ticket_priority`.`priority_color`, COUNT(DISTINCT ticket_thread2.id) as countthread, COUNT(ticket_attachment.thread_id) as countattachment, COUNT(ticket_collaborator.ticket_id) as countcollaborator, `tickets`.`status`, `tickets`.`user_id`, `tickets`.`priority_id`, `tickets`.`assigned_to`, `ticket_status`.`name` as `tickets_status`, `ticket_source`.`css_class` as `css`, substring_index(group_concat(ticket_thread.poster order by ticket_thread.id desc) , ",", 1) as last_replier, substring_index(group_concat(ticket_thread.title order by ticket_thread.id asc) , ",", 1) as ticket_title, `u`.`active` as `verified` from `tickets` left join `ticket_thread` on `tickets`.`id` = `ticket_thread`.`ticket_id` and `title` is not null and `ticket_thread`.`is_internal` <> ? left join `ticket_thread` as `ticket_thread2` on `ticket_thread2`.`ticket_id` = `tickets`.`id` inner join `ticket_source` on `ticket_source`.`id` = `tickets`.`source` left join `ticket_priority` on `ticket_priority`.`priority_id` = `tickets`.`priority_id` left join `users` as `u` on `u`.`id` = `tickets`.`user_id` left join `users` as `u1` on `u1`.`id` = `tickets`.`assigned_to` left join `ticket_attachment` on `ticket_attachment`.`thread_id` = `ticket_thread`.`id` left join `ticket_collaborator` on `ticket_collaborator`.`ticket_id` = `tickets`.`id` inner join `ticket_status` on `ticket_status`.`id` = `tickets`.`status` and `ticket_status`.`id` in (?, ?) group by `tickets`.`id`) count_row_table', array('1', '1', '7'), true) in Builder.php line 1610 at Builder->runSelect() in Builder.php line 1596 at Builder->get(array('*')) in Builder.php line 2002 at Builder->aggregate('count', array('*')) in Builder.php line 1924 at Builder->count() in QueryBuilderEngine.php line 104 at QueryBuilderEngine->count() in QueryBuilderEngine.php line 85 at QueryBuilderEngine->totalCount() in BaseEngine.php line 581 at BaseEngine->make(false, false) in QueryBuilderEngine.php line 75 at QueryBuilderEngine->make() in TicketController.php line 2545 at TicketController::getTable(object(Builder)) in FilterController.php line 56 at FilterController->getFilter(object(Request)) at call_user_func_array(array(object(FilterController), 'getFilter'), array(object(Request))) in Controller.php line 80 at Controller->callAction('getFilter', array(object(Request))) in ControllerDispatcher.php line 146 at ControllerDispatcher->call(object(FilterController), object(Route), 'getFilter') in ControllerDispatcher.php line 94 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)) in CheckRoleAgent.php line 25 at CheckRoleAgent->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckRoleAgent), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 54 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 Pipeline.php line 103 at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96 at ControllerDispatcher->callWithinStack(object(FilterController), object(Route), object(Request), 'getFilter') in ControllerDispatcher.php line 54 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\Agent\helpdesk\Filter\FilterController', 'getFilter') in Route.php line 174 at Route->runController(object(Request)) in Route.php line 140 at Route->run(object(Request)) in Router.php line 724 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 CheckUpdate.php line 35 at CheckUpdate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckUpdate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 LanguageMiddleware.php line 21 at LanguageMiddleware->handle(object(Request), object(Closure)) at call_user_func_array(array(object(LanguageMiddleware), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 StartSession.php line 64 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 AddQueuedCookiesToResponse.php line 37 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 EncryptCookies.php line 59 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 Pipeline.php line 103 at Pipeline->then(object(Closure)) in Router.php line 726 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699 at Router->dispatchToRoute(object(Request)) in Router.php line 675 at Router->dispatch(object(Request)) in Kernel.php line 246 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 51 at Debugbar->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Debugbar), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136 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 Pipeline.php line 103 at Pipeline->then(object(Closure)) in Kernel.php line 132 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99 at Kernel->handle(object(Request)) in index.php line 53 ![ajax-inbox-faveo1](https://cloud.githubusercontent.com/assets/22490393/21931620/53491848-d9d7-11e6-9c81-30e7c0d4cff2.PNG)
mverma16 commented 7 years ago

Seems like you've missed some steps in DB update or might be there is a problem with DB update scripts.

In your DB, run these SQL commands

-- 
-- Database: `master`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `ticket_source`
-- 

DROP TABLE IF EXISTS `ticket_source`;
CREATE TABLE `ticket_source` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `css_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `ticket_source`
-- 

INSERT INTO `ticket_source` (`id`, `name`, `value`, `css_class`) VALUES
(1, 'web', 'Web', 'fa fa-internet-explorer'),
(2, 'email', 'E-mail', 'fa fa-envelope'),
(3, 'agent', 'Agent Panel', 'fa fa-envelope'),
(4, 'facebook', 'Facebook', 'fa fa-facebook'),
(5, 'twitter', 'Twitter', 'fa fa-twitter'),
(6, 'call', 'Call', 'fa fa-phone'),
(7, 'chat', 'Chat', 'fa fa-comment'),
(8, 'web', 'Web', ''),
(9, 'email', 'E-mail', ''),
(10, 'agent', 'Agent Panel', '');

-- 
-- Indexes for dumped tables
-- 

-- 
-- Indexes for table `ticket_source`
-- 
ALTER TABLE `ticket_source`
  ADD PRIMARY KEY (`id`);

-- 
-- AUTO_INCREMENT for dumped tables
-- 

-- 
-- AUTO_INCREMENT for table `ticket_source`
-- 
ALTER TABLE `ticket_source`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

This will solve your problem. Revert for further issues.

ningmu commented 7 years ago

Thanks a lot @mverma16! It is working fine now.

I just used the update scripts from the DB folder when I upgraded it. I used the 1.0.8.0_to_1.9.0 db script first, then 1.9.0_to_1.9.2 db script.

Anyway, it's okay now after I executed the given sql query above.

Thanks!