Problem Saving New Products and/or editing old!

  • Posts: 10
  • Thank you received: 0
11 years 1 month ago #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?

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

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
11 years 1 month ago #97313

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 or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
11 years 1 month ago #97325

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 or Create an account to join the conversation.

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
11 years 1 month ago #97361

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 or Create an account to join the conversation.

  • Posts: 10
  • Thank you received: 0
11 years 1 month ago #97444

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 or Create an account to join the conversation.

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
11 years 1 month ago #97468

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 or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum