Problems saving new products

I'm getting this error whenever i try to save a new product in my website:


500 - Se ha producido un error.
JDatabaseMySQLi::query: 1054 - Unknown column 'product_canonical' in 'field list' SQL=INSERT IGNORE INTO `cehl5_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 ( 'Cuaderno','','','','','','Cuaderno','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','

Cuaderno para escribir

','1363318301','1363318301' )
Volver al panel de control

Call stack
# Function Location
1 JAdministrator->dispatch() /home/rirume/public_html/tienda/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/rirume/public_html/tienda/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/rirume/public_html/tienda/libraries/joomla/application/component/helper.php:351
4 require_once() /home/rirume/public_html/tienda/libraries/joomla/application/component/helper.php:383
5 hikashopController->execute() /home/rirume/public_html/tienda/administrator/components/com_hikashop/hikashop.php:54
6 JController->execute() /home/rirume/public_html/tienda/administrator/components/com_hikashop/helpers/helper.php:1217
7 ProductController->save() /home/rirume/public_html/tienda/libraries/joomla/application/component/controller.php:761
8 hikashopController->store() /home/rirume/public_html/tienda/administrator/components/com_hikashop/controllers/product.php:81
9 hikashopProductClass->saveForm() /home/rirume/public_html/tienda/administrator/components/com_hikashop/helpers/helper.php:1067
10 hikashopProductClass->save() /home/rirume/public_html/tienda/administrator/components/com_hikashop/classes/product.php:204
11 hikashopClass->save() /home/rirume/public_html/tienda/administrator/components/com_hikashop/classes/product.php:463
12 JDatabase->query() /home/rirume/public_html/tienda/administrator/components/com_hikashop/helpers/helper.php:1268
13 JDatabaseMySQLi->execute() /home/rirume/public_html/tienda/libraries/joomla/database/database.php:1253
14 JError::raiseError() /home/rirume/public_html/tienda/libraries/joomla/database/database/mysqli.php:396
15 JError::raise() /home/rirume/public_html/tienda/libraries/joomla/error/error.php:251




I have Joomla 2.5.8 and Hikashop starter 2.1.1. This is a new installation of HikaShop not an update of an older version, I tried to follow the steps in "problems after updating Hikashop" but in the part of "run the query which is in the double quotes in your database" i could not understand what to do (i was in my phpmyadmin in the query section hikashop_product, in the instruction says that i have to delete "custom field" but i dont't have any part with that name...)

I really like the structure of Hikashop, and i will really apreciate a little help in this matter.

Regards

Hi,

This has been corrected, thanks to download again the package from our website and install it over the other hikashop installation.

I have the same problem with the new installer. (com_hikashop_starter_2.1.1_2013-03-16).. here is the error report:

500 - Se ha producido un error.
JDatabaseMySQLi::query: 1054 - Unknown column 'product_canonical' in 'field list' SQL=INSERT IGNORE INTO `cehl5_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 ( 'Cuaderno','','','','','','Cuaderno','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','

Cuaderno ejemplo

','1363400858','1363400858' )
Volver al panel de control

Call stack
# Function Location
1 JAdministrator->dispatch() /home/rirume/public_html/tienda/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/rirume/public_html/tienda/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/rirume/public_html/tienda/libraries/joomla/application/component/helper.php:351
4 require_once() /home/rirume/public_html/tienda/libraries/joomla/application/component/helper.php:383
5 hikashopController->execute() /home/rirume/public_html/tienda/administrator/components/com_hikashop/hikashop.php:54
6 JController->execute() /home/rirume/public_html/tienda/administrator/components/com_hikashop/helpers/helper.php:1217
7 ProductController->save() /home/rirume/public_html/tienda/libraries/joomla/application/component/controller.php:761
8 hikashopController->store() /home/rirume/public_html/tienda/administrator/components/com_hikashop/controllers/product.php:81
9 hikashopProductClass->saveForm() /home/rirume/public_html/tienda/administrator/components/com_hikashop/helpers/helper.php:1067
10 hikashopProductClass->save() /home/rirume/public_html/tienda/administrator/components/com_hikashop/classes/product.php:204
11 hikashopClass->save() /home/rirume/public_html/tienda/administrator/components/com_hikashop/classes/product.php:463
12 JDatabase->query() /home/rirume/public_html/tienda/administrator/components/com_hikashop/helpers/helper.php:1268
13 JDatabaseMySQLi->execute() /home/rirume/public_html/tienda/libraries/joomla/database/database.php:1253
14 JError::raiseError() /home/rirume/public_html/tienda/libraries/joomla/database/database/mysqli.php:396
15 JError::raise() /home/rirume/public_html/tienda/libraries/joomla/error/error.php:251

I experienced the same 'canonical' error when trying to add products. I've deleted all the HikaShop tables as you suggest, but when I try and reinstall the new version of Hikashop I get the following error:

1146 Table 'dogpooop_jmln1.joom_hikashop_config' doesn't exist SQL=SELECT * FROM joom_hikashop_config

This is a prospective site for a client, so I'm keen to get this demo of the site working as soon as possible.

The site is set up on Joomla 3.0.3, and I'm trying to load com_hikashop_business_2.1.1_2013-03-15

Thanks

Curtis