Can not import sql db to hikashop

  • Posts: 31
  • Thank you received: 1
7 years 2 months ago #263360

-- HikaShop version -- : HikaShop Business 3.0.0 [1702040056]
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6.25
-- Browser(s) name and version -- : 56.0.2924.87 (64-bit) google chrome
-- Error-message(debug-mod must be tuned on) -- : Грешка

Колоната 'truncate table `oc_product`' не е в списъка с възможни колони: product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_display_quantity_field | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | product_warehouse_id | product_quantity_layout | product_sort_price | parameters | parameter | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | files_name | files_description | files_limit | files_ordering | files_free_download | images | images_name | images_description | images_limit | images_ordering | images_free_download | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. Данните от колоната са игнорирани
Колоната '' не е в списъка с възможни колони: product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_display_quantity_field | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | product_warehouse_id | product_quantity_layout | product_sort_price | parameters | parameter | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | files_name | files_description | files_limit | files_ordering | files_free_download | images | images_name | images_description | images_limit | images_ordering | images_free_download | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. Данните от колоната са игнорирани
Въведете 2 аргумента на ред

Hello, please tell me how to import different from csv database?
I`ll try to import as text via hikashop option but sql database which I try to import show me a message:
Грешка

Колоната 'truncate table `oc_product`' не е в списъка с възможни колони: product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_display_quantity_field | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | product_warehouse_id | product_quantity_layout | product_sort_price | parameters | parameter | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | files_name | files_description | files_limit | files_ordering | files_free_download | images | images_name | images_description | images_limit | images_ordering | images_free_download | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. Данните от колоната са игнорирани
Колоната '' не е в списъка с възможни колони: product_parent_id | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_display_quantity_field | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | product_warehouse_id | product_quantity_layout | product_sort_price | parameters | parameter | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | files_name | files_description | files_limit | files_ordering | files_free_download | images | images_name | images_description | images_limit | images_ordering | images_free_download | parent_category | categories_namekey | categories_image | categories_ordering | categories | related | options. Данните от колоната са игнорирани
Въведете 2 аргумента на ред


p.s. My site is still closed for users, so if you need to open it just tell me.

Attachments:
Last edit: 7 years 1 month ago by marto42.

Please Log in or Create an account to join the conversation.

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
7 years 2 months ago #263364

Hi,

This is a MySQL export file of OSCommerce database.
You can only import it in the PHPMyAdmin of an OSCommerce database.
The import system of HikaShop only supports the import of CSV files with the column names of HikaShop.
So that means that since your files is not even a CSV it's not possible to import it in the CSV import system of HikaShop.
I would recommend to use a tool to export your products as a CSV (for example with this: addons.oscommerce.com/info/5479 ).
Then, edit the CSV in Excel in order to use the column names of HikaShop as explained in the error message of your message.
And then you'll be able to import it in HikaShop.

The following user(s) said Thank You: marto42

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum