i placed that file and i get now next errors:
2025-01-31 9:28:08 - 1203: User u6047506_lnqm1 already has more than 'max_user_connections' active connections
SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*,
p.product_id,
COALESCE( ( SELECT CASE WHEN p2sp.price_prefix='%' THEN p.price - (p2sp.price * (p.price/100))
ELSE p2sp.price END as special_price
FROM fuw2_product_specials p2sp
WHERE p2sp.product_id = p.product_id
AND p2sp.customer_group_id = '2'
AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW())
AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW()))
ORDER BY p2sp.priority ASC, special_price ASC LIMIT 1
) , p.price) as final_price,
pd.name AS name,
pd.blurb,
m.name AS manufacturer,
ss.name AS stock,
( SELECT FLOOR(AVG(r.rating))
FROM fuw2_reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating ,
( SELECT COUNT(rw.review_id)
FROM fuw2_reviews rw
WHERE p.product_id = rw.product_id AND rw.status = 1
GROUP BY rw.product_id
) AS review
FROM fuw2_products p
LEFT JOIN fuw2_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN fuw2_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fuw2_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN fuw2_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1')
LEFT JOIN fuw2_product_tags pt
ON (p.product_id = pt.product_id)
WHERE p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%810¤cy=try¤cy=usd¤cy=try¤cy=gbp¤cy=gbp¤cy=gbp¤cy=eur¤cy=usd¤cy=try¤cy=gbp¤cy=usd¤cy=usd¤cy=gbp¤cy=eur¤cy=usd¤cy=eur%' OR LCASE(pt.tag) = '810¤cy=try¤cy=usd¤cy=try¤cy=gbp¤cy=gbp¤cy=gbp¤cy=eur¤cy=usd¤cy=try¤cy=gbp¤cy=usd¤cy=usd¤cy=gbp¤cy=eur¤cy=usd¤cy=eur' ) AND p.status = '1' AND p.date_available <= NOW()
GROUP BY p.product_id ORDER BY LCASE(pd.name) ASC LIMIT 0,20
2025-01-31 9:28:08 - database error: AbanteCart core v.1.4.1 SQL Error: MySQL server has gone away\nError No: 2006\nSQL: SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*,
p.product_id,
COALESCE( ( SELECT CASE WHEN p2sp.price_prefix='%' THEN p.price - (p2sp.price * (p.price/100))
ELSE p2sp.price END as special_price
FROM fuw2_product_specials p2sp
WHERE p2sp.product_id = p.product_id
AND p2sp.customer_group_id = '2'
AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW())
AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW()))
ORDER BY p2sp.priority ASC, special_price ASC LIMIT 1
) , p.price) as final_price,
pd.name AS name,
pd.blurb,
m.name AS manufacturer,
ss.name AS stock,
( SELECT FLOOR(AVG(r.rating))
FROM fuw2_reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating ,
( SELECT COUNT(rw.review_id)
FROM fuw2_reviews rw
WHERE p.product_id = rw.product_id AND rw.status = 1
GROUP BY rw.product_id
) AS review
FROM fuw2_products p
LEFT JOIN fuw2_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN fuw2_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN fuw2_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN fuw2_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1')
LEFT JOIN fuw2_product_tags pt
ON (p.product_id = pt.product_id)
WHERE p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%810¤cy=try¤cy=usd¤cy=try¤cy=gbp¤cy=gbp¤cy=gbp¤cy=eur¤cy=usd¤cy=try¤cy=gbp¤cy=usd¤cy=usd¤cy=gbp¤cy=eur¤cy=usd¤cy=eur%' OR LCASE(pt.tag) = '810¤cy=try¤cy=usd¤cy=try¤cy=gbp¤cy=gbp¤cy=gbp¤cy=eur¤cy=usd¤cy=try¤cy=gbp¤cy=usd¤cy=usd¤cy=gbp¤cy=eur¤cy=usd¤cy=eur' ) AND p.status = '1' AND p.date_available <= NOW()
GROUP BY p.product_id ORDER BY LCASE(pd.name) ASC LIMIT 0,20PHP call stack:
#0 /home/u6047506/public_html/core/lib/db.php:119
#1 /home/u6047506/public_html/core/engine/extensions.php:1159
#2 /home/u6047506/public_html/core/engine/extensions.php:390
#3 /home/u6047506/public_html/core/lib/db.php:85
#4 /home/u6047506/public_html/storefront/model/catalog/product.php:727
#5 /home/u6047506/public_html/storefront/controller/pages/product/search.php:140
#6 /home/u6047506/public_html/core/engine/dispatcher.php:306
#7 /home/u6047506/public_html/core/engine/dispatcher.php:341
#8 /home/u6047506/public_html/core/engine/page.php:110
#9 /home/u6047506/public_html/core/engine/router.php:204
#10 /home/u6047506/public_html/core/engine/router.php:86
#11 /home/u6047506/public_html/index.php:101
in /home/u6047506/public_html/core/database/amysqli.php on line 163
2025-01-31 9:28:23 - Unknown Error: AbanteCart core v.1.4.1 Call to undefined method db_result_meta::fetch_object()
Trace:
#0 /home/u6047506/public_html/core/lib/db.php(119): AMySQLi->query()
#1 /home/u6047506/public_html/core/engine/extensions.php(1159): ADB->_query()
#2 /home/u6047506/public_html/core/engine/extensions.php(390): ExtensionsApi->__ExtensionsApiCall()
#3 /home/u6047506/public_html/core/lib/db.php(85): ExtensionsApi->__call()
#4 /home/u6047506/public_html/storefront/model/catalog/product.php(727): ADB->query()
#5 /home/u6047506/public_html/storefront/controller/pages/product/search.php(140): ModelCatalogProduct->getFilteredProducts()
#6 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerPagesProductSearch->main()
#7 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#8 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#9 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#10 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#11 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#12 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 137
