11
« on: January 28, 2023, 03:27:15 PM »
I have..
I tried the following, setup a new cart (1.3.2) and tried to import the data into it from the old cart (1.3.3) where the product feature is not working using csv file format to narrow down any issues.
What does this SQL error means (see below). Its coming up during import of products.csv file. This error repeated 44 times during import.
I disabled Mercato theme and tried default theme, but looks like his theme has screwed up the code somehow. Even if you disable it, I still can not add options to any products. His theme is also creating another error at the store front (Please check my communication with him at the market place). At store front /aromecity.com/shop I am also seeing this error (This product has a limit set to %s item(s) per order)
Do any of the AbanteCart cart main developer check extensions before they get published into the market place? if not, we better implement some mechanism. Also look at my suggestions for release 2.0 I provided in a seperate thread to @Basara
Please note as I said before, the products where I created options before still appear, but even if you go back to old products where you previously created the options, you still can't add any new ones.
I think Mercato theme has screwed up something. The developer is horrible in providing any support. Feels like I wasted $80 dollars over a theme. He doesn't respond for days and provides very short answers and no documentation is available. How do I get my money back?
--------------------------------------------------------------
2023-01-28 20:24:59 - update data error in resource_descriptions. SQL Error: Unknown column 'price_prefix' in 'field list'
Error No: 1054
SQL: INSERT INTO `ab_product_specials` SET `product_special_id` = '1', `product_id` = '12', `customer_group_id` = '1', `priority` = '1', `price_prefix` = '$', `price` = '35.0000', `date_start` = '2023-01-22', `date_end` = '2023-12-31', `date_added` = '0000-00-00 00:00:00', `date_modified` = '2023-01-23 10:13:29'
-------------------------------------------------------------
Also getting this error message when importing "resource_types.csv
2023-01-28 20:41:19 - update data error in resource_descriptions. SQL Error: Duplicate entry '100154-products-8' for key 'PRIMARY'
Error No: 1062
SQL: INSERT INTO `ab_resource_map` SET `resource_id` = '100154', `object_name` = 'products', `object_id` = '8', `default` = '0', `sort_order` = '1', `date_added` = '2023-01-21 01:32:58', `date_modified` = '2023-01-21 01:32:58'