[Skip to main content](#vessel-content) # Problems saving new products ## - **[Arkel](/forum/user/14773-arkel "View Arkel's Profile")** - [![Arkel's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14773-arkel "View Arkel's Profile") Topic Author - [ Offline](/forum/user/14773-arkel) Less More - Posts: 2 - Thank you received: 0 - - 13 years 7 months ago - 13 years 7 months ago [\#94654](#94654) by [Arkel](/forum/user/14773-arkel "View Arkel's Profile") *[Problems saving new products](/forum/3-bug-report/79319-problems-saving-new-products#94654 "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")* was created by *[Arkel](/forum/user/14773-arkel "View Arkel's Profile")* 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 Last edit: 13 years 7 months ago by [Arkel](/forum/user/14773-arkel "View Arkel's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTMxOS1wcm9ibGVtcy1zYXZpbmctbmV3LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 7 months ago [\#94677](#94677) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Problems saving new products](/forum/3-bug-report/79319-problems-saving-new-products#94677 "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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTMxOS1wcm9ibGVtcy1zYXZpbmctbmV3LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Arkel](/forum/user/14773-arkel "View Arkel's Profile")** - [![Arkel's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14773-arkel "View Arkel's Profile") Topic Author - [ Offline](/forum/user/14773-arkel) Less More - Posts: 2 - Thank you received: 0 - - 13 years 7 months ago [\#94773](#94773) by [Arkel](/forum/user/14773-arkel "View Arkel's Profile") Replied by *[Arkel](/forum/user/14773-arkel "View Arkel's Profile")* on topic *[Problems saving new products](/forum/3-bug-report/79319-problems-saving-new-products#94773 "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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTMxOS1wcm9ibGVtcy1zYXZpbmctbmV3LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#94800](#94800) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problems saving new products](/forum/3-bug-report/79319-problems-saving-new-products#94800 "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, Make sure that you delete all the hikashop tables from the database via phpmyadmin before installing again and that won't produce that error. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTMxOS1wcm9ibGVtcy1zYXZpbmctbmV3LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[curtisbollington](/forum/user/7813-curtisbollington "View curtisbollington's Profile")** - [![curtisbollington's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7813-curtisbollington "View curtisbollington's Profile") - [ Offline](/forum/user/7813-curtisbollington) Less More - Posts: 35 - Thank you received: 1 - - 13 years 7 months ago [\#95057](#95057) by [curtisbollington](/forum/user/7813-curtisbollington "View curtisbollington's Profile") Replied by *[curtisbollington](/forum/user/7813-curtisbollington "View curtisbollington's Profile")* on topic *[Problems saving new products](/forum/3-bug-report/79319-problems-saving-new-products#95057 "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")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTMxOS1wcm9ibGVtcy1zYXZpbmctbmV3LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#95059](#95059) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problems saving new products](/forum/3-bug-report/79319-problems-saving-new-products#95059 "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")* Before installing again HikaShop, make sure that HikaShop is uninstalled in the Joomla extension manager or it won't run the SQL file which creates all the tables in the database (which is why you have that error). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTMxOS1wcm9ibGVtcy1zYXZpbmctbmV3LXByb2R1Y3RzP3RtcGw9bWFya2Rvd24=) 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.112 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)