Categories
View Replies (4)

Resolved Category Import deleting image off server and failing

  1. batetim
    batetim
  2. RO CSVI
  3. Thursday, 05 January 2017
  4.  Subscribe via email
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
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Tim,
The debug log lines you have posted shows the image has been processed fine and then information is incomplete. Not sure what has happened after that. Please attach your full debug log along with sample import file to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
batetim
batetim
Accepted Answer Pending Moderation
Hi Tharuna

As attached, this is the full import log but the import eventually fails and throws a server error message and import has to be cancelled - so this log may be truncated

com_csvi.log.27.zip RBDCategoryTemplateFEB16-aqua.csv

Kind regards

Tim
Attachments (2)
com_csvi.log.27.zip
RBDCategoryTemplateFEB16-aqua.csv
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Looks like your import is breaking when trying to resize the image. What if you remove Maximum width resize, Maximum height resize on Image tab in your template setting and try the import? Also since you have the image already on your server you dont have to set Save images on server to Yes. This is for saving remote images on your server during import. You can set this option to No. Try import and see if it works else send the image in a private message and i will look into it.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
batetim
batetim
Accepted Answer Pending Moderation
Hi Tharuna

Turning off the image re size has sorted the issue, we will just make sure that images arent too big before we preload to image location.

Thanks for your help

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!