Show Posts


Messages - G. O.

Pages: [1] 2 3 ... 9
1
General Discussion / Re: Avatar on v.1.4.1
« on: March 20, 2025, 09:14:15 AM »
Quote from: Basara on March 20, 2025, 08:47:08 AM
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

2
General Discussion / Avatar on v.1.4.1
« on: March 20, 2025, 08:33:11 AM »
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

3
Customization help / Re: Navbar on v.1 4.1
« on: February 25, 2025, 07:15:27 AM »
hi guys,

any one could help please?

4
Customization help / Re: Navbar on v.1 4.1
« on: February 21, 2025, 04:38:59 AM »
Quote from: Basara on February 21, 2025, 03:05:07 AM
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 ?

5
Customization help / Re: Navbar on v.1 4.1
« on: February 21, 2025, 01:39:51 AM »
need your help please.

6
Customization help / Navbar on v.1 4.1
« on: February 19, 2025, 05:49:41 AM »
Hello,

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

7
Templates / Re: error log on V.1.4.1
« on: February 07, 2025, 06:27:44 AM »
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 ?

8
Templates / Re: error log on V.1.4.1
« 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:

9
Tips and Tricks / Re: some tricks for fixed navbar and displaying products according to screen size
« on: February 05, 2025, 02:59:28 AM »
I tried this on v.1.4.1 but doesn't worked. how to make the "fixed-top" become active in this case?

10
Templates / Re: error log on V.1.4.1
« 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 :

11
Templates / Re: error log on V.1.4.1
« on: February 04, 2025, 05:26:25 AM »
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?

12
Configuration / Re: How do I remove clutter on index page?
« on: February 01, 2025, 01:52:38 AM »
hi!

What ever you want to add or remove all you can find in one place.
 in your admin dashboard go to: Design > Layouts and there you can add or remove any block you see. you can turn off or turn on or delete them as you want.

13
Templates / Re: error log on V.1.4.1
« on: January 31, 2025, 02:02:39 AM »
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

14
Templates / Re: Categories and sub-categories contains cannot be found on V.1.4.1
« on: January 29, 2025, 02:49:34 AM »
Quote from: Basara on January 28, 2025, 09:51:13 AM
To access a category using the /eShops handle, follow these steps:

1. Add "eShops" to the category SEO key (use "eshops" if your server does not support capital letters).
2. Configure the .htaccess file in the root of your AbanteCart store with the next content.
3. Enable SEO URLs in the AbanteCart admin.

If SEO URLs are still not working, contact your hosting support for assistance with mod_rewrite or .htaccess rules.


Thank you Sir, I did rechanged the links contains from capital letters to small and that solved but still we have one issue when you trying to reach to some sub-categories such like eShops which you see in my screenshot. kindly give it a try from your PC and let me how to fix that issue to reach that sub-category from PC by scrolling down by MOUSE indicator .

15
Templates / Re: Categories and sub-categories contains cannot be found on V.1.4.1
« on: January 28, 2025, 09:42:46 AM »
Quote from: Basara on January 28, 2025, 09:37:24 AM
Hello.
I just visited your site, and the category links are now working. https://www.globaloverline.com/index.php?rt=product/category&path=24

if you are visiting the links from site map then you will get the page through this link: https://www.globaloverline.com/index.php?rt=product/category&path=24

but if you try to visit the category though this link: https://www.globaloverline.com/eShops then you will get 404 error.

tha is what am talking about in my issue

Pages: [1] 2 3 ... 9

Powered by SMFPacks Social Login Mod