Notice: Error: Out of resources when opening file './shoppix_mirobriga/product.MYD' (Errcode: 24 - Too many open files) Error No: 23 SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '2' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '2' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '4640' GROUP BY p.product_id ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0,15 in /home/servidor/public_html/shoppix/webs/mirobriga/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/servidor/public_html/shoppix/webs/mirobriga/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 373Warning: Invalid argument supplied for foreach() in /home/servidor/public_html/shoppix/webs/mirobriga/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 373Notice: Error: Can't open file: './shoppix_mirobriga/attribute_description.frm' (errno: 24 - Too many open files) Error No: 1016
SELECT
`a`.`attribute_id`,
REPLACE(REPLACE(TRIM(pa.text), '
', ''), '
', '') AS `txt`,
`ad`.`name`,
`agd`.`name` AS `gname`,
`agd`.`attribute_group_id`
FROM
`product` AS `p`
INNER JOIN
`product_to_store` AS `pts`
ON
`p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN
`product_attribute` AS `pa`
ON
`p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN
`attribute` AS `a`
ON
`a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN
`attribute_description` AS `ad`
ON
`ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN
`attribute_group` AS `ag`
ON
`ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN
`attribute_group_description` AS `agd`
ON
`agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
INNER JOIN
`product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` = '4640'
GROUP BY
`txt`, `pa`.`attribute_id`
HAVING
`txt` != ''
ORDER BY
`txt`
in /home/servidor/public_html/shoppix/webs/mirobriga/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 2522Warning: Invalid argument supplied for foreach() in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 2522Notice: Error: Can't open file: './shoppix_mirobriga/option_value_description.frm' (errno: 24 - Too many open files) Error No: 1016
SELECT
`o`.`option_id`,
`ov`.`option_value_id`,
`od`.`name` AS `gname`,
`ov`.`image`,
`ovd`.`name`
FROM
`product` AS `p`
INNER JOIN
`product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`product_option_value` AS `pov`
ON
`p`.`product_id` = `pov`.`product_id`
INNER JOIN
`option_value` AS `ov`
ON
`ov`.`option_value_id` = `pov`.`option_value_id`
INNER JOIN
`option_value_description` AS `ovd`
ON
`ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 2
INNER JOIN
`option` AS `o`
ON
`o`.`option_id` = `pov`.`option_id`
INNER JOIN
`option_description` AS `od`
ON
`od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 2
INNER JOIN
`product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` = '4640' AND `o`.`type` IN('radio','checkbox','select','image')
GROUP BY
`o`.`option_id`, `ov`.`option_value_id`
ORDER BY
`ov`.`sort_order`, `ovd`.`name`
in /home/servidor/public_html/shoppix/webs/mirobriga/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 2398Warning: Invalid argument supplied for foreach() in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 2398Notice: Error: Out of resources when opening file './shoppix_mirobriga/filter_description.MYD' (Errcode: 24 - Too many open files) Error No: 23
SELECT
`fgd`.`name` AS `gname`,
`f`.`filter_group_id`,
`f`.`filter_id`,
`fd`.`name`
FROM
`product` AS `p`
INNER JOIN
`product_to_store` AS `p2s`
ON
`p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`product_filter` AS `pf`
ON
`p`.`product_id` = `pf`.`product_id`
INNER JOIN
`filter` AS `f`
ON
`pf`.`filter_id` = `f`.`filter_id`
INNER JOIN
`filter_description` AS `fd`
ON
`pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN
`filter_group_description` AS `fgd`
ON
`f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
INNER JOIN
`product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` = '4640'
GROUP BY
`f`.`filter_group_id`, `f`.`filter_id`
ORDER BY
`f`.`sort_order`, `fd`.`name`
in /home/servidor/public_html/shoppix/webs/mirobriga/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 2295Warning: Invalid argument supplied for foreach() in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 2295Notice: Error: Out of resources when opening file './shoppix_mirobriga/zone_to_geo_zone.MYD' (Errcode: 24 - Too many open files) Error No: 23 SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT ( `price_tmp` * ( 1 + IFNULL(`p_tax`, 0) / 100 ) + IFNULL(`f_tax`, 0) ) AS `price` FROM(
SELECT
IFNULL( (SELECT `price` FROM `product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '2' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1), IFNULL( (SELECT `price` FROM `product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '2' AND `pd2`.`quantity` = '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1), `p`.`price` ) ) AS `price_tmp`
,
(
SELECT
SUM(`tr2`.`rate`)
FROM
`tax_rule` AS `tr1`
LEFT JOIN
`tax_rate` AS `tr2`
ON
`tr1`.`tax_rate_id` = `tr2`.`tax_rate_id`
INNER JOIN
`tax_rate_to_customer_group` AS `tr2cg`
ON
`tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id`
LEFT JOIN
`zone_to_geo_zone` AS `z2gz`
ON
`tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id`
WHERE
`tr1`.`tax_class_id` = `p`.`tax_class_id` AND
`tr2`.`type` = 'F' AND
( (
`tr1`.`based` = 'store' AND
`z2gz`.`country_id` = 195 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '3009'
)
) OR (
`tr1`.`based` = 'payment' AND
`z2gz`.`country_id` = 195 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '3009'
)
) OR (
`tr1`.`based` = 'shipping' AND
`z2gz`.`country_id` = 195 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '3009'
)
) ) AND
`tr2cg`.`customer_group_id` = 2
) AS f_tax
,
(
SELECT
SUM(`tr2`.`rate`)
FROM
`tax_rule` AS `tr1`
LEFT JOIN
`tax_rate` AS `tr2`
ON
`tr1`.`tax_rate_id` = `tr2`.`tax_rate_id`
INNER JOIN
`tax_rate_to_customer_group` AS `tr2cg`
ON
`tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id`
LEFT JOIN
`zone_to_geo_zone` AS `z2gz`
ON
`tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id`
WHERE
`tr1`.`tax_class_id` = `p`.`tax_class_id` AND
`tr2`.`type` = 'P' AND
( (
`tr1`.`based` = 'store' AND
`z2gz`.`country_id` = 195 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '3009'
)
) OR (
`tr1`.`based` = 'payment' AND
`z2gz`.`country_id` = 195 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '3009'
)
) OR (
`tr1`.`based` = 'shipping' AND
`z2gz`.`country_id` = 195 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '3009'
)
) ) AND
`tr2cg`.`customer_group_id` = 2
) AS p_tax
FROM
`product` AS `p`
INNER JOIN
`product_description` AS `pd`
ON
`pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2
INNER JOIN
`product_to_store` AS `p2s`
ON
`p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN
`product_to_category` AS `p2c`
ON
`p2c`.`product_id` = `p`.`product_id`
WHERE
`p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` = '4640'
) AS `tmp` ) AS `tmp` in /home/servidor/public_html/shoppix/webs/mirobriga/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/model/module/mega_filter.php on line 1323Notice: Error: Out of resources when opening file './shoppix_mirobriga/url_alias.MYD' (Errcode: 24 - Too many open files) Error No: 23 SELECT * FROM url_alias WHERE `query` = 'category_id=3396' in /home/servidor/public_html/shoppix/webs/mirobriga/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in /home/servidor/public_html/shoppix/webs/mirobriga/catalog/controller/common/seo_url.php on line 97Fundas :: Mirobriga.net
Las cookies nos permiten ofrecer una mejor experiencia de usuario.
Más informaciónConfigurar
Seleccione la opción de cookies que prefiera para navegar en este sitio:
Funcionales (Obligatorias) Para usos estrictamente necesarios: Estas cookies son esenciales a fin de que usted navegue por el sitio web y utilizar sus funciones, tales como el acceso a áreas seguras del sitio Web, recordar los artículos de tu lista de la compra, recordar en qué punto del pedido se encuentre.
Personalizadas (Opcionales) Estadísticas de Google: Recuperar información no nominal sobre cómo los usuarios navegan en este sitio.
