- Posts: 4
- Thank you received: 0
Importing HikaShop table thru PHP question
10 years 7 months ago - 10 years 7 months ago #229321
by ISORIS
Importing HikaShop table thru PHP question was created by ISORIS
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.6.15
-- Browser(s) name and version -- : Firefox 44
Hello,
I'm trying to copy the Hikashop tables from a site to another as mentionned here
www.hikashop.com/forum/import-export-csv...s-to-newer-vers.html
and here
www.hikashop.com/forum/import-export-csv...4-i-need-backup.html
I exported the hikashop tables in SQL format from the source site, then I deleted all the hikashop tables in the target base and imported the pervious export.
I have also copied the "\media\com_hikashop\upload" folder to the new site.
The table prefix are correct and... nothing append.
Althought all thedata are in the tables, nothing is displayed in the Hikashop backend, nor the category tree or products.
What i've missed ?
Thank You
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.6.15
-- Browser(s) name and version -- : Firefox 44
Hello,
I'm trying to copy the Hikashop tables from a site to another as mentionned here
www.hikashop.com/forum/import-export-csv...s-to-newer-vers.html
and here
www.hikashop.com/forum/import-export-csv...4-i-need-backup.html
I exported the hikashop tables in SQL format from the source site, then I deleted all the hikashop tables in the target base and imported the pervious export.
I have also copied the "\media\com_hikashop\upload" folder to the new site.
The table prefix are correct and... nothing append.
Althought all thedata are in the tables, nothing is displayed in the Hikashop backend, nor the category tree or products.
What i've missed ?
Thank You
Last edit: 10 years 7 months ago by ISORIS.
Please Log in or Create an account to join the conversation.
10 years 7 months ago - 10 years 7 months ago #229325
by ISORIS
Replied by ISORIS on topic Importing HikaShop table thru PHP question
Ok i partialy fixed the import by resetting the target base to its default state and reimporting the file.
The import worked, (don't kwow why) but :
1. all the product are in the root directory while the produc tree is here.
2. i get this error message (1054) when cliking on a product to edit it :
Thank you for advice
The import worked, (don't kwow why) but :
1. all the product are in the root directory while the produc tree is here.
2. i get this error message (1054) when cliking on a product to edit it :
Code:
Unknown column 'field_products' in 'where clause' SQL=SELECT * FROM iso2016_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_backend` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,19,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%' OR field_categories LIKE '%,16,%' OR field_categories LIKE '%,19,%'))) AND field_products="") OR (field_products LIKE '%,4,%')) ORDER BY a.`field_ordering` ASC
Thank you for advice
Last edit: 10 years 7 months ago by ISORIS.
Please Log in or Create an account to join the conversation.
10 years 7 months ago #229355
by nicolas
Replied by nicolas on topic Importing HikaShop table thru PHP question
Hi,
field_products is a normal column of the hikashop_field table. So it means that you got that table from an old version of HikaShop where that column didn't exist.
Click on the "check database" button of the HikaShop configuration and it will fix all the missing columns in your HikaShop tables.
field_products is a normal column of the hikashop_field table. So it means that you got that table from an old version of HikaShop where that column didn't exist.
Click on the "check database" button of the HikaShop configuration and it will fix all the missing columns in your HikaShop tables.
Please Log in or Create an account to join the conversation.
Time to create page: 0.142 seconds