[Skip to main content](#vessel-content) # Importing HikaShop table thru PHP question ## - **[ISORIS](/forum/user/29705-isoris "View ISORIS's Profile")** - [![ISORIS's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29705-isoris "View ISORIS's Profile") Topic Author - [ Offline](/forum/user/29705-isoris) Less More - Posts: 4 - Thank you received: 0 - - 10 years 8 months ago - 10 years 8 months ago [\#229321](#229321) by [ISORIS](/forum/user/29705-isoris "View ISORIS's Profile") *[Importing HikaShop table thru PHP question](/forum/37-import-export-csv-xls/882185-importing-hikashop-table-thru-php-question#229321 "-- 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 and here 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")* was created by *[ISORIS](/forum/user/29705-isoris "View ISORIS's Profile")* -- 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 [ ](http://www.hikashop.com/forum/import-export-csv-xls/879163-exporting-items-and-charactieristics-to-newer-vers.html)[ www.hikashop.com/forum/import-export-csv...s-to-newer-vers.html](http://www.hikashop.com/forum/import-export-csv-xls/879163-exporting-items-and-charactieristics-to-newer-vers.html) and here [ ](http://www.hikashop.com/forum/import-export-csv-xls/879574-i-need-backup.html)[ www.hikashop.com/forum/import-export-csv...4-i-need-backup.html](http://www.hikashop.com/forum/import-export-csv-xls/879574-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 8 months ago by [ISORIS](/forum/user/29705-isoris "View ISORIS's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIxODUtaW1wb3J0aW5nLWhpa2FzaG9wLXRhYmxlLXRocnUtcGhwLXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ISORIS](/forum/user/29705-isoris "View ISORIS's Profile")** - [![ISORIS's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29705-isoris "View ISORIS's Profile") Topic Author - [ Offline](/forum/user/29705-isoris) Less More - Posts: 4 - Thank you received: 0 - - 10 years 8 months ago - 10 years 8 months ago [\#229325](#229325) by [ISORIS](/forum/user/29705-isoris "View ISORIS's Profile") Replied by *[ISORIS](/forum/user/29705-isoris "View ISORIS's Profile")* on topic *[Importing HikaShop table thru PHP question](/forum/37-import-export-csv-xls/882185-importing-hikashop-table-thru-php-question#229325 "-- 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 and here 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")* 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 : 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 8 months ago by [ISORIS](/forum/user/29705-isoris "View ISORIS's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIxODUtaW1wb3J0aW5nLWhpa2FzaG9wLXRhYmxlLXRocnUtcGhwLXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 10 years 8 months ago [\#229355](#229355) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing HikaShop table thru PHP question](/forum/37-import-export-csv-xls/882185-importing-hikashop-table-thru-php-question#229355 "-- 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 and here 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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODIxODUtaW1wb3J0aW5nLWhpa2FzaG9wLXRhYmxlLXRocnUtcGhwLXF1ZXN0aW9uP3RtcGw9bWFya2Rvd24=) 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.103 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)