[Skip to main content](#vessel-content) # SQl Error Upgrade to Business ## - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 6 months ago [\#101041](#101041) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") *[SQl Error Upgrade to Business](/forum/3-bug-report/80979-sql-error-upgrade-to-business#101041 "Hi, I have upgrade my release of Hikashop to Business version. I installed the upgrade from Essential to Business but at the end of the installation an error appear: "500 SQL=ALTER TABLE `h7eoh_hikashop_product` ADD `product_alias` VARCHAR( 255 ) NOT NULL DEFAULT '';" and if I try to create a new product this is the error message: "500 SQL=INSERT IGNORE INTO `h7eoh_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`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_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Test Leonard','','','','','','','Test_Leonard','11','0','','25','0','5','','','','','kg','','','m','','1','all','','main','retertert','1366911979','1366911979' )" Can you help me to resolve this problem? Thanks in advance! Guy")* was created by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* Hi, I have upgrade my release of Hikashop to Business version. I installed the upgrade from Essential to Business but at the end of the installation an error appear: "500 SQL=ALTER TABLE `h7eoh_hikashop_product` ADD `product_alias` VARCHAR( 255 ) NOT NULL DEFAULT '';" and if I try to create a new product this is the error message: "500 SQL=INSERT IGNORE INTO `h7eoh_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`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_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Test Leonard','','','','','','','Test_Leonard','11','0','','25','0','5','','','','','kg','','','m','','1','all','','main','retertert','1366911979','1366911979' )" Can you help me to resolve this problem? Thanks in advance! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDk3OS1zcWwtZXJyb3ItdXBncmFkZS10by1idXNpbmVzcz90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 6 months ago [\#101055](#101055) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[SQl Error Upgrade to Business](/forum/3-bug-report/80979-sql-error-upgrade-to-business#101055 "Hi, I have upgrade my release of Hikashop to Business version. I installed the upgrade from Essential to Business but at the end of the installation an error appear: "500 SQL=ALTER TABLE `h7eoh_hikashop_product` ADD `product_alias` VARCHAR( 255 ) NOT NULL DEFAULT '';" and if I try to create a new product this is the error message: "500 SQL=INSERT IGNORE INTO `h7eoh_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`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_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Test Leonard','','','','','','','Test_Leonard','11','0','','25','0','5','','','','','kg','','','m','','1','all','','main','retertert','1366911979','1366911979' )" Can you help me to resolve this problem? Thanks in advance! Guy")* Hi, Your update didn't go to the end because of the first SQL error. Thus, not all the new columns of the product table could be added during the update. You will have to add manually the missing columns in your database. Normally, the debug system tells you which column is missing so you can just add it with a simple query in phpmyadmin in such cases. However, your Joomla 3.x version has a bug which prevents the display of the error messages coming from the database. So you first need to update Joomla to the latest version and try again in order to get the proper error messages in order to know which column is missing and then add it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDk3OS1zcWwtZXJyb3ItdXBncmFkZS10by1idXNpbmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 6 months ago [\#101136](#101136) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[SQl Error Upgrade to Business](/forum/3-bug-report/80979-sql-error-upgrade-to-business#101136 "Hi, I have upgrade my release of Hikashop to Business version. I installed the upgrade from Essential to Business but at the end of the installation an error appear: "500 SQL=ALTER TABLE `h7eoh_hikashop_product` ADD `product_alias` VARCHAR( 255 ) NOT NULL DEFAULT '';" and if I try to create a new product this is the error message: "500 SQL=INSERT IGNORE INTO `h7eoh_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`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_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Test Leonard','','','','','','','Test_Leonard','11','0','','25','0','5','','','','','kg','','','m','','1','all','','main','retertert','1366911979','1366911979' )" Can you help me to resolve this problem? Thanks in advance! Guy")* Hi, Thanks for your reply! Now I'm working on a test site and I update my version of Joomla, then I run again the upgrade of Hikashop and no message error appear......but still does not work and also other article do not appear! Please, before upgrade the site on "production", can you gime me the correct sequence to do correctly? Thanks! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDk3OS1zcWwtZXJyb3ItdXBncmFkZS10by1idXNpbmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")** - [![giuseppe's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15536-giuseppe "View giuseppe's Profile") Topic Author - [ Offline](/forum/user/15536-giuseppe) Less More - Posts: 26 - Thank you received: 0 - - 13 years 6 months ago [\#101239](#101239) by [giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile") Replied by *[giuseppe](/forum/user/15536-giuseppe "View giuseppe's Profile")* on topic *[SQl Error Upgrade to Business](/forum/3-bug-report/80979-sql-error-upgrade-to-business#101239 "Hi, I have upgrade my release of Hikashop to Business version. I installed the upgrade from Essential to Business but at the end of the installation an error appear: "500 SQL=ALTER TABLE `h7eoh_hikashop_product` ADD `product_alias` VARCHAR( 255 ) NOT NULL DEFAULT '';" and if I try to create a new product this is the error message: "500 SQL=INSERT IGNORE INTO `h7eoh_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`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_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Test Leonard','','','','','','','Test_Leonard','11','0','','25','0','5','','','','','kg','','','m','','1','all','','main','retertert','1366911979','1366911979' )" Can you help me to resolve this problem? Thanks in advance! Guy")* Hi, I've probably solved the problem: In test environment I uninstalled every single component and plugin of hikashop(filter Hika) then I dropped manually every tables of Hikashop on DataBase. I have upgrade to latest versione of Joomla (3.1.0) and finally I installed every version of Hikashop (1-Starter,2-Essential and 3-Business) and no error appear and no problem when I try to publish a module/menu or create a new product. For your opinion is correct this way? can I procede also in production environment? Many thanks for your support! Guy Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDk3OS1zcWwtZXJyb3ItdXBncmFkZS10by1idXNpbmVzcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 6 months ago [\#101264](#101264) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[SQl Error Upgrade to Business](/forum/3-bug-report/80979-sql-error-upgrade-to-business#101264 "Hi, I have upgrade my release of Hikashop to Business version. I installed the upgrade from Essential to Business but at the end of the installation an error appear: "500 SQL=ALTER TABLE `h7eoh_hikashop_product` ADD `product_alias` VARCHAR( 255 ) NOT NULL DEFAULT '';" and if I try to create a new product this is the error message: "500 SQL=INSERT IGNORE INTO `h7eoh_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`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_msrp`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'Test Leonard','','','','','','','Test_Leonard','11','0','','25','0','5','','','','','kg','','','m','','1','all','','main','retertert','1366911979','1366911979' )" Can you help me to resolve this problem? Thanks in advance! Guy")* Hi, I want to say that it is logical that no error appear. The different editions does not update the SQL. You don't need to install HikaShop starter to install HikaShop essential, etc. The SQL is updated when you change the HikaShop version. Going from HikaShop 2.1.0 to HikaShop 2.1.1 The Database structure is the same between the different HikaShop editions. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MDk3OS1zcWwtZXJyb3ItdXBncmFkZS10by1idXNpbmVzcz90bXBsPW1hcmtkb3du) 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.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)