here what i get in the error log when i just click on delete cache memory:
2025-02-07 9:51:53 - App Error: AbanteCart core v.1.4.1 Cannot establish database connection to u6047506_lnqm1 using u6047506_lnqm1@localhost
User u6047506_lnqm1 already has more than 'max_user_connections' active connections
Trace:
#0 /home/u6047506/public_html/core/lib/db.php on line 64
#1 /home/u6047506/public_html/core/init.php on line 354
#2 /home/u6047506/public_html/index.php on line 60
2025-02-07 9:53:14 - 1226: User 'u6047506_lnqm1' has exceeded the 'max_user_connections' resource (current value: 50)
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 '%7532%' OR LCASE(pt.tag) = '7532' ) AND p.status = '1' AND p.date_available <= NOW()
GROUP BY p.product_id ORDER BY p.date_modified ASC LIMIT 0,20
2025-02-07 9:53:14 - 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 '%6465%' OR LCASE(pt.tag) = '6465' ) AND p.status = '1' AND p.date_available <= NOW()
GROUP BY p.product_id ORDER BY p.date_modified ASC LIMIT 20,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 162
website intreface has next error as in the screenshot:
