Hello,
I cannot understand these error reason:
2025-01-24 12:25:38 - App Warning: AbanteCart core v.1.4.1 Cannot to create directory /home/u6047506/public_html/image//thumbnails/19/16. Please check permissions for /home/u6047506/public_html/image/ in /home/u6047506/public_html/core/helper/utils.php on line 1220
2025-01-24 12:26:28 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/u6047506/public_html/resources/image/no_image.jpg . File does not exist. in /home/u6047506/public_html/core/lib/image.php on line 54
2025-01-24 12:30:35 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/u6047506/public_html/resources/image/no_image.jpg . File does not exist. in /home/u6047506/public_html/core/lib/image.php on line 54
2025-01-24 12:30:46 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
how to solve them to stop seeing them in the error log file?
1. open file core/lib/db.php and compare it with this https://github.com/abantecart/abantecart-src/blob/master/public_html/core/lib/db.php#L30
see line 30. Your file must have it.
2. download this file on your host https://github.com/abantecart/abantecart-src/blob/master/public_html/image/no_image.jpg
3. set permissions for directory /home/u6047506/public_html/image and all subdirectories to 755 via cPanel FileManager
that ok but now i get next error:
2025-01-24 14:55:41 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
what is DB_DRIVER name in your system/config.php ?
define('DB_DRIVER', 'amysqli');
do you have some old extensions installed?
Quote from: abolabo on January 24, 2025, 07:47:09 AM
do you have some old extensions installed?
can you be more specific plz?
as i see in the Extensions list there is Germany Pack and Turkish pack aren't compatible with list AbanteCart Version and trying uninstalling it but i cannot because i get a critical error.
this is what i see in the extension note> German Language Pack
This extension is not confirmed to work with your version of AbanteCart. Contact extension developer to confirm compatibility.
Turkish Language Pack
This extension is not confirmed to work with your version of AbanteCart. Contact extension developer to confirm compatibility.
Quote from: G. O. on January 24, 2025, 08:00:08 AM
Quote from: abolabo on January 24, 2025, 07:47:09 AM
do you have some old extensions installed?
can you be more specific plz?
as i see in the Extensions list there is Germany Pack and Turkish pack aren't compatible with list AbanteCart Version and trying uninstalling it but i cannot because i get a critical error.
this is what i see in the extension note> German Language Pack
This extension is not confirmed to work with your version of AbanteCart. Contact extension developer to confirm compatibility.
Turkish Language Pack
This extension is not confirmed to work with your version of AbanteCart. Contact extension developer to confirm compatibility.
Before reporting bug you should to uninstall all incompatible extensions to be sure problem is in the core.
I suspecting the cause is in wrong sql query in some of them.
More information can be available only after debugging.
Cannot answer about the cause.
I did deleted these Extensions from the root and still has the same error log as follow:
2025-01-24 16:36:14 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
Quote from: G. O. on January 24, 2025, 08:38:02 AM
I did deleted these Extensions from the root and still has the same error log as follow:
2025-01-24 16:36:14 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
please provide more details such as:
1. php version
2. database server name and version
3. Is your AbanteCart instance after upgrade process or fresh installation?
4. Did you noted this error on prior version of AbanteCart?
Quote from: abolabo on January 24, 2025, 10:22:53 AM
Quote from: G. O. on January 24, 2025, 08:38:02 AM
I did deleted these Extensions from the root and still has the same error log as follow:
2025-01-24 16:36:14 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
please provide more details such as:
1. php version
2. database server name and version
3. Is your AbanteCart instance after upgrade process or fresh installation?
4. Did you noted this error on prior version of AbanteCart?
1. 8.3 php.
2. Server version: 10.6.20-MariaDB - MariaDB Server.
3. after upgrade.
4. only on last V.1.4.1 appeared.
Quote from: G. O. on January 28, 2025, 02:59:40 AM
Quote from: abolabo on January 24, 2025, 10:22:53 AM
Quote from: G. O. on January 24, 2025, 08:38:02 AM
I did deleted these Extensions from the root and still has the same error log as follow:
2025-01-24 16:36:14 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
please provide more details such as:
1. php version
2. database server name and version
3. Is your AbanteCart instance after upgrade process or fresh installation?
4. Did you noted this error on prior version of AbanteCart?
1. 8.3 php.
2. Server version: 10.6.20-MariaDB - MariaDB Server.
3. after upgrade.
4. only on last V.1.4.1 appeared.
please send access to your files (ssh, ftp, cPanel) via private message.
Cannot to answer without debugging
try to replace your file with this
https://github.com/abantecart/abantecart-src/blob/1.4.2/public_html/core/database/amysqli.php
and let us know
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
max_user_connections looks like DDoS attack
Quote from: abolabo on January 31, 2025, 05:34:46 AM
max_user_connections looks like DDoS attack
to Kill Active Connections i tried next command on phpmyadmin
KILL process_id;
but doesn't worked
What to do?
try to run
SHOW PROCESSLIST;
to see what sql-queries on hold
Quote from: abolabo on February 04, 2025, 06:11:23 AM
try to run
SHOW PROCESSLIST;
to see what sql-queries on hold
here what i get as showing in the attached screenshots :
Quote from: G. O. on February 04, 2025, 06:45:35 AM
Quote from: abolabo on February 04, 2025, 06:11:23 AM
try to run
SHOW PROCESSLIST;
to see what sql-queries on hold
here what i get as showing in the attached screenshots :
you are not under ddos or scanning now.
Try to notice when error arrears and look processlist in that time.
All looks like somebody scan your host periodically or sends invalid post-requests.
this part of sql-query you posted is very suspicious
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'
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:
Quote from: G. O. on February 07, 2025, 02:11:43 AM
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.*,
#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:
this huge sql error is NOT a cause. Cause is in high load of web-server.
max_user_connections directive is MYSQL directive. This is not an AbanteCart code.
For example your mysql server have limitation for 100 connections at the same time. This mean 100 customers opened your cart at the same time. And next 101 will be a cause of error in the your log file.
Sql-query is not a cause.
How many users do you have?
Can you look into table customer_sessions?
Do you have enabled google analitycs? Did you see some spikes on report plots?
Probably mysql server have a glitch and do not automatic close of lost connections. have no ideas anymore.
I think you should your hosting provider support about this situation.
Quote from: abolabo on February 07, 2025, 04:07:07 AM
Quote from: G. O. on February 07, 2025, 02:11:43 AM
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.*,
#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:
this huge sql error is NOT a cause. Cause is in high load of web-server.
max_user_connections directive is MYSQL directive. This is not an AbanteCart code.
For example your mysql server have limitation for 100 connections at the same time. This mean 100 customers opened your cart at the same time. And next 101 will be a cause of error in the your log file.
Sql-query is not a cause.
How many users do you have?
Can you look into table customer_sessions?
Do you have enabled google analitycs? Did you see some spikes on report plots?
Probably mysql server have a glitch and do not automatic close of lost connections. have no ideas anymore.
I think you should your hosting provider support about this situation.
is there any way to increase the 'max_user_connections' value ?
Quote from: G. O. on February 07, 2025, 06:27:44 AM
is there any way to increase the 'max_user_connections' value ?
Hello.
Yes, it is possible to increase that value, but it is not related to AbanteCart. Instead, it depends on the hosting service provider or server configuration.
Quote from: G. O. on January 24, 2025, 06:57:47 AM
that ok but now i get next error:
2025-01-24 14:55:41 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
solved. Please apply this patch to core/database/amysqli.php file
https://github.com/abantecart/abantecart-src/commit/5d2206dc3f1d29454c86d39ce7938d66a245d4d4
Quote from: abolabo on February 28, 2025, 07:20:04 AM
Quote from: G. O. on January 24, 2025, 06:57:47 AM
that ok but now i get next error:
2025-01-24 14:55:41 - 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/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
solved. Please apply this patch to core/database/amysqli.php file
https://github.com/abantecart/abantecart-src/commit/5d2206dc3f1d29454c86d39ce7938d66a245d4d4
Thank you Sir, are you planning to upgrade this file in next version too or i should upgrade it now?
fix is already in current development version 1.4.2.
Hope release will be soon.
Certainly. All above told the truth. We can communicate on this theme.