an error displayed during hikaauction installing

  • Posts: 49
  • Thank you received: 0
8 years 2 months ago #249070

-- 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.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 2 months ago #249076

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Moderators: Mohamed Thelji
Time to create page: 0.059 seconds
Powered by Kunena Forum