^ Zend_Db_Statement_Exception {#177
-_previous: null
#message: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away"
#code: 0
#file: "/var/www/html/demasledweb/library/Zend/Db/Statement/Pdo.php"
#line: 234
-previous: PDOException {#176
#message: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away"
#code: "HY000"
#file: "/var/www/html/demasledweb/library/Zend/Db/Statement/Pdo.php"
#line: 228
+errorInfo: array:3 [
0 => "HY000"
1 => 2006
2 => "MySQL server has gone away"
]
trace: {
/var/www/html/demasledweb/library/Zend/Db/Statement/Pdo.php:228 {
Zend_Db_Statement_Pdo->_execute(array $params = null) …
› if ($params !== null) {
› return $this->_stmt->execute($params);
› } else {
arguments: {
$bound_input_params: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Statement.php:300 {
Zend_Db_Statement->execute(array $params = null) …
› if ($this->_queryId === null) {
› return $this->_execute($params);
› }
arguments: {
$params: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Adapter/Abstract.php:480 {
Zend_Db_Adapter_Abstract->query($sql, $bind = []) …
› $stmt = $this->prepare($sql);
› $stmt->execute($bind);
›
arguments: {
$params: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Adapter/Pdo/Abstract.php:238 {
Zend_Db_Adapter_Pdo_Abstract->query($sql, $bind = []) …
› try {
› return parent::query($sql, $bind);
› } catch (PDOException $e) {
arguments: {
$sql: """
SELECT SQL_CALC_FOUND_ROWS p.id, `p`.`codigo`, `p`.`imagen`, `p`.`stock_minimo`, `p`.`precio_general`, `p`.`stock_minimo_publicacion`, `p`.`impuesto`, `p`.`url_alias`, `p`.`ps_cantidad_unidad`, "0" as es_combo, `plp`.*, `pi`.`nombre`, `pi`.`descripcion`, `pi`.`meta_keywords`, `pi`.`meta_description`, `pe`.`idcolor`, IFNULL(ci.color, 'No Disponible') AS `color`, MIN( pcc.precio ) AS `precio_desde`, MAX( pcc.precio ) AS `precio_hasta`, SUM(IFNULL( IF(d.ventas_web = 1, ds.stock,0), 0 )) AS `stock`, SUM(IFNULL( IF(d.ventas_web = 1, ds.stock_reservado,0), 0 )) AS `stock_reservado`, IF( ds.stock is null or ds.stock = 0, 0 ,1 ) AS `tiene_stock` FROM `productos` AS `p`\n
INNER JOIN `productos_lineas_producto` AS `plp` ON p.id = plp.idproducto\n
INNER JOIN `productos_idiomas` AS `pi` ON p.id = pi.idproducto\n
LEFT JOIN `productos_etiquetas` AS `pe` ON p.id = pe.idproducto\n
LEFT JOIN `colores_idiomas` AS `ci` ON pe.idcolor = ci.idcolor AND ci.ididioma = 3\n
LEFT JOIN `productos_datos_tecnicos` AS `pdt` ON p.id = pdt.idproducto\n
LEFT JOIN `precios_categoria_cliente` AS `pcc` ON pcc.idproducto = p.id and pcc.idcategoria_cliente=4\n
LEFT JOIN `depositos_stock` AS `ds` ON ds.idproducto = p.id\n
LEFT JOIN `depositos` AS `d` ON d.id = ds.iddeposito WHERE (plp.idlinea_producto in (430,432,433,434,599,600,244,436,245,437,441,246,442,247,440,248,439,143,243) AND p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = 3) GROUP BY `p`.`id` ORDER BY `tiene_stock` DESC, `p`.`codigo` ASC LIMIT 30
"""
$bind: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Adapter/Abstract.php:738 {
Zend_Db_Adapter_Abstract->fetchAll($sql, $bind = [], $fetchMode = null) …
› }
› $stmt = $this->query($sql, $bind);
› $result = $stmt->fetchAll($fetchMode);
arguments: {
$sql: Zend_Db_Select {#168 …}
$bind: []
}
}
/var/www/html/demasledweb/application/demasled/models/ProductoMapper.php:133 {
ProductoMapper->fetchAllPorCategoria($where = null, $order = null, $count = null, $offset = null, $groupby = null) …
›
› $resultSet = $this->getDbTable()->getAdapter()->fetchAll($query);
› return $resultSet;
arguments: {
$sql: Zend_Db_Select {#168 …}
}
}
/var/www/html/demasledweb/application/demasled/controllers/CategoriaController.php:106 {
CategoriaController->indexAction() …
› $tp = $productoMapper->totalIDProductos($where . " p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = " . $this->idioma["id"], null, null, null, 'p.id');
› $productos = $productoMapper->fetchAllPorCategoria($where . " p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = " . $this->idioma["id"], $sql_order_field, $count, $offset, 'p.id');
› $total_products = $productoMapper->countAll();
arguments: {
$where: "plp.idlinea_producto in (430,432,433,434,599,600,244,436,245,437,441,246,442,247,440,248,439,143,243) AND p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = 3"
$order: array:2 [ …2]
$count: 30
$offset: 0
$groupby: "p.id"
}
}
/var/www/html/demasledweb/library/Zend/Controller/Action.php:513 {
Zend_Controller_Action->dispatch($action) …
› }
› $this->$action();
› } else {
}
/var/www/html/demasledweb/library/Zend/Controller/Dispatcher/Standard.php:295 {
Zend_Controller_Dispatcher_Standard->dispatch(Zend_Controller_Request_Abstract $request, Zend_Controller_Response_Abstract $response) …
› try {
› $controller->dispatch($action);
› } catch (Exception $e) {
arguments: {
$action: "indexAction"
}
}
/var/www/html/demasledweb/library/Zend/Controller/Front.php:954 {
Zend_Controller_Front->dispatch(Zend_Controller_Request_Abstract $request = null, Zend_Controller_Response_Abstract $response = null) …
› try {
› $dispatcher->dispatch($this->_request, $this->_response);
› } catch (Exception $e) {
arguments: {
$request: Zend_Controller_Request_Http {#68 …}
$response: Zend_Controller_Response_Http {#89 …}
}
}
/var/www/html/demasledweb/library/Zend/Application/Bootstrap/Bootstrap.php:97 {
Zend_Application_Bootstrap_Bootstrap->run() …
› $front->setParam('bootstrap', $this);
› $response = $front->dispatch();
› if ($front->returnResponse()) {
}
/var/www/html/demasledweb/library/Zend/Application.php:366 {
Zend_Application->run() …
› {
› $this->getBootstrap()->run();
› }
}
/var/www/html/demasledweb/index.php:189 {
› $application->bootstrap()
› ->run();
›
}
}
}
trace: {
/var/www/html/demasledweb/library/Zend/Db/Statement/Pdo.php:234 {
Zend_Db_Statement_Pdo->_execute(array $params = null) …
› require_once 'Zend/Db/Statement/Exception.php';
› throw new Zend_Db_Statement_Exception($e->getMessage(), (int) $e->getCode(), $e);
› }
}
/var/www/html/demasledweb/library/Zend/Db/Statement.php:300 {
Zend_Db_Statement->execute(array $params = null) …
› if ($this->_queryId === null) {
› return $this->_execute($params);
› }
arguments: {
$params: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Adapter/Abstract.php:480 {
Zend_Db_Adapter_Abstract->query($sql, $bind = []) …
› $stmt = $this->prepare($sql);
› $stmt->execute($bind);
›
arguments: {
$params: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Adapter/Pdo/Abstract.php:238 {
Zend_Db_Adapter_Pdo_Abstract->query($sql, $bind = []) …
› try {
› return parent::query($sql, $bind);
› } catch (PDOException $e) {
arguments: {
$sql: """
SELECT SQL_CALC_FOUND_ROWS p.id, `p`.`codigo`, `p`.`imagen`, `p`.`stock_minimo`, `p`.`precio_general`, `p`.`stock_minimo_publicacion`, `p`.`impuesto`, `p`.`url_alias`, `p`.`ps_cantidad_unidad`, "0" as es_combo, `plp`.*, `pi`.`nombre`, `pi`.`descripcion`, `pi`.`meta_keywords`, `pi`.`meta_description`, `pe`.`idcolor`, IFNULL(ci.color, 'No Disponible') AS `color`, MIN( pcc.precio ) AS `precio_desde`, MAX( pcc.precio ) AS `precio_hasta`, SUM(IFNULL( IF(d.ventas_web = 1, ds.stock,0), 0 )) AS `stock`, SUM(IFNULL( IF(d.ventas_web = 1, ds.stock_reservado,0), 0 )) AS `stock_reservado`, IF( ds.stock is null or ds.stock = 0, 0 ,1 ) AS `tiene_stock` FROM `productos` AS `p`\n
INNER JOIN `productos_lineas_producto` AS `plp` ON p.id = plp.idproducto\n
INNER JOIN `productos_idiomas` AS `pi` ON p.id = pi.idproducto\n
LEFT JOIN `productos_etiquetas` AS `pe` ON p.id = pe.idproducto\n
LEFT JOIN `colores_idiomas` AS `ci` ON pe.idcolor = ci.idcolor AND ci.ididioma = 3\n
LEFT JOIN `productos_datos_tecnicos` AS `pdt` ON p.id = pdt.idproducto\n
LEFT JOIN `precios_categoria_cliente` AS `pcc` ON pcc.idproducto = p.id and pcc.idcategoria_cliente=4\n
LEFT JOIN `depositos_stock` AS `ds` ON ds.idproducto = p.id\n
LEFT JOIN `depositos` AS `d` ON d.id = ds.iddeposito WHERE (plp.idlinea_producto in (430,432,433,434,599,600,244,436,245,437,441,246,442,247,440,248,439,143,243) AND p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = 3) GROUP BY `p`.`id` ORDER BY `tiene_stock` DESC, `p`.`codigo` ASC LIMIT 30
"""
$bind: []
}
}
/var/www/html/demasledweb/library/Zend/Db/Adapter/Abstract.php:738 {
Zend_Db_Adapter_Abstract->fetchAll($sql, $bind = [], $fetchMode = null) …
› }
› $stmt = $this->query($sql, $bind);
› $result = $stmt->fetchAll($fetchMode);
arguments: {
$sql: Zend_Db_Select {#168 …}
$bind: []
}
}
/var/www/html/demasledweb/application/demasled/models/ProductoMapper.php:133 {
ProductoMapper->fetchAllPorCategoria($where = null, $order = null, $count = null, $offset = null, $groupby = null) …
›
› $resultSet = $this->getDbTable()->getAdapter()->fetchAll($query);
› return $resultSet;
arguments: {
$sql: Zend_Db_Select {#168 …}
}
}
/var/www/html/demasledweb/application/demasled/controllers/CategoriaController.php:106 {
CategoriaController->indexAction() …
› $tp = $productoMapper->totalIDProductos($where . " p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = " . $this->idioma["id"], null, null, null, 'p.id');
› $productos = $productoMapper->fetchAllPorCategoria($where . " p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = " . $this->idioma["id"], $sql_order_field, $count, $offset, 'p.id');
› $total_products = $productoMapper->countAll();
arguments: {
$where: "plp.idlinea_producto in (430,432,433,434,599,600,244,436,245,437,441,246,442,247,440,248,439,143,243) AND p.mostrar_web = '1' AND p.activo = '1' AND pi.ididioma = 3"
$order: array:2 [ …2]
$count: 30
$offset: 0
$groupby: "p.id"
}
}
/var/www/html/demasledweb/library/Zend/Controller/Action.php:513 {
Zend_Controller_Action->dispatch($action) …
› }
› $this->$action();
› } else {
}
/var/www/html/demasledweb/library/Zend/Controller/Dispatcher/Standard.php:295 {
Zend_Controller_Dispatcher_Standard->dispatch(Zend_Controller_Request_Abstract $request, Zend_Controller_Response_Abstract $response) …
› try {
› $controller->dispatch($action);
› } catch (Exception $e) {
arguments: {
$action: "indexAction"
}
}
/var/www/html/demasledweb/library/Zend/Controller/Front.php:954 {
Zend_Controller_Front->dispatch(Zend_Controller_Request_Abstract $request = null, Zend_Controller_Response_Abstract $response = null) …
› try {
› $dispatcher->dispatch($this->_request, $this->_response);
› } catch (Exception $e) {
arguments: {
$request: Zend_Controller_Request_Http {#68 …}
$response: Zend_Controller_Response_Http {#89 …}
}
}
/var/www/html/demasledweb/library/Zend/Application/Bootstrap/Bootstrap.php:97 {
Zend_Application_Bootstrap_Bootstrap->run() …
› $front->setParam('bootstrap', $this);
› $response = $front->dispatch();
› if ($front->returnResponse()) {
}
/var/www/html/demasledweb/library/Zend/Application.php:366 {
Zend_Application->run() …
› {
› $this->getBootstrap()->run();
› }
}
/var/www/html/demasledweb/index.php:189 {
› $application->bootstrap()
› ->run();
›
}
}
}