Whoops, looks like something went wrong.
2/2
QueryException in Connection.php line 729:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'refrigeradores' 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` = linea-blanca and (
productos.idSubcat1 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0)
- in Connection.php line 729
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca'), object(Closure)) in Connection.php line 685
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca'), object(Closure)) in Connection.php line 349
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca'), true) in Builder.php line 1610
- at Builder->runSelect() in Builder.php line 1596
- at Builder->get() in Builder.php line 1671
- at Builder->getCountForPagination() in Builder.php line 491
- at Builder->paginate('30') in ProductosController.php line 230
- at ProductosController->list_stuff(object(Request), 'linea-blanca', 'refrigeradores')
- at call_user_func_array(array(object(ProductosController), 'list_stuff'), array(object(Request), 'id_categoria' => 'linea-blanca', 'id_subcategoria' => 'refrigeradores')) in Controller.php line 80
- at Controller->callAction('list_stuff', array(object(Request), 'id_categoria' => 'linea-blanca', 'id_subcategoria' => 'refrigeradores')) in ControllerDispatcher.php line 146
- at ControllerDispatcher->call(object(ProductosController), object(Route), 'list_stuff') 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))
- 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(ProductosController), object(Route), object(Request), 'list_stuff') in ControllerDispatcher.php line 54
- at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\ProductosController', 'list_stuff') 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 VerifyCsrfToken.php line 64
- at VerifyCsrfToken->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(VerifyCsrfToken), '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))
- 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 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 54
1/2
PDOException in Connection.php line 333:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'refrigeradores' in 'where clause'
- in Connection.php line 333
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0') in Connection.php line 333
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca')) in Connection.php line 722
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca'), object(Closure)) in Connection.php line 685
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca'), object(Closure)) in Connection.php line 349
- 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 = refrigeradores
OR productos.idSubcat2 = refrigeradores
OR productos.idSubcat3 = refrigeradores
OR productos.idSubcat4 = refrigeradores
OR productos.idSubcat5 = refrigeradores
) and empresa.id_pais = 0', array('1', '0', 'linea-blanca'), true) in Builder.php line 1610
- at Builder->runSelect() in Builder.php line 1596
- at Builder->get() in Builder.php line 1671
- at Builder->getCountForPagination() in Builder.php line 491
- at Builder->paginate('30') in ProductosController.php line 230
- at ProductosController->list_stuff(object(Request), 'linea-blanca', 'refrigeradores')
- at call_user_func_array(array(object(ProductosController), 'list_stuff'), array(object(Request), 'id_categoria' => 'linea-blanca', 'id_subcategoria' => 'refrigeradores')) in Controller.php line 80
- at Controller->callAction('list_stuff', array(object(Request), 'id_categoria' => 'linea-blanca', 'id_subcategoria' => 'refrigeradores')) in ControllerDispatcher.php line 146
- at ControllerDispatcher->call(object(ProductosController), object(Route), 'list_stuff') 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))
- 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(ProductosController), object(Route), object(Request), 'list_stuff') in ControllerDispatcher.php line 54
- at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\ProductosController', 'list_stuff') 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 VerifyCsrfToken.php line 64
- at VerifyCsrfToken->handle(object(Request), object(Closure))
- at call_user_func_array(array(object(VerifyCsrfToken), '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))
- 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 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 54