Various Error messages

[AromeCity]

Hi,

I am experiencing all kinds of error messages with the new versions of AbanteCart cart such 1.4.1. and 1.4.2.

1. Issue one, I successfully updated AbanteCart cart to 1.4.2 but when you log into the admin panel at the bottom it still says 1.4.1. Not sure why.

2. Now when I try to create a category, I am getting following error message. I have 4 AbanteCart cart installed under 2 domains and each giving various error log messages.

=======================
ERRO LOG OF ONE DOMAIN. Version 1.4.2

2025-05-19 17:16:40 - 1054: Unknown column 'supplier_code' in 'field list'
INSERT INTO ab_categories
SET parent_id = '0',
sort_order = '0',
status = '1',
supplier_code = NULL,
supplier_id = NULL,
date_modified = NOW(),
date_added = NOW()

===============================
ERROR LOG UNDER ANOTEHR DOMAIN Version 1.4.2

SQL Error: Unknown column 'supplier_code' in 'field list'\nError No: 1054\nSQL: INSERT INTO wv4w_categories
SET parent_id = '0',
sort_order = '0',
status = '1',
supplier_code = NULL,
supplier_id = NULL,
date_modified = NOW(),
date_added = NOW()PHP call stack:
#0 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/lib/db.php:138
#1 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/extensions.php:1175
#2 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/extensions.php:406
#3 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/lib/db.php:104
#4 /home/solucompcp/public_html/www.telcosupplies.com/shop/admin/model/catalog/category.php:39
#5 /home/solucompcp/public_html/www.telcosupplies.com/shop/admin/controller/pages/catalog/category.php:296
#6 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/dispatcher.php:308
#7 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/dispatcher.php:343
#8 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/page.php:110
#9 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/router.php:204
#10 /home/solucompcp/public_html/www.telcosupplies.com/shop/core/engine/router.php:86
#11 /home/solucompcp/public_html/www.telcosupplies.com/shop/index.php:95



Can someone assist?

Thanks

[abolabo]

you should to run sql queries manually via phpMyAdmin.
Regarding error i guess you should to start since line 1091
https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql#L1091

Do not forget to replace table prefix with yours before

[AromeCity]

@abolabo

I am not following your instructions.

These error messages are coming up:

When I am creating a category using the admin panel. Why do I have to go down to the code level?

Sorry, I am really confused.

[Basara]

@abolabo

I am not following your instructions.

These error messages are coming up:

When I am creating a category using the admin panel. Why do I have to go down to the code level?

Sorry, I am really confused.

It looks like your upgrade wasn't fully completed, which is why you're seeing version 1.4.1 in the footer and encountering SQL errors due to a missing database upgrade.

[AromeCity]

This is very confusing. If you look at the install logs. See enclosed image it says version 1.4.2 was successful.

As you cannot uninstall 1.4.2 and whatever got installed under 1.4.2 during the upgrade how do we fix that?

[AromeCity]

@abolabo

There is for sure some kind of bug in the 1.4.2 upgrade script.

See screen shot.

1. I restored the cart using a backup and restored it back to 1.4.0.

2. Performed 1.4.1 upgrade using admin panel. No issues.

3. When you upgrade to 1.4.2 via admin panel you get this error message. See enclosed.

Interestingly, under Install/Upgrade history it says updated to 1.4.2 which makes no sense.

We modified the MY SQL Settings to eliminate any SQL time out time out errors but still the same.

[Basara]

Hello
Please review the AbanteCart error log to identify the relevant SQL error

[AromeCity]

Not sure what this has to do with upgrade to 1.4.2?

2025-05-22 11:46:56 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/e.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/e.jpg. Try to decrease original image size 3000x3000px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:56 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/d.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/d.jpg. Try to decrease original image size 3000x3000px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:56 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/8.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/8.jpg. Try to decrease original image size 3000x3000px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:56 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/c.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/c.jpg. Try to decrease original image size 3000x3000px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:56 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/a.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/a.jpg. Try to decrease original image size 3000x3000px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:56 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/9.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/84/9.jpg. Try to decrease original image size 3000x3000px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:59 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/7b/f.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/7b/f.jpg. Try to decrease original image size 751x815px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

2025-05-22 11:46:59 - error: AbanteCart core v.1.4.1 Allowed memory size of 13631488 bytes exhausted (tried to allocate 32768 bytes) in /home/solucompcp/public_html/www.aromecity.com/shop/extensions/novator/storefront/view/novator/template/common/resource_image.tpl on line 1

2025-05-22 11:47:00 - App Warning: AbanteCart core v.1.4.1 Error: Cannot load image /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/7c/c.jpg. Unable to create internal image from file /home/solucompcp/public_html/www.aromecity.com/shop/resources/image/18/7c/c.jpg. Try to decrease original image size 787x957px or reduce file size or increase memory limit for PHP. in /home/solucompcp/public_html/www.aromecity.com/shop/core/lib/image.php on line 72

[Basara]

Hello.

This issue is most likely not related to the upgrade to 1.4.2. The error you’re seeing usually happens when the server doesn’t have enough available memory or CPU resources at the time the image is being processed.