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
Try running the upgrade_sql.sql file against your database server manually.
Hi
where is this file upgrade_sql.sql available?
Hello,
The upgrade sql file is available once you unarchive the upgrade package. You can download the package from the GitHub release page: https://github.com/abantecart/abantecart-src/releases.
Please ensure you update the database prefix to match your configuration.
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
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??
Hello,
The upgrade.sql file is the correct one. What error messages are you getting?