[Skip to main content](#vessel-content) # an error displayed during hikaauction installing ## - **[likunzhou](/forum/user/36539-likunzhou "View likunzhou's Profile")** - [![likunzhou's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36539-likunzhou "View likunzhou's Profile") Topic Author - [ Offline](/forum/user/36539-likunzhou) Less More - Posts: 49 - Thank you received: 0 - - 10 years 1 month ago [\#249070](#249070) by [likunzhou](/forum/user/36539-likunzhou "View likunzhou's Profile") *[an error displayed during hikaauction installing](/forum/52-hikaauction/886264-an-error-displayed-during-hikaauction-installing#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~")* was created by *[likunzhou](/forum/user/36539-likunzhou "View likunzhou's Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUyLWhpa2FhdWN0aW9uLzg4NjI2NC1hbi1lcnJvci1kaXNwbGF5ZWQtZHVyaW5nLWhpa2FhdWN0aW9uLWluc3RhbGxpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 10 years 1 month ago [\#249076](#249076) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[an error displayed during hikaauction installing](/forum/52-hikaauction/886264-an-error-displayed-during-hikaauction-installing#249076 "-- 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~")* 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](http://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzUyLWhpa2FhdWN0aW9uLzg4NjI2NC1hbi1lcnJvci1kaXNwbGF5ZWQtZHVyaW5nLWhpa2FhdWN0aW9uLWluc3RhbGxpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? Moderators: [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.126 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)