- Posts: 49
- Thank you received: 0
an error displayed during hikaauction installing
10 years 1 month ago #249070
by likunzhou
an error displayed during hikaauction installing was created by likunzhou
-- HikaShop version -- : 2.6.4
-- HikaAuction version -- : 1.2.1
-- Joomla version -- : 3.6.2
-- PHP version -- : 7.0.8
-- Browser(s) name and version -- : chrome 53
-- Error-message(debug-mod must be tuned on) -- : an error displayed when I try to install the newest hikaauction component
Hi!
I got an error when I try to install the newest hikaauction component
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `#__hikashop_product` ADD COLUMN `product_auction` INT(10) NOT NULL' at line 1 SQL=ALTER IGNORE TABLE `#__hikashop_product` ADD COLUMN `product_auction` INT(10) NOT NULL DEFAULT '0',ADD COLUMN `product_bid_increment` INT(10) NOT NULL DEFAULT '-1'
Our Mysql Database Version is 5.7.13
Database Collation is utf8_general_ci
Database Connection Collation is utf8mb4_general_ci
Thank you~
-- HikaAuction version -- : 1.2.1
-- Joomla version -- : 3.6.2
-- PHP version -- : 7.0.8
-- Browser(s) name and version -- : chrome 53
-- Error-message(debug-mod must be tuned on) -- : an error displayed when I try to install the newest hikaauction component
Hi!
I got an error when I try to install the newest hikaauction component
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `#__hikashop_product` ADD COLUMN `product_auction` INT(10) NOT NULL' at line 1 SQL=ALTER IGNORE TABLE `#__hikashop_product` ADD COLUMN `product_auction` INT(10) NOT NULL DEFAULT '0',ADD COLUMN `product_bid_increment` INT(10) NOT NULL DEFAULT '-1'
Our Mysql Database Version is 5.7.13
Database Collation is utf8_general_ci
Database Connection Collation is utf8mb4_general_ci
Thank you~
Please Log in or Create an account to join the conversation.
10 years 1 month ago #249076
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic an error displayed during hikaauction installing
Hi,
Please re-download HikaAuction to get a patch on the installer.
"ALTER IGNORE" is still valid regarding the MySQL 5.7 documentation but we had to remove the usage of it in HikaShop due to that kind of error message.
dev.mysql.com/doc/refman/5.7/en/alter-table.html
Regards,
Please re-download HikaAuction to get a patch on the installer.
"ALTER IGNORE" is still valid regarding the MySQL 5.7 documentation but we had to remove the usage of it in HikaShop due to that kind of error message.
dev.mysql.com/doc/refman/5.7/en/alter-table.html
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
Moderators: Mohamed Thelji
Time to create page: 0.151 seconds