Clean installation | Joomla 3.4.1 - Virtuemart - 3.0.9 - CSVI Pro 5.21.2 - PHP 5.6.3 - MySQL 5.6.21
Hi,
When i load template an import / export (category for VM), appearing error \ Administrator \ components \ com_csvi \ helpers \ com_virtuemart_config.php on line 104
I received the patch (in attached) as instructed by the and helped (error messages have disappeared) - http://www.csvimproved.com/en/forum?view=topic&catid=24&id=32129&start=12#42958
I wanted to export and then import the VM categories.
When importing there was a problem (in the annex).
Accepted Answer
Pending Moderation
Thank you for posting your solution.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
I found the solution - http://www.csvimproved.com/en/?option=com_content&view=article&id=720:the-use-and-non-use-of-id-fields&catid=17:site-info
Enough to remove when importing:
Enough to remove when importing:
- virtuemart_category_id
- category_name
Accepted Answer
Pending Moderation
Hi,
in the Annex is still a zipped file with php, there are information about the error.
As a precaution add to post information:
11 Incorrect Failure Category name does not match category path. Make sure that the category_name field matches the last category in category_path field.
in the Annex is still a zipped file with php, there are information about the error.
As a precaution add to post information:
Details
Date
Software 2015-05-24 19:25:15 UTC
Processed 162 lines
#Fields: date time line_nr action comment
2015-05-24 19:25:15 0 [DEBUG] Importing filetype: csv
2015-05-24 19:25:15 0 [DEBUG] Found field delimiter: ;
2015-05-24 19:25:15 0 [DEBUG] Load config fields
2015-05-24 19:25:15 0 [DEBUG] Field name: virtuemart_category_id
2015-05-24 19:25:15 0 [DEBUG] Field name: category_name
2015-05-24 19:25:15 0 [DEBUG] Field name: category_path
2015-05-24 19:25:15 0 [DEBUG] Field name: category_description
2015-05-24 19:25:15 0 [DEBUG] Field name: file_url
2015-05-24 19:25:15 0 [DEBUG] Field name: file_url_thumb
2015-05-24 19:25:15 0 [DEBUG] Field name: published
2015-05-24 19:25:15 0 [DEBUG] Field name: slug
2015-05-24 19:25:15 0 [DEBUG] Field name: virtuemart_vendor_id
2015-05-24 19:25:15 0 [DEBUG] Use database for configuration
2015-05-24 19:25:15 0 [DEBUG] CSVI Pro Version: 5.21.2
2015-05-24 19:25:15 0 [DEBUG] PHP version: 5.6.3
2015-05-24 19:25:15 0 [DEBUG] action: import
2015-05-24 19:25:15 0 [DEBUG] component: com_virtuemart
2015-05-24 19:25:15 0 [DEBUG] operation: categoryimport
2015-05-24 19:25:15 0 [DEBUG] source: fromupload
2015-05-24 19:25:15 0 [DEBUG] Load from computer: category_export.csv
2015-05-24 19:25:15 0 [DEBUG] local_csv_file:
2015-05-24 19:25:15 0 [DEBUG] urlfile:
2015-05-24 19:25:15 0 [DEBUG] ftphost:
2015-05-24 19:25:15 0 [DEBUG] ftpport:
2015-05-24 19:25:15 0 [DEBUG] ftproot:
2015-05-24 19:25:15 0 [DEBUG] ftpfile:
2015-05-24 19:25:15 0 [DEBUG] auto_detect_delimiters: Tak
2015-05-24 19:25:15 0 [DEBUG] field_delimiter: comma
2015-05-24 19:25:15 0 [DEBUG] text_enclosure: "
2015-05-24 19:25:15 0 [DEBUG] use_file_extension:
2015-05-24 19:25:15 0 [DEBUG] im_mac: Nie
2015-05-24 19:25:15 0 [DEBUG] use_column_headers: Nie
2015-05-24 19:25:15 0 [DEBUG] add_extra_fields: Nie
2015-05-24 19:25:15 0 [DEBUG] skip_first_line: Tak
2015-05-24 19:25:15 0 [DEBUG] overwrite_existing_data: Tak
2015-05-24 19:25:15 0 [DEBUG] collect_debug_info: Tak
2015-05-24 19:25:15 0 [DEBUG] xml_record_name:
2015-05-24 19:25:15 0 [DEBUG] language: pl-PL
2015-05-24 19:25:15 0 [DEBUG] target_language: pl-PL
2015-05-24 19:25:15 0 [DEBUG] category_separator: /
2015-05-24 19:25:15 0 [DEBUG] process_image: Nie
2015-05-24 19:25:15 0 [DEBUG] change_case: none
2015-05-24 19:25:15 0 [DEBUG] autofill: Nie
2015-05-24 19:25:15 0 [DEBUG] keep_original: Nie
2015-05-24 19:25:15 0 [DEBUG] convert_type: none
2015-05-24 19:25:15 0 [DEBUG] save_images_on_server: Nie
2015-05-24 19:25:15 0 [DEBUG] redownload_external_image: Tak
2015-05-24 19:25:15 0 [DEBUG] full_resize: Nie
2015-05-24 19:25:15 0 [DEBUG] full_width:
2015-05-24 19:25:15 0 [DEBUG] full_height:
2015-05-24 19:25:15 0 [DEBUG] full_watermark: Nie
2015-05-24 19:25:15 0 [DEBUG] full_watermark_right:
2015-05-24 19:25:15 0 [DEBUG] full_watermark_bottom:
2015-05-24 19:25:15 0 [DEBUG] full_watermark_image:
2015-05-24 19:25:15 0 [DEBUG] thumb_check_filetype: Nie
2015-05-24 19:25:15 0 [DEBUG] thumb_create: Nie
2015-05-24 19:25:15 0 [DEBUG] thumb_extension: none
2015-05-24 19:25:15 0 [DEBUG] thumb_width: 90
2015-05-24 19:25:15 0 [DEBUG] thumb_height: 90
2015-05-24 19:25:15 0 [DEBUG] file_location_category_images:
2015-05-24 19:25:15 0 [DEBUG] use_system_limits: Nie
2015-05-24 19:25:15 0 [DEBUG] max_execution_time:
2015-05-24 19:25:15 0 [DEBUG] memory_limit:
2015-05-24 19:25:15 0 [DEBUG] post_max_size:
2015-05-24 19:25:15 0 [DEBUG] upload_max_filesize:
2015-05-24 19:25:15 0 [DEBUG] template_name: Example VirtueMart Category import
2015-05-24 19:25:15 0 [DEBUG] id: 7
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Process line 1
2015-05-24 19:25:16 1 [DEBUG] Use field value
2015-05-24 19:25:16 1 [DEBUG] Category details query
2015-05-24 19:25:16 1 [QUERY] UPDATE `kphag_virtuemart_categories` SET `virtuemart_vendor_id`='1',`published`='1',`modified_on`='2015-05-24 19:25:16',`modified_by`='626' WHERE `virtuemart_category_id`='1'
2015-05-24 19:25:16 1 [DEBUG] Check category language
2015-05-24 19:25:16 1 [QUERY] SELECT virtuemart_category_id FROM kphag_virtuemart_categories_pl_pl WHERE `virtuemart_category_id` = 1
2015-05-24 19:25:16 1 [DEBUG] Category details query
2015-05-24 19:25:16 1 [QUERY] UPDATE `kphag_virtuemart_categories_pl_pl` SET `category_name`='Akcesoria plandekowe',`category_description`='text…',`metadesc`='',`metakey`='',`customtitle`='',`slug`='akcesoria-plandekowe' WHERE `virtuemart_category_id`='1'
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Process line 2
2015-05-24 19:25:16 2 [DEBUG] Use field value
2015-05-24 19:25:16 2 [DEBUG] Category details query
2015-05-24 19:25:16 2 [QUERY] UPDATE `kphag_virtuemart_categories` SET `virtuemart_vendor_id`='1',`published`='1',`modified_on`='2015-05-24 19:25:16',`modified_by`='626' WHERE `virtuemart_category_id`='2'
2015-05-24 19:25:16 2 [DEBUG] Check category language
2015-05-24 19:25:16 2 [QUERY] SELECT virtuemart_category_id FROM kphag_virtuemart_categories_pl_pl WHERE `virtuemart_category_id` = 2
2015-05-24 19:25:16 2 [DEBUG] Add category language
2015-05-24 19:25:16 2 [QUERY] INSERT INTO kphag_virtuemart_categories_pl_pl (`virtuemart_category_id`, `slug`) VALUES ('2', 'akcesoria-tapicerskie')
2015-05-24 19:25:16 2 [DEBUG] Category details query
2015-05-24 19:25:16 2 [QUERY] UPDATE `kphag_virtuemart_categories_pl_pl` SET `category_name`='Akcesoria tapicerskie',`category_description`='text…',`slug`='akcesoria-tapicerskie' WHERE `virtuemart_category_id`='2'
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Process line 3
2015-05-24 19:25:16 3 [DEBUG] Use field value
2015-05-24 19:25:16 3 [DEBUG] Category details query
2015-05-24 19:25:16 3 [QUERY] UPDATE `kphag_virtuemart_categories` SET `virtuemart_vendor_id`='1',`published`='1',`modified_on`='2015-05-24 19:25:16',`modified_by`='626' WHERE `virtuemart_category_id`='3'
2015-05-24 19:25:16 3 [DEBUG] Check category language
2015-05-24 19:25:16 3 [QUERY] SELECT virtuemart_category_id FROM kphag_virtuemart_categories_pl_pl WHERE `virtuemart_category_id` = 3
2015-05-24 19:25:16 3 [DEBUG] Add category language
2015-05-24 19:25:16 3 [QUERY] INSERT INTO kphag_virtuemart_categories_pl_pl (`virtuemart_category_id`, `slug`) VALUES ('3', 'maty-kokosowe')
2015-05-24 19:25:16 3 [DEBUG] Category details query
2015-05-24 19:25:16 3 [QUERY] UPDATE `kphag_virtuemart_categories_pl_pl` SET `category_name`='Maty kokosowe',`category_description`='text…',`slug`='maty-kokosowe' WHERE `virtuemart_category_id`='3'
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Process line 4
2015-05-24 19:25:16 4 [DEBUG] Use field value
2015-05-24 19:25:16 4 [DEBUG] Category details query
2015-05-24 19:25:16 4 [QUERY] UPDATE `kphag_virtuemart_categories` SET `virtuemart_vendor_id`='1',`published`='1',`modified_on`='2015-05-24 19:25:16',`modified_by`='626' WHERE `virtuemart_category_id`='4'
2015-05-24 19:25:16 4 [DEBUG] Check category language
2015-05-24 19:25:16 4 [QUERY] SELECT virtuemart_category_id FROM kphag_virtuemart_categories_pl_pl WHERE `virtuemart_category_id` = 4
2015-05-24 19:25:16 4 [DEBUG] Add category language
2015-05-24 19:25:16 4 [QUERY] INSERT INTO kphag_virtuemart_categories_pl_pl (`virtuemart_category_id`, `slug`) VALUES ('4', 'pianki-tapicerskie')
2015-05-24 19:25:16 4 [DEBUG] Category details query
2015-05-24 19:25:16 4 [QUERY] UPDATE `kphag_virtuemart_categories_pl_pl` SET `category_name`='Pianki tapicerskie',`category_description`='text…',`slug`='pianki-tapicerskie' WHERE `virtuemart_category_id`='4'
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Process line 5
2015-05-24 19:25:16 5 [DEBUG] Use field value
2015-05-24 19:25:16 5 [DEBUG] Category details query
2015-05-24 19:25:16 5 [QUERY] UPDATE `kphag_virtuemart_categories` SET `virtuemart_vendor_id`='1',`published`='1',`modified_on`='2015-05-24 19:25:16',`modified_by`='626' WHERE `virtuemart_category_id`='5'
2015-05-24 19:25:16 5 [DEBUG] Check category language
2015-05-24 19:25:16 5 [QUERY] SELECT virtuemart_category_id FROM kphag_virtuemart_categories_pl_pl WHERE `virtuemart_category_id` = 5
2015-05-24 19:25:16 5 [DEBUG] Add category language
2015-05-24 19:25:16 5 [QUERY] INSERT INTO kphag_virtuemart_categories_pl_pl (`virtuemart_category_id`, `slug`) VALUES ('5', 'plyty-pilsniowe')
2015-05-24 19:25:16 5 [DEBUG] Category details query
2015-05-24 19:25:16 5 [QUERY] UPDATE `kphag_virtuemart_categories_pl_pl` SET `category_name`='Płyty pilśniowe',`category_description`='text…',`slug`='plyty-pilsniowe' WHERE `virtuemart_category_id`='5'
2015-05-24 19:25:16 49 [DEBUG] Clean up old logs. Found 1 logs and threshold is 25 logs
11 Incorrect Failure Category name does not match category path. Make sure that the category_name field matches the last category in category_path field.
Attachments (1)
Accepted Answer
Pending Moderation
Hello,
When importing there was a problem (in the annex).Click on Show full log to see the details as to why you get an Incorrect status. Alternatively, go to Logs and view the details. Now we have no idea what the actual incorrect message is.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »