[Skip to main content](#vessel-content) # Bug with 1.4.9 version - Error saving ## - **[mett](/forum/user/1080-mett "View mett's Profile")** - [![mett's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1080-mett "View mett's Profile") Topic Author - [ Offline](/forum/user/1080-mett) Less More - Posts: 126 - Thank you received: 2 - - 15 years 6 months ago [\#15294](#15294) by [mett](/forum/user/1080-mett "View mett's Profile") *[Bug with 1.4.9 version - Error saving](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#15294 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* was created by *[mett](/forum/user/1080-mett "View mett's Profile")* Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 15 years 6 months ago [\#15295](#15295) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#15295 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* Please activate the joomla debug mode in the configuration and try again and report back the real error message so that we can give you the solution. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[mett](/forum/user/1080-mett "View mett's Profile")** - [![mett's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1080-mett "View mett's Profile") Topic Author - [ Offline](/forum/user/1080-mett) Less More - Posts: 126 - Thank you received: 2 - - 15 years 6 months ago [\#15300](#15300) by [mett](/forum/user/1080-mett "View mett's Profile") Replied by *[mett](/forum/user/1080-mett "View mett's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#15300 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* Well, the only debug option i can get is this (system administrators restrict some proxy options): JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=UPDATE `jos_hikashop_product` SET `product_name`='Nokia C5-03 graphite black',`product_url`='',`product_meta_description`='',`product_keywords`='',`product_code`='TNOC5-03L',`product_tax_id`='',`product_sale_start`='',`product_sale_end`='',`product_contact`='0',`product_quantity`='-1',`product_min_per_order`='1',`product_max_per_order`='1',`product_weight`='0.000',`product_weight_unit`='kg',`product_length`='0.000',`product_width`='0.000',`product_dimension_unit`='m',`product_height`='0.000',`product_published`='1',`product_access`='all',`product_group_after_purchase`='',`product_type`='main',`product_description`='\r\n I disable the option Product contact in configuration and work fine..but i would like to use this option too. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 15 years 6 months ago [\#15301](#15301) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#15301 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* Ok. You can turn off the debug mode now and follow the instructions on that post: [ www.hikashop.com/support/forum/3-bug-rep...t.html?lang=en#12117](http://www.hikashop.com/support/forum/3-bug-report/12103-error-saving-product.html?lang=en#12117) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[mett](/forum/user/1080-mett "View mett's Profile")** - [![mett's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1080-mett "View mett's Profile") Topic Author - [ Offline](/forum/user/1080-mett) Less More - Posts: 126 - Thank you received: 2 - - 15 years 6 months ago [\#15303](#15303) by [mett](/forum/user/1080-mett "View mett's Profile") Replied by *[mett](/forum/user/1080-mett "View mett's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving \[solved\]](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#15303 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* solved, i added product_contact running an sql query in phpmyadmin: ALTER TABLE `jos_hikashop_product` ADD `product_contact` SMALLINT UNSIGNED DEFAULT 0; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[sax](/forum/user/6223-sax "View sax's Profile")** - [![sax's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6223.jpg)](/forum/user/6223-sax "View sax's Profile") - [ Offline](/forum/user/6223-sax) Less More - Posts: 11 - Thank you received: 0 - - - - 14 years 8 months ago [\#39839](#39839) by [sax](/forum/user/6223-sax "View sax's Profile") Replied by *[sax](/forum/user/6223-sax "View sax's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#39839 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* hi guys, something similar happened to me.. the incriminated column in debug is product_layout.. JDatabaseMySQL::query: 1054 - Unknown column 'product_layout' in 'field list' SQL=INSERT IGNORE INTO `sax_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_sale_start`,`product_sale_end`,`product_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'prova','','','','prova','111','0','','','','-1','0','0','','kg','','','m','','1','main','0',' thanx in advance for ideas bout this ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 8 months ago [\#39840](#39840) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#39840 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* That's because of this: [ www.hikashop.com/en/support/documentatio...lity-issues.html#SQL](http://www.hikashop.com/en/support/documentation/61-hikashop-compatibility-issues.html#SQL) The following user(s) said Thank You: [sax](/forum/user/6223-sax "View sax's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[sax](/forum/user/6223-sax "View sax's Profile")** - [![sax's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6223.jpg)](/forum/user/6223-sax "View sax's Profile") - [ Offline](/forum/user/6223-sax) Less More - Posts: 11 - Thank you received: 0 - - - - 14 years 8 months ago - 14 years 8 months ago [\#39842](#39842) by [sax](/forum/user/6223-sax "View sax's Profile") Replied by *[sax](/forum/user/6223-sax "View sax's Profile")* on topic *[Re: Bug with 1.4.9 version - Error saving \[solved\]](/forum/3-bug-report/15294-bug-with-1-4-9-version-error-saving#39842 "Hello, I just updated Hikashop from 1.4.7 to 1.4.9 and now when i try to "Manage variants" i get this error message: A product with the same code already exists Error saving also, i cannot add new characteristic to product, the new characteristic is not saved to database. How can i solve this problem? Thank you")* thanx, I'll try like showed ![:)](/media/kunena/emoticons/3.png ":)") ......whoooaaaa!!! i love you!!!! perfect! Last edit: 14 years 8 months ago by [sax](/forum/user/6223-sax "View sax's Profile"). Reason: tried with success Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xNTI5NC1idWctd2l0aC0xLTQtOS12ZXJzaW9uLWVycm9yLXNhdmluZz90bXBsPW1hcmtkb3du) or [Create an account](/register) 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? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.071 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)