MYSQL ERROR REPORT
- 28/03/2024 19:03:56
---------------------------------------
2006 - MySQL server has gone away
select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
INNER JOIN products_specifications ps31 ON p.products_id = ps31.products_id
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
AND ps31.specification in ('21 (33 RU)'
, '15,5(25 RU)'
) AND ps31.specifications_id = '31'
AND ps31.language_id = '1'
and p2c.categories_id = '687'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC LIMIT 0, 21
---------------------------------------
Server Name : xn--80adnhbq3g0a.xn--p1ai
Remote Address: 18.233.223.189
Referer :
Requested : /products_filter.php?cPath=685_123_687&cat=687&f31%5B0%5D=21+%2833+RU%29&f31%5B1%5D=15%2C5%2825+RU%29
Trace Back : #0 vam_db_error(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
INNER JOIN products_specifications ps31 ON p.products_id = ps31.products_id
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
AND ps31.specification in ('21 (33 RU)'
, '15,5(25 RU)'
) AND ps31.specifications_id = '31'
AND ps31.language_id = '1'
and p2c.categories_id = '687'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC LIMIT 0, 21, 2006, MySQL server has gone away) called at [/home/buyskiing/web/вашилыжи.рф/public_html/inc/vam_db_query.inc.php:34]
#1 vam_db_query(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
INNER JOIN products_specifications ps31 ON p.products_id = ps31.products_id
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
AND ps31.specification in ('21 (33 RU)'
, '15,5(25 RU)'
) AND ps31.specifications_id = '31'
AND ps31.language_id = '1'
and p2c.categories_id = '687'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC LIMIT 0, 21) called at [/home/buyskiing/web/вашилыжи.рф/public_html/includes/application_top.php:210]
#2 vamDBquery(select distinct p.products_id,
p.products_fsk18,
p.products_shippingtime,
p.products_model,
pd.products_name,
p.products_ean,
p.products_price,
p.products_tax_class_id,
m.manufacturers_name,
p.products_quantity,
p.products_image,
p.products_weight,
pd.products_short_description,
pd.products_description,
p.products_id,
p.manufacturers_id,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
,
if(ISNULL(s.specials_new_products_price), 0, 1) AS specials_price_sort_flag,
if(ISNULL(s.specials_new_products_price), 0, (1-s.specials_new_products_price/p.products_price)) AS specials_price_discount,
COUNT(*) AS ordered_count,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price,
IF(p.products_quantity > 0, 1, 0) AS products_on_stock_flag,
IF(p.products_shippingtime > 0, 1, 0) AS products_shippingtime_flag
from
products p
left join specials s
on p.products_id = s.products_id
left join manufacturers m
on p.manufacturers_id = m.manufacturers_id
join products_description pd
on p.products_id = pd.products_id
join products_to_categories p2c
on p.products_id = p2c.products_id
left join orders_products op on (p.products_id = op.products_id)
INNER JOIN products_specifications ps31 ON p.products_id = ps31.products_id
where
p.products_status = '1'
/* and p.products_quantity > 0 */
and pd.language_id = '1'
AND ps31.specification in ('21 (33 RU)'
, '15,5(25 RU)'
) AND ps31.specifications_id = '31'
AND ps31.language_id = '1'
and p2c.categories_id = '687'
GROUP BY p.products_id ORDER BY products_on_stock_flag desc, p.products_ordered desc, p.products_price ASC LIMIT 0, 21) called at [/home/buyskiing/web/вашилыжи.рф/public_html/includes/modules/product_listing.php:110]
#3 include(/home/buyskiing/web/вашилыжи.рф/public_html/includes/modules/product_listing.php) called at [/home/buyskiing/web/вашилыжи.рф/public_html/products_filter.php:404]