Whoops, looks like something went wrong.

2/2 QueryException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'salsas' in 'where clause' (SQL: select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = 1 and `productos`.`activo` = 0 and `subcategorias`.`id_categoria` = abarrotes-comestibles and (
productos.idSubcat1 = salsas-y-aderezos
OR productos.idSubcat2 = salsas-y-aderezos
OR productos.idSubcat3 = salsas-y-aderezos
OR productos.idSubcat4 = salsas-y-aderezos
OR productos.idSubcat5 = salsas-y-aderezos
) and empresa.id_pais = 0)

  1. in Connection.php line 729
  2. at Connection->runQueryCallback('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles'), object(Closure)) in Connection.php line 685
  3. at Connection->run('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles'), object(Closure)) in Connection.php line 349
  4. at Connection->select('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles'), true) in Builder.php line 1610
  5. at Builder->runSelect() in Builder.php line 1596
  6. at Builder->get() in Builder.php line 1671
  7. at Builder->getCountForPagination() in Builder.php line 491
  8. at Builder->paginate('30') in ProductosController.php line 230
  9. at ProductosController->list_stuff(object(Request), 'abarrotes-comestibles', 'salsas-y-aderezos')
  10. at call_user_func_array(array(object(ProductosController), 'list_stuff'), array(object(Request), 'id_categoria' => 'abarrotes-comestibles', 'id_subcategoria' => 'salsas-y-aderezos')) in Controller.php line 80
  11. at Controller->callAction('list_stuff', array(object(Request), 'id_categoria' => 'abarrotes-comestibles', 'id_subcategoria' => 'salsas-y-aderezos')) in ControllerDispatcher.php line 146
  12. at ControllerDispatcher->call(object(ProductosController), object(Route), 'list_stuff') in ControllerDispatcher.php line 94
  13. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  14. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  15. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  16. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  17. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  18. at ControllerDispatcher->callWithinStack(object(ProductosController), object(Route), object(Request), 'list_stuff') in ControllerDispatcher.php line 54
  19. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\ProductosController', 'list_stuff') in Route.php line 174
  20. at Route->runController(object(Request)) in Route.php line 140
  21. at Route->run(object(Request)) in Router.php line 724
  22. at Router->Illuminate\Routing\{closure}(object(Request))
  23. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  24. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
  25. at VerifyCsrfToken->handle(object(Request), object(Closure))
  26. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  27. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  28. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  29. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  30. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  31. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  32. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  33. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  34. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  35. at StartSession->handle(object(Request), object(Closure))
  36. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  37. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  38. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  39. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  40. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  41. at call_user_func_array(array(object(AddQueuedCookiesToResponse), '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 EncryptCookies.php line 59
  45. at EncryptCookies->handle(object(Request), object(Closure))
  46. at call_user_func_array(array(object(EncryptCookies), '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))
  50. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  51. at Pipeline->then(object(Closure)) in Router.php line 726
  52. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
  53. at Router->dispatchToRoute(object(Request)) in Router.php line 675
  54. at Router->dispatch(object(Request)) in Kernel.php line 246
  55. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  56. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  57. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  58. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  59. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  60. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  61. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  62. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  63. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  64. at Pipeline->then(object(Closure)) in Kernel.php line 132
  65. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  66. at Kernel->handle(object(Request)) in index.php line 54

1/2 PDOException in Connection.php line 333: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'salsas' in 'where clause'

  1. in Connection.php line 333
  2. at PDO->prepare('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0') in Connection.php line 333
  3. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles')) in Connection.php line 722
  4. at Connection->runQueryCallback('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles'), object(Closure)) in Connection.php line 685
  5. at Connection->run('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles'), object(Closure)) in Connection.php line 349
  6. at Connection->select('select count(*) as aggregate from `productos` left join `empresas` as `empresa` on `productos`.`id_empresa` = `empresa`.`id` left join `paises` as `pais` on `empresa`.`id_pais` = `pais`.`id` left join `actividades` as `actividad` on `empresa`.`id_actividad` = `actividad`.`id` left join `categorias` on `productos`.`idsubcat1` = `categorias`.`id` left join `subcategorias` on `productos`.`idsubcat2` = `subcategorias`.`id` left join `estados` on `empresa`.`id_estado` = `estados`.`id` left join `adp_solicitudes` as `adp` on `productos`.`id_empresa` = `adp`.`id_empresa` where `empresa`.`status` = ? and `productos`.`activo` = ? and `subcategorias`.`id_categoria` = ? and ( productos.idSubcat1 = salsas-y-aderezos OR productos.idSubcat2 = salsas-y-aderezos OR productos.idSubcat3 = salsas-y-aderezos OR productos.idSubcat4 = salsas-y-aderezos OR productos.idSubcat5 = salsas-y-aderezos ) and empresa.id_pais = 0', array('1', '0', 'abarrotes-comestibles'), true) in Builder.php line 1610
  7. at Builder->runSelect() in Builder.php line 1596
  8. at Builder->get() in Builder.php line 1671
  9. at Builder->getCountForPagination() in Builder.php line 491
  10. at Builder->paginate('30') in ProductosController.php line 230
  11. at ProductosController->list_stuff(object(Request), 'abarrotes-comestibles', 'salsas-y-aderezos')
  12. at call_user_func_array(array(object(ProductosController), 'list_stuff'), array(object(Request), 'id_categoria' => 'abarrotes-comestibles', 'id_subcategoria' => 'salsas-y-aderezos')) in Controller.php line 80
  13. at Controller->callAction('list_stuff', array(object(Request), 'id_categoria' => 'abarrotes-comestibles', 'id_subcategoria' => 'salsas-y-aderezos')) in ControllerDispatcher.php line 146
  14. at ControllerDispatcher->call(object(ProductosController), object(Route), 'list_stuff') in ControllerDispatcher.php line 94
  15. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  16. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  17. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  18. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  19. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  20. at ControllerDispatcher->callWithinStack(object(ProductosController), object(Route), object(Request), 'list_stuff') in ControllerDispatcher.php line 54
  21. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\ProductosController', 'list_stuff') in Route.php line 174
  22. at Route->runController(object(Request)) in Route.php line 140
  23. at Route->run(object(Request)) in Router.php line 724
  24. at Router->Illuminate\Routing\{closure}(object(Request))
  25. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  26. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
  27. at VerifyCsrfToken->handle(object(Request), object(Closure))
  28. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  29. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  30. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  31. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  32. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  33. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  34. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  35. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  36. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  37. at StartSession->handle(object(Request), object(Closure))
  38. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  39. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  40. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  41. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  42. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  43. at call_user_func_array(array(object(AddQueuedCookiesToResponse), '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 EncryptCookies.php line 59
  47. at EncryptCookies->handle(object(Request), object(Closure))
  48. at call_user_func_array(array(object(EncryptCookies), '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))
  52. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  53. at Pipeline->then(object(Closure)) in Router.php line 726
  54. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
  55. at Router->dispatchToRoute(object(Request)) in Router.php line 675
  56. at Router->dispatch(object(Request)) in Kernel.php line 246
  57. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  58. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  59. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  60. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  61. at call_user_func_array(array(object(CheckForMaintenanceMode), '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))
  65. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  66. at Pipeline->then(object(Closure)) in Kernel.php line 132
  67. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  68. at Kernel->handle(object(Request)) in index.php line 54