[Skip to main content](#vessel-content) # (solved) error saving!! ## - **[garzarath](/forum/user/1779-garzarath "View garzarath's Profile")** - [![garzarath's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1779-garzarath "View garzarath's Profile") Topic Author - [ Offline](/forum/user/1779-garzarath) Less More - Posts: 14 - Thank you received: 0 - - [](http://www.webemus.com) - 15 years 6 months ago - 15 years 6 months ago [\#13732](#13732) by [garzarath](/forum/user/1779-garzarath "View garzarath's Profile") *[(solved) error saving!!](/forum/3-bug-report/13732-solved-error-saving#13732 "Hi, I update today from Essential to Business and was working fine until I realize I can not add new product. After activating Joomla debug I got this: JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`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_access`,`product_group_after_purchase`,`outlet`,`semana`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Messi','','','','Messi','','','','0','-1','0','0','','kg','','','m','','1','all','','No','No','main','0','','1302285456','1302285456' ) So I guess is the 'product_contact' column missing. I have seen the same problem in the forum so I update the 'jos_hikashop_config' and set 'level' back to Essential and repeat the upgrade again. But still the colunm is missing and I don´t not what else to do. I could create the column but need to know the type. Please help !!")* was created by *[garzarath](/forum/user/1779-garzarath "View garzarath's Profile")* Hi, I update today from Essential to Business and was working fine until I realize I can not add new product. After activating Joomla debug I got this: JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`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_access`,`product_group_after_purchase`,`outlet`,`semana`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Messi','','','','Messi','','','','0','-1','0','0','','kg','','','m','','1','all','','No','No','main','0','','1302285456','1302285456' ) So I guess is the 'product_contact' column missing. I have seen the same problem in the forum so I update the 'jos_hikashop_config' and set 'level' back to Essential and repeat the upgrade again. But still the colunm is missing and I don´t not what else to do. I could create the column but need to know the type. Please help !! --- [ www.webemus.com](http://www.webemus.com) Last edit: 15 years 6 months ago by [garzarath](/forum/user/1779-garzarath "View garzarath's Profile"). Reason: Changing status Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMzczMi1zb2x2ZWQtZXJyb3Itc2F2aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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: 86320 - Thank you received: 14276 - - 15 years 6 months ago [\#13739](#13739) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: error saving!!](/forum/3-bug-report/13732-solved-error-saving#13739 "Hi, I update today from Essential to Business and was working fine until I realize I can not add new product. After activating Joomla debug I got this: JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`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_access`,`product_group_after_purchase`,`outlet`,`semana`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Messi','','','','Messi','','','','0','-1','0','0','','kg','','','m','','1','all','','No','No','main','0','','1302285456','1302285456' ) So I guess is the 'product_contact' column missing. I have seen the same problem in the forum so I update the 'jos_hikashop_config' and set 'level' back to Essential and repeat the upgrade again. But still the colunm is missing and I don´t not what else to do. I could create the column but need to know the type. Please help !!")* It's not the 'level' that you need to change but the "version" entry of the jos_hikashop_config table : [ 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=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMzczMi1zb2x2ZWQtZXJyb3Itc2F2aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[garzarath](/forum/user/1779-garzarath "View garzarath's Profile")** - [![garzarath's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1779-garzarath "View garzarath's Profile") Topic Author - [ Offline](/forum/user/1779-garzarath) Less More - Posts: 14 - Thank you received: 0 - - [](http://www.webemus.com) - 15 years 6 months ago [\#13740](#13740) by [garzarath](/forum/user/1779-garzarath "View garzarath's Profile") Replied by *[garzarath](/forum/user/1779-garzarath "View garzarath's Profile")* on topic *[Re: (solved) error saving!!](/forum/3-bug-report/13732-solved-error-saving#13740 "Hi, I update today from Essential to Business and was working fine until I realize I can not add new product. After activating Joomla debug I got this: JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`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_access`,`product_group_after_purchase`,`outlet`,`semana`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Messi','','','','Messi','','','','0','-1','0','0','','kg','','','m','','1','all','','No','No','main','0','','1302285456','1302285456' ) So I guess is the 'product_contact' column missing. I have seen the same problem in the forum so I update the 'jos_hikashop_config' and set 'level' back to Essential and repeat the upgrade again. But still the colunm is missing and I don´t not what else to do. I could create the column but need to know the type. Please help !!")* Thanks it solved --- [ www.webemus.com](http://www.webemus.com) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMzczMi1zb2x2ZWQtZXJyb3Itc2F2aW5nP3RtcGw9bWFya2Rvd24=) 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? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.054 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)