Skip to main content

an error displayed during hikaauction installing

More
10 years 1 month ago #249070 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~

Please Log in or Create an account to join the conversation.

More
10 years 1 month ago #249076 by Jerome
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,

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.136 seconds
Powered by Kunena Forum