Messages

[upgrade.sql]

I tried running the upgrade.sql but it returns error messages.
And the name of the file is upgrade.sql not upgrade_sql.sql as Basara mentioned, or maybe i am trying the wrong upgrade file??

I downloaded the file but have noticed that in the file there are commands to drop tables and then create tables while there is information in these tables.
For example:

DROP TABLE IF EXISTS `abc_field_group_to_form`;
CREATE TABLE `abc_field_group_to_form`
(
  `group_id` int(11) DEFAULT NULL,
  `form_id` int(11) DEFAULT NULL,
  `sort_order` int(3) DEFAULT NULL,
  KEY `abc_field_group_to_form_fk` (`form_id`),
  KEY `abc_field_group_to_group_fk` (`group_id`),
  CONSTRAINT `abc_field_group_to_form_fk` FOREIGN KEY (`form_id`) REFERENCES `abc_forms` (`form_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `abc_field_group_to_group_fk` FOREIGN KEY (`group_id`) REFERENCES `abc_field_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


there is no command to insert the data that is already in the table that is in my database

Hi

where is this file  upgrade_sql.sql available?

Hi to all

After i upgraded from version 1.4.2 to version 1.4.3 i have been facing some issues, 2 issues until now and possibly there are more.

1- When o tried to add a new coupon i get error message and the cpupon is not added

2- Also when i tried to add an attribute i get these errors

There has been a critical error processing your request
SQL Error: Column 'attribute_parent_id' cannot be null\nError No: 1048\nSQL: INSERT INTO abc_global_attributes
SET attribute_type_id = 1,
attribute_group_id = NULL,
attribute_parent_id = NULL,
element_type = 'T',
sort_order = 1,
required = 0,
settings = 'a:4:{s:10:\"extensions\";s:0:\"\";s:8:\"min_size\";s:0:\"\";s:8:\"max_size\";s:0:\"\";s:9:\"directory\";s:0:\"\";}',
status = 1,
regexp_pattern = ''PHP call stack:
#0 /home/bethlehe/public_html/core/lib/db.php:138
#1 /home/bethlehe/public_html/core/engine/extensions.php:1174
#2 /home/bethlehe/public_html/core/engine/extensions.php:405
#3 /home/bethlehe/public_html/core/lib/db.php:104
#4 /home/bethlehe/public_html/core/lib/attribute_manager.php:93
#5 /home/bethlehe/public_html/admin/controller/pages/catalog/attribute.php:154
#6 /home/bethlehe/public_html/core/engine/dispatcher.php:306
#7 /home/bethlehe/public_html/core/engine/dispatcher.php:341
#8 /home/bethlehe/public_html/core/engine/page.php:110
#9 /home/bethlehe/public_html/core/engine/router.php:204
#10 /home/bethlehe/public_html/core/engine/router.php:86
#11 /home/bethlehe/public_html/index.php:81
in /home/bethlehe/public_html/core/database/amysqli.php on line 186

3- In the golbal attributes page in the admin panel all attributes are not available / not seen as if there are no attributes. while in the database they are available.

My webmaster checked my website and he says that this due to incorrect tables structure. As i mentioned in the begining that these errors happened after the upgrade from ver 1.4.2 to ver 1.4.3

[To act on behalf of customer in additional store you should to login into another store's admin side. Continue?]

Hi all

I have Abantecart 1.4.2.1 installed and a multistore and i tried to act on behalf of a customer in the second store and i get this message:
To act on behalf of customer in additional store you should to login into another store's admin side. Continue?

When i try to login using the admin of the second store i get a message INVALID TOKEN / SESSION

Any help??

Hello to all

I want to increase the number of characters  in the shipments field, see attached image, and it is by increasing the varchar of the field and i changed it from phpmyadmin. I changed it to VARCHAR(60) and it works in the database but it seems that it should be changed from the extension page and how can i do that.

Thanks in advance

Hi

Also regarding the length, width and height fields in version 1.3.2 is a mandatory field how can set these field not to mandatory.
In some cases i need to show my customer the length and width and don't need the height

In the database the categories are to second store but in the admin panel i don't see them, for both stores i see same categories

I would like to add that i checked the categories in the database tables and they are there and correct and cannot see why the are vanished [do not appear] on the second store

Hi

I have 2 stores with my abantecart and upgraded from v1.2.16 to version 1.3 and then to 1.3.1 and the subdomain store [the second store] categories are not found in the admin panel and also not working on the actual site

Please help me with this issue

Issue solved it was a server side issue

Thanks

Hi

I use the "Weight Based Shipping" extension and was trying to update the prices in the database and when i click the save button i get the below error


There has been a critical error processing your request
SQL Error: Incorrect key file for table './XXXXXXX_aban_bcc/abc_settings.MYI'; try to repair it
Error No: 126
SQL: DELETE FROM abc_settings WHERE `group` = 'default_weight' AND `key` = 'default_weight_1_rate' AND `store_id` = '0' PHP call stack: #0 /home/XXXXXXX/public_html/core/lib/db.php:100 #1 /home/XXXXXXX/public_html/core/engine/extensions.php:1176 #2 /home/XXXXXXX/public_html/core/engine/extensions.php:1127 #3 /home/XXXXXXX/public_html/core/lib/db.php:67 #4 /home/XXXXXXX/public_html/admin/model/setting/setting.php:294 #5 /home/XXXXXXX/public_html/extensions/default_weight/admin/controller/pages/extension/default_weight.php:48 #6 /home/XXXXXXX/public_html/core/engine/dispatcher.php:293 #7 /home/XXXXXX/public_html/core/engine/dispatcher.php:328 #8 /home/XXXXXXX/public_html/core/engine/page.php:108 #9 /home/XXXXXX/public_html/core/engine/router.php:176 #10 /home/XXXXXXX/public_html/core/engine/router.php:80 #11 /home/XXXXXXX/public_html/index.php:94 in /home/XXXXXX/public_html/core/database/amysqli.php on line 119

Hi

From what i can see is that fast checkout does not include the shipping cost specifically when there are more than one shipping option.

I have attached screenshots of the Weight-Based-Shipping extension but to see it more clear go to my website >> add small items to cart >> if the total weight is less than 2kg you can choose different shipping costs.

my website is https://www.bethlehemcasting.com
i stopped the fast checkout extension.

Hi

See attached image when fast checkout tested

I just checked it and what i see is that in some cases the cost off shipping is not included in the Fast checkout payment