Messages

Hi, if your html-description is too big for database saving try to save this as html-file. You can create some subfolder for such huge descriptions.
Then add iframe tag into your product description with source url to this file.

I already have the same code and page on other website with the same version of cart and php and working fine.

Hello,

i have along html code for FAQ page which i wanna paste to (product descriptions) field but the code saving not completely. I check the database product_descriptions table and it was on LONGTEXT but doesn't worked. What to do ?
I use Abantecart v.1.4.1 NOVATOR
php 8.3

Hello
After uploading the new logo in the admin panel, please check if there are any related errors in the AbanteCart error log. Also, let us know if the logo update is visible in the admin area.
Feel free to attach the logo file so we can take a closer look.

hi,

I don't have an idea why that issue been but i did copied the original folders and uploaded them with the classical way through FTP. I thing the reason behind it internet speed or something related to the clone process and transferring the data from one to other.


Any way, my issue SOLVED this way.

Hello.

It's possible that the logo is not updating because the resources/ or image/thumbnails/ folders in AbanteCart do not have the correct write permissions.

AbanteCart needs write access to these directories to update and generate new logo images. If these folders are not writable, the new logo won't replace the old one.

i already checked all this too and the permissions for these folders and their contains set on 777

Hello.
In the context of AbanteCart, the term "avatar logo" might not be a standard feature, as AbanteCart typically refers to store logos, favicon, or user avatars separately. Could you clarify what you mean by "avatar logo"?
Are you referring to the store logo that appears on the website header?
Or do you mean the favicon (the small icon in the browser tab)?

yes sir, website logo i mean

Hello,

I did cloned website to other domain but when i tried to change the website avatar it is not refreshing to new uploaded website avatar logo and still showing the old one. i did deleted the web cache and browser caches but not solved.

I use the default AbanteCart theme v.1.4.1 with php v.8.3
website: wwwdotabcoxtexdotcom


thank you

hi guys,

any one could help please?

Hello.
If you're using Bootstrap theme, you can keep the navbar fixed at the top of the page by adding the fixed-top class to the element.

i did edited the header.tpl and style.css but doesn't worked. could you guide me please which files should be edited ?

need your help please.

Hello,

how to keep the Navbar fixed on the header of page on v.1 4.1?

[here what i get in the error log when i just click on delete cache memory:]

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 ?

[here what i get in the error log when i just click on delete cache memory:]

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:

I tried this on v.1.4.1 but doesn't worked. how to make the "fixed-top" become active in this case?

try to run
SHOW PROCESSLIST;
to see what sql-queries on hold

here what i get as showing in the attached screenshots :

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?