Hi CSVI
Having issues with a single line category import.
PHP version 5.5.38
Joomla! version 3.6.5
CSVI 6.6.4
As normal we preload image to server space /public_html/images/stories/virtuemart/category but on import it fails eventually giving a server error with debug log as below and deleting image that had been previously existed.
Log as below:
Details
Date 2017-01-05 18:01:07 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 107 lines
2017-01-05 18:01:07 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs
2017-01-05 18:01:07 0 [QUERY] SELECT csvi_log_id FROM hal3m_csvi_logs ORDER BY csvi_log_id
2017-01-05 18:01:40 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2017-01-05 18:01:40 0 [QUERY] SELECT csvi_log_id FROM hal3m_csvi_logs ORDER BY csvi_log_id
2017-01-05 18:01:42 0 [DEBUG] Found field delimiter: ,
2017-01-05 18:01:42 0 [DEBUG] Loading the supported fields for com_virtuemart, operation category and action import
2017-01-05 18:01:42 0 [QUERY] SELECT `a`.`csvi_name` FROM `hal3m_csvi_availablefields` AS `a` LEFT JOIN `hal3m_csvi_availabletables` AS `t` ON `t`.`template_table` = `a`.`component_table` WHERE `a`.`component` = 'com_virtuemart' AND `t`.`component` = 'com_virtuemart' AND `t`.`task_name` = 'category' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2017-01-05 18:01:42 0 [DEBUG] Load the fields to process
2017-01-05 18:01:42 0 [DEBUG] Setup field: category_path
2017-01-05 18:01:42 0 [DEBUG] Setup field: category_description
2017-01-05 18:01:42 0 [DEBUG] Setup field: file_url
2017-01-05 18:01:42 0 [DEBUG] Setup field: file_url_thumb
2017-01-05 18:01:42 0 [DEBUG] Setup field: published
2017-01-05 18:01:42 0 [DEBUG] Setup field: slug
2017-01-05 18:01:42 0 [DEBUG] Setup field: metadesc
2017-01-05 18:01:42 0 [DEBUG] Setup field: customtitle
2017-01-05 18:01:42 0 [DEBUG] Use the file for configuration
2017-01-05 18:01:42 0 [DEBUG] ==========
2017-01-05 18:01:42 0 [DEBUG] CSVI Pro Version: 6.6.4
2017-01-05 18:01:42 0 [DEBUG] PHP version: 5.5.38
2017-01-05 18:01:42 0 [DEBUG] Action: import
2017-01-05 18:01:42 0 [DEBUG] Component: com_virtuemart
2017-01-05 18:01:42 0 [DEBUG] Operation: category
2017-01-05 18:01:42 0 [DEBUG] Override:
2017-01-05 18:01:42 0 [DEBUG] Source: fromupload
2017-01-05 18:01:42 0 [DEBUG] Load from your computer: /home/cluster-sites/1050/r/http://recyclingbins-direct.co.uk/public_html/tmp/com_csvi/1483639285/RBDCategoryTemplateFEB16-aqua.csv
2017-01-05 18:01:42 0 [DEBUG] Load from server:
2017-01-05 18:01:42 0 [DEBUG] Delete after import: No
2017-01-05 18:01:42 0 [DEBUG] Load from URL: http://
2017-01-05 18:01:42 0 [DEBUG] URL Username:
2017-01-05 18:01:42 0 [DEBUG] Name of username field: user
2017-01-05 18:01:42 0 [DEBUG] URL Password:
2017-01-05 18:01:42 0 [DEBUG] Name of the password field: password
2017-01-05 18:01:42 0 [DEBUG] Retrieve method: get
2017-01-05 18:01:42 0 [DEBUG] FTP Host:
2017-01-05 18:01:42 0 [DEBUG] FTP Port:
2017-01-05 18:01:42 0 [DEBUG] FTP Root Folder:
2017-01-05 18:01:42 0 [DEBUG] FTP Filename:
2017-01-05 18:01:42 0 [DEBUG] Autodetect delimiters: Yes
2017-01-05 18:01:42 0 [DEBUG] Field Delimiter: comma
2017-01-05 18:01:42 0 [DEBUG] Text Enclosure:
2017-01-05 18:01:42 0 [DEBUG] Use file extension:
2017-01-05 18:01:42 0 [DEBUG] I'm Mac: No
2017-01-05 18:01:42 0 [DEBUG] Use file for configuration: Yes
2017-01-05 18:01:42 0 [DEBUG] Add extra fields: No
2017-01-05 18:01:42 0 [DEBUG] Skip first line: No
2017-01-05 18:01:42 0 [DEBUG] Overwrite existing data: Yes
2017-01-05 18:01:42 0 [DEBUG] Skip new items: No
2017-01-05 18:01:42 0 [DEBUG] Record name:
2017-01-05 18:01:42 0 [DEBUG] Language: en-GB
2017-01-05 18:01:42 0 [DEBUG] Translation language: en-GB
2017-01-05 18:01:42 0 [DEBUG] Category separator: _
2017-01-05 18:01:42 0 [DEBUG] Recreate alias: No
2017-01-05 18:01:42 0 [DEBUG] Process images: Yes
2017-01-05 18:01:42 0 [DEBUG] Location category images:
2017-01-05 18:01:42 0 [DEBUG] Change case: none
2017-01-05 18:01:42 0 [DEBUG] Fill media fields: No
2017-01-05 18:01:42 0 [DEBUG] Delete image relations: No
2017-01-05 18:01:42 0 [DEBUG] Keep original file: Yes
2017-01-05 18:01:42 0 [DEBUG] Convert image type: none
2017-01-05 18:01:42 0 [DEBUG] Save images on server: Yes
2017-01-05 18:01:42 0 [DEBUG] Re-download image: Yes
2017-01-05 18:01:42 0 [DEBUG] Resize large image: Yes
2017-01-05 18:01:42 0 [DEBUG] Full image width:
2017-01-05 18:01:42 0 [DEBUG] Full image height:
2017-01-05 18:01:42 0 [DEBUG] Check filetype: No
2017-01-05 18:01:42 0 [DEBUG] Automatic thumbnail creation: Yes
2017-01-05 18:01:42 0 [DEBUG] Thumbnail type: none
2017-01-05 18:01:42 0 [DEBUG] Thumbnail width: 200
2017-01-05 18:01:42 0 [DEBUG] Thumbnail height: 200
2017-01-05 18:01:42 0 [DEBUG] Maximum width resize: 1500
2017-01-05 18:01:42 0 [DEBUG] Maximum height resize: 1500
2017-01-05 18:01:42 0 [DEBUG] Watermark: No
2017-01-05 18:01:42 0 [DEBUG] Right margin:
2017-01-05 18:01:42 0 [DEBUG] Bottom margin:
2017-01-05 18:01:42 0 [DEBUG] Image:
2017-01-05 18:01:42 0 [DEBUG] Lines per import: 25
2017-01-05 18:01:42 0 [DEBUG] Time between imports: 5
2017-01-05 18:01:42 0 [DEBUG] Override system limits?: No
2017-01-05 18:01:42 0 [DEBUG] Maximum execution time:
2017-01-05 18:01:42 0 [DEBUG] Maximum amount of memory:
2017-01-05 18:01:42 0 [DEBUG] Maximum size of POST data in megabytes:
2017-01-05 18:01:42 0 [DEBUG] Maximum allowed size for uploaded files in megabytes:
2017-01-05 18:01:42 0 [DEBUG] COM_CSVI_JFORM_csvi_template_id_LABEL: Yes
2017-01-05 18:01:42 0 [DEBUG] COM_CSVI_JFORM_tags_LABEL:
2017-01-05 18:01:42 0 [DEBUG] ==========
2017-01-05 18:01:42 1 [DEBUG] Use field value for field category_path
2017-01-05 18:01:42 1 [DEBUG] Use field value for field category_description
2017-01-05 18:01:42 1 [DEBUG] Use field value for field file_url
2017-01-05 18:01:42 1 [DEBUG] Use field value for field file_url_thumb
2017-01-05 18:01:42 1 [DEBUG] Use field value for field published
2017-01-05 18:01:42 1 [DEBUG] Use field value for field slug
2017-01-05 18:01:42 1 [DEBUG] Use field value for field metadesc
2017-01-05 18:01:42 1 [DEBUG] Use field value for field customtitle
2017-01-05 18:01:42 1 [DEBUG] Process line 1
2017-01-05 18:01:42 1 [DEBUG] Check if category path exists: Childrens Novelty Aqua Buddy Bins
2017-01-05 18:01:42 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `hal3m_virtuemart_categories` AS `c` LEFT JOIN `hal3m_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `hal3m_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Childrens Novelty Aqua Buddy Bins' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2017-01-05 18:01:42 1 [DEBUG] Process file: /home/cluster-sites/1050/r/http://recyclingbins-direct.co.uk/public_html/images/stories/virtuemart/category/aquabuddyrange.jpg
2017-01-05 18:01:42 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000
2017-01-05 18:01:42 1 [DEBUG] Process image file
2017-01-05 18:01:42 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000
2017-01-05 18:01:42 1 [DEBUG] Mime type found: image/jpeg
2017-01-05 18:01:42 1 [DEBUG] Full name original: /home/cluster-sites/1050/r/http://recyclingbins-direct.co.uk/public_html/images/stories/virtuemart/category/aquabuddyrange.jpg
2017-01-05 18:01:42 1 [DEBUG] Full name target: images/stories/virtuemart/category/aquabuddyrange.jpg
2017-01-05 18:01:42 1 [DEBUG] COM_CSVI_DEBUG_RESIZE_IMAGE
2017-01-05 18:01:42 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `hal3m_virtuemart_categories` AS `c` LEFT JOIN `hal3m_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `hal3m_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Childrens Novelty Aqua Buddy Bins' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2017-01-05 18:01:42 1 [DEBUG] Save the new image
Would appreciate any advice?
Kind regards
Tim
- batetim
- RO CSVI
- Thursday, 05 January 2017
- Subscribe via email
- 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!