[Skip to main content](#vessel-content) # Problem Saving New Products and/or editing old! ## - **[fantomet](/forum/user/15984-fantomet "View fantomet's Profile")** - [![fantomet's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15984-fantomet "View fantomet's Profile") Topic Author - [ Offline](/forum/user/15984-fantomet) Less More - Posts: 10 - Thank you received: 0 - - 13 years 6 months ago [\#97281](#97281) by [fantomet](/forum/user/15984-fantomet "View fantomet's Profile") *[Problem Saving New Products and/or editing old!](/forum/3-bug-report/79929-problem-saving-new-products-and-or-editing-old#97281 "Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before?")* was created by *[fantomet](/forum/user/15984-fantomet "View fantomet's Profile")* Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTkyOS1wcm9ibGVtLXNhdmluZy1uZXctcHJvZHVjdHMtYW5kLW9yLWVkaXRpbmctb2xkP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 13 years 6 months ago [\#97313](#97313) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problem Saving New Products and/or editing old!](/forum/3-bug-report/79929-problem-saving-new-products-and-or-editing-old#97313 "Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before?")* Hi, Turn on the debug mode of the joomla configuration and that should display an error message with more information on the issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTkyOS1wcm9ibGVtLXNhdmluZy1uZXctcHJvZHVjdHMtYW5kLW9yLWVkaXRpbmctb2xkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fantomet](/forum/user/15984-fantomet "View fantomet's Profile")** - [![fantomet's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15984-fantomet "View fantomet's Profile") Topic Author - [ Offline](/forum/user/15984-fantomet) Less More - Posts: 10 - Thank you received: 0 - - 13 years 6 months ago [\#97325](#97325) by [fantomet](/forum/user/15984-fantomet "View fantomet's Profile") Replied by *[fantomet](/forum/user/15984-fantomet "View fantomet's Profile")* on topic *[Problem Saving New Products and/or editing old!](/forum/3-bug-report/79929-problem-saving-new-products-and-or-editing-old#97325 "Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before?")* This is the error message I got! > Joomla! > 500 - Ett fel har inträffat > > JDatabaseMySQLi::query: 1054 - Unknown column 'product\_canonical' in 'field list' SQL=INSERT IGNORE INTO `jos\_allergeko\_se\_hikashop\_product` ( `product\_name`,`product\_url`,`product\_meta\_description`,`product\_keywords`,`product\_page\_title`,`product\_alias`,`product\_code`,`product\_tax\_id`,`product\_manufacturer\_id`,`product\_layout`,`product\_quantity`,`product\_min\_per\_order`,`product\_max\_per\_order`,`product\_sale\_start`,`product\_sale\_end`,`product\_canonical`,`product\_msrp`,`product\_weight`,`product\_weight\_unit`,`product\_length`,`product\_width`,`product\_dimension\_unit`,`product\_height`,`product\_published`,`product\_type`,`product\_description`,`product\_modified`,`product\_created` ) VALUES ( 'Veggie Spread Basilika','','','','','','Veggie\_Spread\_Basilika','11','0','','-1','0','0','','','','','','kg','','','m','','1','main',' > > Glutenfri, mjölkfri, sojafri pålägg med Basilika 180g eller 50g > \\r\\n > > Veggie Spread > \\r\\n > > Ingredienser: Solrosfrö 39%, solrosolja\*, vatten, citronsaft\*, basilika\*(7%), lök, havsalt > \\r\\n > > \*= ekologisk ingrediens > ','1364894859','1364894859' ) > > Tillbaka till kontrollpanel > > Call stack > \# Function Location > 1 JAdministrator->dispatch() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/index.php:46 > 2 JComponentHelper::renderComponent() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/includes/application.php:153 > 3 JComponentHelper::executeComponent() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/libraries/joomla/application/component/helper.php:351 > 4 require\_once() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/libraries/joomla/application/component/helper.php:383 > 5 hikashopController->execute() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/hikashop.php:54 > 6 JController->execute() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/helpers/helper.php:1217 > 7 hikashopController->apply() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/libraries/joomla/application/component/controller.php:761 > 8 hikashopController->store() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/helpers/helper.php:1003 > 9 hikashopProductClass->saveForm() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/helpers/helper.php:1067 > 10 hikashopProductClass->save() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/classes/product.php:204 > 11 hikashopClass->save() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/classes/product.php:463 > 12 JDatabase->query() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/administrator/components/com\_hikashop/helpers/helper.php:1268 > 13 JDatabaseMySQLi->execute() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/libraries/joomla/database/database.php:1253 > 14 JError::raiseError() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/libraries/joomla/database/database/mysqli.php:396 > 15 JError::raise() /www/webvol18/ww/ptsfxurssnviz7y/allergeko.se/public\_html/libraries/joomla/error/error.php:251 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTkyOS1wcm9ibGVtLXNhdmluZy1uZXctcHJvZHVjdHMtYW5kLW9yLWVkaXRpbmctb2xkP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 13 years 6 months ago [\#97361](#97361) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problem Saving New Products and/or editing old!](/forum/3-bug-report/79929-problem-saving-new-products-and-or-editing-old#97361 "Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before?")* It means that there was an issue with the update of the database structure and you didn't get the new column "product_canonical" in the product table. Download again HikaShop on our website, install it again and that should force the column to be added to the table and you won't have the error anymore. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTkyOS1wcm9ibGVtLXNhdmluZy1uZXctcHJvZHVjdHMtYW5kLW9yLWVkaXRpbmctb2xkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[fantomet](/forum/user/15984-fantomet "View fantomet's Profile")** - [![fantomet's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15984-fantomet "View fantomet's Profile") Topic Author - [ Offline](/forum/user/15984-fantomet) Less More - Posts: 10 - Thank you received: 0 - - 13 years 6 months ago [\#97444](#97444) by [fantomet](/forum/user/15984-fantomet "View fantomet's Profile") Replied by *[fantomet](/forum/user/15984-fantomet "View fantomet's Profile")* on topic *[Problem Saving New Products and/or editing old!](/forum/3-bug-report/79929-problem-saving-new-products-and-or-editing-old#97444 "Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before?")* It didnt work Im afraid! Do I need to uninstall it completely to make it work? Could it be that its something caused by the CSV-file that was imported? So if I reinstall it and run the CSV-file again i'll get the same problem again!? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTkyOS1wcm9ibGVtLXNhdmluZy1uZXctcHJvZHVjdHMtYW5kLW9yLWVkaXRpbmctb2xkP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 13 years 6 months ago [\#97468](#97468) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problem Saving New Products and/or editing old!](/forum/3-bug-report/79929-problem-saving-new-products-and-or-editing-old#97468 "Hi I can't edit or save new products! It just says: "Error - Save failed" (or in Swedish: "Fel - spara misslyckades") It's a new website and the first products were imported by CSV-file. Have anyone had this problem before?")* It's not a problem with the CSV. If you remove the hikashop tables from the database and install the latest version, you should not get that error. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTkyOS1wcm9ibGVtLXNhdmluZy1uZXctcHJvZHVjdHMtYW5kLW9yLWVkaXRpbmctb2xkP3RtcGw9bWFya2Rvd24=) 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.140 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)