Recent Posts

Pages: [1] 2 3 ... 10
1
General Support / Help Needed
« Last post by Twinklekapoor on February 08, 2025, 06:18:48 AM »
Hello, I’m an IVF doctor, and I have recently signed up for AbanteCart. I created a Google Analytics account, but it looks like I have two different account IDs. I'm not sure which one I should use with AbanteCart. Should I use one of the account IDs or the Measurement ID? Can someone help me with this?
2
I literally just removed it, it feels very immature and not ready for public use, I chose abantecart over other carts for the fact that it has a visual page builder and it's free, but other than that I am getting used to abantecart, it has everything i need so far, so I will try to mod templates instead
3
Templates / Re: error log on V.1.4.1
« Last post by Basara on February 07, 2025, 06:29:42 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.
4
Templates / Re: error log on V.1.4.1
« Last post by G. O. on February 07, 2025, 06:27:44 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 ?
5
Templates / Re: error log on V.1.4.1
« Last post by abolabo on February 07, 2025, 04:07:07 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.


6
Templates / Re: error log on V.1.4.1
« Last post by 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.*,
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:
7
The page builder is very buggy, you have to actually set the logo for every page and centre it and resize it, which is a terrible design, the body content is not loading at all, it's just empty, there is only a footer and a header, and I am giving up using it.
I think it is terrible not having any visual editor to design the website properly.
How about the blocks? I have to disable blocks for every page? I canno't just change it for every page?

sorry, i don't understand when you write "for every page".
Page Builder has been maden not for "every page". It's a fine tuning tool for case with some static design.
Please describe how you see on this extension, i mean how you using it.
8
The page builder is very buggy, you have to actually set the logo for every page and centre it and resize it, which is a terrible design, the body content is not loading at all, it's just empty, there is only a footer and a header, and I am giving up using it.
I think it is terrible not having any visual editor to design the website properly.
How about the blocks? I have to disable blocks for every page? I canno't just change it for every page?
9
PageBuilder is an extension for fully custom view of page. This mean it totally replace native layout system of AbanteCart, including header,body,footer blocks.
If something does not work - you should to inspect html-code. Just click "code" button </> and see what url of your logo.
Logo is not a block. It's just a link with image inside.
You should compare href on your pagebuilder page and correct logo url.
Just replace it in the modal and save.

P.S.
If you want to return back to native layout page, you can save changes as "preset" and then delete page of PageBuilder (unpublish).
10
I tried this on v.1.4.1 but doesn't worked. how to make the "fixed-top" become active in this case?
Pages: [1] 2 3 ... 10

Powered by SMFPacks Social Login Mod