{"action":"created","issue":{"url":"https://api.github.com/repos/snipe/snipe-it/issues/1319","labels_url":"https://api.github.com/repos/snipe/snipe-it/issues/1319/labels{/name}","comments_url":"https://api.github.com/repos/snipe/snipe-it/issues/1319/comments","events_url":"https://api.github.com/repos/snipe/snipe-it/issues/1319/events","html_url":"https://github.com/snipe/snipe-it/issues/1319","id":115591259,"number":1319,"title":"Issue viewing Location details and deleting a Location","user":{"login":"ryamdagni","id":15694130,"avatar_url":"https://avatars.githubusercontent.com/u/15694130?v=3","gravatar_id":"","url":"https://api.github.com/users/ryamdagni","html_url":"https://github.com/ryamdagni","followers_url":"https://api.github.com/users/ryamdagni/followers","following_url":"https://api.github.com/users/ryamdagni/following{/other_user}","gists_url":"https://api.github.com/users/ryamdagni/gists{/gist_id}","starred_url":"https://api.github.com/users/ryamdagni/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryamdagni/subscriptions","organizations_url":"https://api.github.com/users/ryamdagni/orgs","repos_url":"https://api.github.com/users/ryamdagni/repos","events_url":"https://api.github.com/users/ryamdagni/events{/privacy}","received_events_url":"https://api.github.com/users/ryamdagni/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-11-06T21:11:42Z","updated_at":"2015-11-18T18:41:37Z","closed_at":null,"body":"Hi there. We are using a self-hosted version of SnipeIT and are running into an issue. We are trying to delete a Location, however it says there are 2 assets associated to the Location. We are unable to find any assets associated with the Location, and when we click on the location itself to get more details, we come up with a Server: 404 saying \"We took a wrong turn\" and asking if we want to be redirected to the home page. Help?\r\n\r\nSome Details:\r\nSnipe-IT Version: v2.0-351-g8ec6b7e\r\nPHP Version: 5.5.9-1ubuntu4.13\r\nLaravel Version: 4.2.17\r\nOS we are running SnipeIT on:  Ubuntu (LTS14.0.4)\r\nWebserver:  Apache\r\n\r\nI seem unable to attach a file (I require write permission to the repository) so the following is the entry from the logs:\r\n\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\nsnipeit@snipeIT:/var/www/html/app/storage/logs$ cat log-apache2handler-2015-11-06.txt\r\n[2015-11-06 15:41:16] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 16:08:55] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:22:54] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:26:19] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:28:37] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:39:23] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:40:06] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:40:12] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:47:31] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:48:24] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 17:49:44] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 17:50:36] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 17:50:41] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 17:53:09] production.ERROR: exception 'ErrorException' with message 'Trying to get property of non-object' in /var/www/html/app/controllers/admin/AssetMaintenancesController.php:91\r\nStack trace:\r\n#0 /var/www/html/app/controllers/admin/AssetMaintenancesController.php(91): Illuminate\\Exception\\Handler->handleError(8, 'Trying to get p...', '/var/www/html/a...', 91, Array)\r\n#1 [internal function]: Controllers\\Admin\\AssetMaintenancesController->getDatatable()\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDatatable', Array)\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Controllers\\Admin\\AssetMaintenancesController), Object(Illuminate\\Routing\\Route), 'getDatatable')\r\n#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'Controllers\\Adm...', 'getDatatable')\r\n#6 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#12 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#16 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#18 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#19 {main} [] []\r\n[2015-11-06 17:54:01] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 17:55:04] production.ERROR: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'deleted_at' in where clause is ambiguous' in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(299): PDO->prepare('select count(*)...')\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(617): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\MySqlConnection), 'select count(*)...', Array)\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(304): Illuminate\\Database\\Connection->run('select count(*)...', Array, Object(Closure))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1412): Illuminate\\Database\\Connection->select('select count(*)...', Array)\r\n#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1397): Illuminate\\Database\\Query\\Builder->runSelect()\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1384): Illuminate\\Database\\Query\\Builder->getFresh(Array)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1830): Illuminate\\Database\\Query\\Builder->get(Array)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1768): Illuminate\\Database\\Query\\Builder->aggregate('count', Array)\r\n#9 [internal function]: Illuminate\\Database\\Query\\Builder->count()\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(972): call_user_func_array(Array, Array)\r\n#11 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->__call('count', Array)\r\n#12 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->count()\r\n#13 [internal function]: Controllers\\Admin\\AssetsController->getDatatable('Deleted')\r\n#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\r\n#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDatatable', Array)\r\n#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Controllers\\Admin\\AssetsController), Object(Illuminate\\Routing\\Route), 'getDatatable')\r\n#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'Controllers\\Adm...', 'getDatatable')\r\n#18 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}('Deleted')\r\n#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\r\n#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#24 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#28 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#30 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#31 {main}\r\n\r\nNext exception 'Illuminate\\Database\\QueryException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'deleted_at' in where clause is ambiguous (SQL: select count(*) as aggregate from `assets` inner join `locations` on `locations`.`id` = `assets`.`rtd_location_id` where `physical` = 1 and `deleted_at` is not null order by `locations`.`name` desc)' in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(304): Illuminate\\Database\\Connection->run('select count(*)...', Array, Object(Closure))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1412): Illuminate\\Database\\Connection->select('select count(*)...', Array)\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1397): Illuminate\\Database\\Query\\Builder->runSelect()\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1384): Illuminate\\Database\\Query\\Builder->getFresh(Array)\r\n#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1830): Illuminate\\Database\\Query\\Builder->get(Array)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1768): Illuminate\\Database\\Query\\Builder->aggregate('count', Array)\r\n#7 [internal function]: Illuminate\\Database\\Query\\Builder->count()\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(972): call_user_func_array(Array, Array)\r\n#9 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->__call('count', Array)\r\n#10 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->count()\r\n#11 [internal function]: Controllers\\Admin\\AssetsController->getDatatable('Deleted')\r\n#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\r\n#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDatatable', Array)\r\n#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Controllers\\Admin\\AssetsController), Object(Illuminate\\Routing\\Route), 'getDatatable')\r\n#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'Controllers\\Adm...', 'getDatatable')\r\n#16 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}('Deleted')\r\n#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\r\n#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#22 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#26 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#28 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#29 {main} [] []\r\n[2015-11-06 17:55:17] production.ERROR: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'deleted_at' in where clause is ambiguous' in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(299): PDO->prepare('select count(*)...')\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(617): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\MySqlConnection), 'select count(*)...', Array)\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(304): Illuminate\\Database\\Connection->run('select count(*)...', Array, Object(Closure))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1412): Illuminate\\Database\\Connection->select('select count(*)...', Array)\r\n#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1397): Illuminate\\Database\\Query\\Builder->runSelect()\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1384): Illuminate\\Database\\Query\\Builder->getFresh(Array)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1830): Illuminate\\Database\\Query\\Builder->get(Array)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1768): Illuminate\\Database\\Query\\Builder->aggregate('count', Array)\r\n#9 [internal function]: Illuminate\\Database\\Query\\Builder->count()\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(972): call_user_func_array(Array, Array)\r\n#11 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->__call('count', Array)\r\n#12 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->count()\r\n#13 [internal function]: Controllers\\Admin\\AssetsController->getDatatable('Deleted')\r\n#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\r\n#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDatatable', Array)\r\n#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Controllers\\Admin\\AssetsController), Object(Illuminate\\Routing\\Route), 'getDatatable')\r\n#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'Controllers\\Adm...', 'getDatatable')\r\n#18 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}('Deleted')\r\n#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\r\n#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#24 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#28 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#30 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#31 {main}\r\n\r\nNext exception 'Illuminate\\Database\\QueryException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'deleted_at' in where clause is ambiguous (SQL: select count(*) as aggregate from `assets` inner join `locations` on `locations`.`id` = `assets`.`rtd_location_id` where `physical` = 1 and `deleted_at` is not null order by `locations`.`name` desc)' in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(581): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(304): Illuminate\\Database\\Connection->run('select count(*)...', Array, Object(Closure))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1412): Illuminate\\Database\\Connection->select('select count(*)...', Array)\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1397): Illuminate\\Database\\Query\\Builder->runSelect()\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1384): Illuminate\\Database\\Query\\Builder->getFresh(Array)\r\n#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1830): Illuminate\\Database\\Query\\Builder->get(Array)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1768): Illuminate\\Database\\Query\\Builder->aggregate('count', Array)\r\n#7 [internal function]: Illuminate\\Database\\Query\\Builder->count()\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(972): call_user_func_array(Array, Array)\r\n#9 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->__call('count', Array)\r\n#10 /var/www/html/app/controllers/admin/AssetsController.php(1168): Illuminate\\Database\\Eloquent\\Builder->count()\r\n#11 [internal function]: Controllers\\Admin\\AssetsController->getDatatable('Deleted')\r\n#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\r\n#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(93): Illuminate\\Routing\\Controller->callAction('getDatatable', Array)\r\n#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(62): Illuminate\\Routing\\ControllerDispatcher->call(Object(Controllers\\Admin\\AssetsController), Object(Illuminate\\Routing\\Route), 'getDatatable')\r\n#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(967): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'Controllers\\Adm...', 'getDatatable')\r\n#16 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}('Deleted')\r\n#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(109): call_user_func_array(Object(Closure), Array)\r\n#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1033): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#22 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#26 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#28 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#29 {main} [] []\r\n[2015-11-06 17:57:57] production.DEBUG: Authenticating user against database. [] []\r\n[2015-11-06 18:00:25] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 18:09:41] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 18:14:40] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 18:28:13] production.ERROR: exception 'Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException' in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\nStack trace:\r\n#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1054): Illuminate\\Routing\\RouteCollection->match(Object(Illuminate\\Http\\Request))\r\n#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1022): Illuminate\\Routing\\Router->findRoute(Object(Illuminate\\Http\\Request))\r\n#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(1001): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(775): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(745): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n#5 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php(34): Illuminate\\Foundation\\Application->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php(72): Barryvdh\\Debugbar\\Middleware\\Stack->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php(47): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php(51): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#9 /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(641): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n#11 /var/www/html/public/index.php(49): Illuminate\\Foundation\\Application->run()\r\n#12 {main} [] []\r\n[2015-11-06 20:28:24] production.DEBUG: Authenticating user against database. [] []\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\nThe following is from the stacktrace, with Debug mode enabled:\r\n\r\nSymfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException thrown with message \"\"\r\n\r\nStacktrace:\r\n#12 Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php:148\r\n#11 Illuminate\\Routing\\RouteCollection:match in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1054\r\n#10 Illuminate\\Routing\\Router:findRoute in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1022\r\n#9 Illuminate\\Routing\\Router:dispatchToRoute in /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1001\r\n#8 Illuminate\\Routing\\Router:dispatch in /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:775\r\n#7 Illuminate\\Foundation\\Application:dispatch in /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:745\r\n#6 Illuminate\\Foundation\\Application:handle in /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/Stack.php:34\r\n#5 Barryvdh\\Debugbar\\Middleware\\Stack:handle in /var/www/html/vendor/laravel/framework/src/Illuminate/Session/Middleware.php:72\r\n#4 Illuminate\\Session\\Middleware:handle in /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php:47\r\n#3 Illuminate\\Cookie\\Queue:handle in /var/www/html/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php:51\r\n#2 Illuminate\\Cookie\\Guard:handle in /var/www/html/vendor/stack/builder/src/Stack/StackedHttpKernel.php:23\r\n#1 Stack\\StackedHttpKernel:handle in /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:641\r\n#0 Illuminate\\Foundation\\Application:run in /var/www/html/public/index.php:49\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\nI also have an HTML screen capture I can send if required.\r\n\r\nThank-you!\r\nRavi Yamdagni\r\nryamdagni@gmail.com\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/snipe/snipe-it/issues/comments/157815332","html_url":"https://github.com/snipe/snipe-it/issues/1319#issuecomment-157815332","issue_url":"https://api.github.com/repos/snipe/snipe-it/issues/1319","id":157815332,"user":{"login":"ryamdagni","id":15694130,"avatar_url":"https://avatars.githubusercontent.com/u/15694130?v=3","gravatar_id":"","url":"https://api.github.com/users/ryamdagni","html_url":"https://github.com/ryamdagni","followers_url":"https://api.github.com/users/ryamdagni/followers","following_url":"https://api.github.com/users/ryamdagni/following{/other_user}","gists_url":"https://api.github.com/users/ryamdagni/gists{/gist_id}","starred_url":"https://api.github.com/users/ryamdagni/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryamdagni/subscriptions","organizations_url":"https://api.github.com/users/ryamdagni/orgs","repos_url":"https://api.github.com/users/ryamdagni/repos","events_url":"https://api.github.com/users/ryamdagni/events{/privacy}","received_events_url":"https://api.github.com/users/ryamdagni/received_events","type":"User","site_admin":false},"created_at":"2015-11-18T18:41:37Z","updated_at":"2015-11-18T18:41:37Z","body":"I found 2 entries in the Asset_Logs table associated with that location. I verified that no users, locations, or assets (from the \"Users\", \"Locations\", and \"Assets\" tables) were associated to that location in any way. So, I went ahead and deleted the entries from the Asset_Logs table and was then able to successfully delete the entry from the Locations area on the application.\r\n\r\nI am, however, still getting the 404 when clicking on a Location on the Locations screen. Clues?"}}