[Skip to main content](#vessel-content)

#   Error Saving on products

##

- **[fiuker23](/forum/user/14802-fiuker23 "View fiuker23's Profile")**
- [![fiuker23's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14802-fiuker23 "View fiuker23's Profile") Topic Author
- [ Offline](/forum/user/14802-fiuker23)

Less More

- Posts: 4
- Thank you received: 0
-
-

13 years 7 months ago -  13 years 7 months ago [\#94766](#94766) by [fiuker23](/forum/user/14802-fiuker23 "View fiuker23's Profile")  *[Error Saving on products](/forum/3-bug-report/79340-error-saving-on-products#94766 "I looked around at similar posts and tried the solutions provided with no success. This is a fresh install of HikaShop 2.1.1 on 2.5.8 Joomla. I receive an error when trying to create a new product:  500 - An error has occurred. JDatabaseMySQLi::query: 1054 - Unknown column 'product&#95;canonical' in 'field list' SQL=INSERT IGNORE INTO &#96;djh8r&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'test','','','','','','C01','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','  o  ','1363378181','1363378181' ) Return to Control Panel  Call stack # Function Location 1 JAdministrator-&gt;dispatch() /home/realscho/public&#95;html/final/administrator/index.php:46 2 JComponentHelper::renderComponent() /home/realscho/public&#95;html/final/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:351 4 require&#95;once() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:383 5 hikashopController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/hikashop.php:54 6 JController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1217 7 hikashopController-&gt;apply() /home/realscho/public&#95;html/final/libraries/joomla/application/component/controller.php:761 8 hikashopController-&gt;store() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1003 9 hikashopProductClass-&gt;saveForm() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1067 10 hikashopProductClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:204 11 hikashopClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:463 12 JDatabase-&gt;query() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1268 13 JDatabaseMySQLi-&gt;execute() /home/realscho/public&#95;html/final/libraries/joomla/database/database.php:1253 14 JError::raiseError() /home/realscho/public&#95;html/final/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() /home/realscho/public&#95;html/final/libraries/joomla/error/error.php:251  The last suggested fix I was able to find was to download the newest install from the site and upload it over the existing installation. Tried that with no success. I think this could be a very useful tool for my customers since I am burnt out on VirtueMart and other e-commerce setups. This seems easy to train people on - but I need the free version to work correctly before I will even think about purchasing the full version. Any help would be appreciated.  -Trent")* was created by *[fiuker23](/forum/user/14802-fiuker23 "View fiuker23's Profile")*

I looked around at similar posts and tried the solutions provided with no success. This is a fresh install of HikaShop 2.1.1 on 2.5.8 Joomla. I receive an error when trying to create a new product:

500 - An error has occurred.
JDatabaseMySQLi::query: 1054 - Unknown column 'product_canonical' in 'field list' SQL=INSERT IGNORE INTO &#96;djh8r_hikashop_product&#96; ( &#96;product_name&#96;,&#96;product_url&#96;,&#96;product_meta_description&#96;,&#96;product_keywords&#96;,&#96;product_page_title&#96;,&#96;product_alias&#96;,&#96;product_code&#96;,&#96;product_tax_id&#96;,&#96;product_manufacturer_id&#96;,&#96;product_layout&#96;,&#96;product_quantity&#96;,&#96;product_min_per_order&#96;,&#96;product_max_per_order&#96;,&#96;product_sale_start&#96;,&#96;product_sale_end&#96;,&#96;product_canonical&#96;,&#96;product_msrp&#96;,&#96;product_weight&#96;,&#96;product_weight_unit&#96;,&#96;product_length&#96;,&#96;product_width&#96;,&#96;product_dimension_unit&#96;,&#96;product_height&#96;,&#96;product_published&#96;,&#96;product_type&#96;,&#96;product_description&#96;,&#96;product_modified&#96;,&#96;product_created&#96; ) VALUES ( 'test','','','','','','C01','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','

o

','1363378181','1363378181' )
Return to Control Panel

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

The last suggested fix I was able to find was to download the newest install from the site and upload it over the existing installation. Tried that with no success. I think this could be a very useful tool for my customers since I am burnt out on VirtueMart and other e-commerce setups. This seems easy to train people on - but I need the free version to work correctly before I will even think about purchasing the full version. Any help would be appreciated.

-Trent

Last edit: 13 years 7 months ago by [fiuker23](/forum/user/14802-fiuker23 "View fiuker23's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTM0MC1lcnJvci1zYXZpbmctb24tcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

13 years 7 months ago [\#94795](#94795) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error Saving on products](/forum/3-bug-report/79340-error-saving-on-products#94795 "I looked around at similar posts and tried the solutions provided with no success. This is a fresh install of HikaShop 2.1.1 on 2.5.8 Joomla. I receive an error when trying to create a new product:  500 - An error has occurred. JDatabaseMySQLi::query: 1054 - Unknown column 'product&#95;canonical' in 'field list' SQL=INSERT IGNORE INTO &#96;djh8r&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'test','','','','','','C01','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','  o  ','1363378181','1363378181' ) Return to Control Panel  Call stack # Function Location 1 JAdministrator-&gt;dispatch() /home/realscho/public&#95;html/final/administrator/index.php:46 2 JComponentHelper::renderComponent() /home/realscho/public&#95;html/final/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:351 4 require&#95;once() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:383 5 hikashopController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/hikashop.php:54 6 JController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1217 7 hikashopController-&gt;apply() /home/realscho/public&#95;html/final/libraries/joomla/application/component/controller.php:761 8 hikashopController-&gt;store() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1003 9 hikashopProductClass-&gt;saveForm() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1067 10 hikashopProductClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:204 11 hikashopClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:463 12 JDatabase-&gt;query() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1268 13 JDatabaseMySQLi-&gt;execute() /home/realscho/public&#95;html/final/libraries/joomla/database/database.php:1253 14 JError::raiseError() /home/realscho/public&#95;html/final/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() /home/realscho/public&#95;html/final/libraries/joomla/error/error.php:251  The last suggested fix I was able to find was to download the newest install from the site and upload it over the existing installation. Tried that with no success. I think this could be a very useful tool for my customers since I am burnt out on VirtueMart and other e-commerce setups. This seems easy to train people on - but I need the free version to work correctly before I will even think about purchasing the full version. Any help would be appreciated.  -Trent")*

Hi,

Please delete all the hikashop tables in your database via phpmyadmin, download the latest 2.1.1 package on our website and install id and you won't have that error.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTM0MC1lcnJvci1zYXZpbmctb24tcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[djundi](/forum/user/7718-djundi "View djundi's Profile")**
- [![djundi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7718-djundi "View djundi's Profile")
- [ Offline](/forum/user/7718-djundi)

Less More

- Posts: 45
- Thank you received: 1
-
-
-
-

13 years 7 months ago -  13 years 7 months ago [\#95446](#95446) by [djundi](/forum/user/7718-djundi "View djundi's Profile")  Replied by *[djundi](/forum/user/7718-djundi "View djundi's Profile")* on topic *[Error Saving on products](/forum/3-bug-report/79340-error-saving-on-products#95446 "I looked around at similar posts and tried the solutions provided with no success. This is a fresh install of HikaShop 2.1.1 on 2.5.8 Joomla. I receive an error when trying to create a new product:  500 - An error has occurred. JDatabaseMySQLi::query: 1054 - Unknown column 'product&#95;canonical' in 'field list' SQL=INSERT IGNORE INTO &#96;djh8r&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'test','','','','','','C01','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','  o  ','1363378181','1363378181' ) Return to Control Panel  Call stack # Function Location 1 JAdministrator-&gt;dispatch() /home/realscho/public&#95;html/final/administrator/index.php:46 2 JComponentHelper::renderComponent() /home/realscho/public&#95;html/final/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:351 4 require&#95;once() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:383 5 hikashopController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/hikashop.php:54 6 JController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1217 7 hikashopController-&gt;apply() /home/realscho/public&#95;html/final/libraries/joomla/application/component/controller.php:761 8 hikashopController-&gt;store() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1003 9 hikashopProductClass-&gt;saveForm() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1067 10 hikashopProductClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:204 11 hikashopClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:463 12 JDatabase-&gt;query() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1268 13 JDatabaseMySQLi-&gt;execute() /home/realscho/public&#95;html/final/libraries/joomla/database/database.php:1253 14 JError::raiseError() /home/realscho/public&#95;html/final/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() /home/realscho/public&#95;html/final/libraries/joomla/error/error.php:251  The last suggested fix I was able to find was to download the newest install from the site and upload it over the existing installation. Tried that with no success. I think this could be a very useful tool for my customers since I am burnt out on VirtueMart and other e-commerce setups. This seems easy to train people on - but I need the free version to work correctly before I will even think about purchasing the full version. Any help would be appreciated.  -Trent")*

Hi Nicolas ![:)](/media/kunena/emoticons/3.png ":)")
I have the same problem, after upgrade everyting is ok, new product save seamlessly. But when i export sql from anоther site, with version is 2.1.0 an error occurs. I re-instal upgrade twice but no change...

JDatabaseMySQLi::query: 1054 - Unknown column 'product_canonical' in 'field list' SQL=UPDATE &#96;b15ic_hikashop_product&#96; SET &#96;product_name&#96;='Лаптоп ACER AO725-C7Ckk',&#96;product_url&#96;='',&#96;product_meta_description&#96;='Лаптоп ACER AO725-C7Ckk Black',&#96;product_keywords&#96;='Лаптоп,ACER,AO725-C7Ckk,Black,AMD,Dual-core, C70,4GB/DDR3',&#96;product_page_title&#96;='Лаптоп ACER AO725-C7Ckk',&#96;product_alias&#96;='Лаптоп ACER AO725-C7Ckk',&#96;product_code&#96;='NU.SGPEX.030.m',&#96;product_tax_id&#96;='11',&#96;product_manufacturer_id&#96;='109',&#96;product_layout&#96;='',&#96;product_quantity&#96;='-1',&#96;product_min_per_order&#96;='0',&#96;product_max_per_order&#96;='0',&#96;product_sale_start&#96;='',&#96;product_sale_end&#96;='',&#96;product_canonical&#96;='',&#96;product_msrp&#96;='',&#96;product_weight&#96;='2.500',&#96;product_weight_unit&#96;='kg',&#96;product_length&#96;='0.000',&#96;product_width&#96;='0.000',&#96;product_dimension_unit&#96;='m',&#96;product_height&#96;='0.000',&#96;product_published&#96;='1',&#96;product_access&#96;='all',&#96;product_group_after_purchase&#96;='',&#96;cpu_main&#96;='Intel® Celeron®',&#96;cpu_characteristics&#96;='Intel® Celeron®Processor B800 1.50 GHz, 2MB L3 cache Sandy Bridge',&#96;ram_main&#96;='2GB DDR3 1066MHz',&#96;hdd_characteristics&#96;='320GB SATA, 5400 об./мин.',&#96;ssd_main&#96;='0',&#96;hdd_type&#96;='SATA',&#96;gpu_main&#96;='Споделено видео',&#96;gpu_characteristics&#96;='Intel GMA 3600, споделена от оперативната памет',&#96;display_main&#96;='7 инча',&#96;display_characteristics&#96;='7” (1024x600)(тъчскрийн)',&#96;dvd_main&#96;='DVD/CD четящо/записващо устройство',&#96;lan_main&#96;='10/100 Mbit ',&#96;wifi_main&#96;='Wi-Fi 802.11 b/g/n',&#96;usb2_main&#96;='1',&#96;usb3_main&#96;='1',&#96;hdmi_main&#96;='да',&#96;bluetooth_main&#96;='да',&#96;cartreader_main&#96;='да',&#96;esata_port&#96;='да',&#96;serialport_main&#96;='да',&#96;firewire_main&#96;='да',&#96;vga_port&#96;='да',&#96;finger_main&#96;='да',&#96;cartslot_main&#96;='да',&#96;3g_main&#96;='да',&#96;tv_main&#96;='да',&#96;cam_main&#96;='не',&#96;battery_main&#96;='4 клетъчна',&#96;battlife_main&#96;='до 2 часа',&#96;teglo_main&#96;='2.500',&#96;os_mine&#96;='Free DOS',&#96;warranty_main&#96;='12 месеца',&#96;product_type&#96;='main',&#96;product_description&#96;='

Last edit: 13 years 7 months ago by [djundi](/forum/user/7718-djundi "View djundi's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTM0MC1lcnJvci1zYXZpbmctb24tcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

13 years 7 months ago [\#95461](#95461) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error Saving on products](/forum/3-bug-report/79340-error-saving-on-products#95461 "I looked around at similar posts and tried the solutions provided with no success. This is a fresh install of HikaShop 2.1.1 on 2.5.8 Joomla. I receive an error when trying to create a new product:  500 - An error has occurred. JDatabaseMySQLi::query: 1054 - Unknown column 'product&#95;canonical' in 'field list' SQL=INSERT IGNORE INTO &#96;djh8r&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'test','','','','','','C01','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','  o  ','1363378181','1363378181' ) Return to Control Panel  Call stack # Function Location 1 JAdministrator-&gt;dispatch() /home/realscho/public&#95;html/final/administrator/index.php:46 2 JComponentHelper::renderComponent() /home/realscho/public&#95;html/final/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:351 4 require&#95;once() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:383 5 hikashopController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/hikashop.php:54 6 JController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1217 7 hikashopController-&gt;apply() /home/realscho/public&#95;html/final/libraries/joomla/application/component/controller.php:761 8 hikashopController-&gt;store() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1003 9 hikashopProductClass-&gt;saveForm() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1067 10 hikashopProductClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:204 11 hikashopClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:463 12 JDatabase-&gt;query() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1268 13 JDatabaseMySQLi-&gt;execute() /home/realscho/public&#95;html/final/libraries/joomla/database/database.php:1253 14 JError::raiseError() /home/realscho/public&#95;html/final/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() /home/realscho/public&#95;html/final/libraries/joomla/error/error.php:251  The last suggested fix I was able to find was to download the newest install from the site and upload it over the existing installation. Tried that with no success. I think this could be a very useful tool for my customers since I am burnt out on VirtueMart and other e-commerce setups. This seems easy to train people on - but I need the free version to work correctly before I will even think about purchasing the full version. Any help would be appreciated.  -Trent")*

Hi,

You can't export the SQL of a website with one version of HikaShop and import it to another one. Otherwise, you're missing the columns that are added between each version during the update process.

You can always add manually the missing column via phpmyadmin if you want.

The following user(s) said Thank You: [djundi](/forum/user/7718-djundi "View djundi's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTM0MC1lcnJvci1zYXZpbmctb24tcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[djundi](/forum/user/7718-djundi "View djundi's Profile")**
- [![djundi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7718-djundi "View djundi's Profile")
- [ Offline](/forum/user/7718-djundi)

Less More

- Posts: 45
- Thank you received: 1
-
-
-
-

13 years 7 months ago [\#95490](#95490) by [djundi](/forum/user/7718-djundi "View djundi's Profile")  Replied by *[djundi](/forum/user/7718-djundi "View djundi's Profile")* on topic *[Error Saving on products](/forum/3-bug-report/79340-error-saving-on-products#95490 "I looked around at similar posts and tried the solutions provided with no success. This is a fresh install of HikaShop 2.1.1 on 2.5.8 Joomla. I receive an error when trying to create a new product:  500 - An error has occurred. JDatabaseMySQLi::query: 1054 - Unknown column 'product&#95;canonical' in 'field list' SQL=INSERT IGNORE INTO &#96;djh8r&#95;hikashop&#95;product&#96; ( &#96;product&#95;name&#96;,&#96;product&#95;url&#96;,&#96;product&#95;meta&#95;description&#96;,&#96;product&#95;keywords&#96;,&#96;product&#95;page&#95;title&#96;,&#96;product&#95;alias&#96;,&#96;product&#95;code&#96;,&#96;product&#95;tax&#95;id&#96;,&#96;product&#95;manufacturer&#95;id&#96;,&#96;product&#95;layout&#96;,&#96;product&#95;quantity&#96;,&#96;product&#95;min&#95;per&#95;order&#96;,&#96;product&#95;max&#95;per&#95;order&#96;,&#96;product&#95;sale&#95;start&#96;,&#96;product&#95;sale&#95;end&#96;,&#96;product&#95;canonical&#96;,&#96;product&#95;msrp&#96;,&#96;product&#95;weight&#96;,&#96;product&#95;weight&#95;unit&#96;,&#96;product&#95;length&#96;,&#96;product&#95;width&#96;,&#96;product&#95;dimension&#95;unit&#96;,&#96;product&#95;height&#96;,&#96;product&#95;published&#96;,&#96;product&#95;type&#96;,&#96;product&#95;description&#96;,&#96;product&#95;modified&#96;,&#96;product&#95;created&#96; ) VALUES ( 'test','','','','','','C01','11','0','','-1','0','0','','','','','','kg','','','m','','1','main','  o  ','1363378181','1363378181' ) Return to Control Panel  Call stack # Function Location 1 JAdministrator-&gt;dispatch() /home/realscho/public&#95;html/final/administrator/index.php:46 2 JComponentHelper::renderComponent() /home/realscho/public&#95;html/final/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:351 4 require&#95;once() /home/realscho/public&#95;html/final/libraries/joomla/application/component/helper.php:383 5 hikashopController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/hikashop.php:54 6 JController-&gt;execute() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1217 7 hikashopController-&gt;apply() /home/realscho/public&#95;html/final/libraries/joomla/application/component/controller.php:761 8 hikashopController-&gt;store() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1003 9 hikashopProductClass-&gt;saveForm() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1067 10 hikashopProductClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:204 11 hikashopClass-&gt;save() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/classes/product.php:463 12 JDatabase-&gt;query() /home/realscho/public&#95;html/final/administrator/components/com&#95;hikashop/helpers/helper.php:1268 13 JDatabaseMySQLi-&gt;execute() /home/realscho/public&#95;html/final/libraries/joomla/database/database.php:1253 14 JError::raiseError() /home/realscho/public&#95;html/final/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() /home/realscho/public&#95;html/final/libraries/joomla/error/error.php:251  The last suggested fix I was able to find was to download the newest install from the site and upload it over the existing installation. Tried that with no success. I think this could be a very useful tool for my customers since I am burnt out on VirtueMart and other e-commerce setups. This seems easy to train people on - but I need the free version to work correctly before I will even think about purchasing the full version. Any help would be appreciated.  -Trent")*

Thanks, Nicolas ![:)](/media/kunena/emoticons/3.png ":)")
I create two new columns and now everything is ok ![:)](/media/kunena/emoticons/3.png ":)") Thanks again for best an quick support ![:)](/media/kunena/emoticons/3.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83OTM0MC1lcnJvci1zYXZpbmctb24tcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.050 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
