1. enoch
  2. RO CSVI
  3. Friday, 06 May 2016
  4.  Subscribe via email
Hi,
I am trying to import categories into Joomla 3.5.1, virtuemart 3.0.12 with csv improved version 6.5.7
I get a 500 server error upon the final step of importing the csv file.
Here is the server log - do you have any tips for me?
I am currently running the site on a temporary url at http://112.140.176.61/~victori/

#
#<?php die('Forbidden.'); ?>
#Date: 2016-05-06 06:55:41 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: date time line_nr action comment
2016-05-06 06:55:41 0 [DEBUG] Clean up old logs. Found 10 logs and threshold is 25 logs
2016-05-06 06:55:42 0 [QUERY] SELECT csvi_log_id FROM s73e0_csvi_logs ORDER BY csvi_log_id
2016-05-06 06:55:48 0 [DEBUG] Clean up old logs. Found 10 logs and threshold is 25 logs
2016-05-06 06:55:48 0 [QUERY] SELECT csvi_log_id FROM s73e0_csvi_logs ORDER BY csvi_log_id
2016-05-06 06:55:49 0 [DEBUG] Found field delimiter: ,
2016-05-06 06:55:49 0 [DEBUG] Loading the supported fields for com_virtuemart, operation category and action import
2016-05-06 06:55:49 0 [QUERY] SELECT `a`.`csvi_name` FROM `s73e0_csvi_availablefields` AS `a` LEFT JOIN `s73e0_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'
2016-05-06 06:55:49 0 [DEBUG] Load the fields to process
2016-05-06 06:55:49 0 [DEBUG] Field name: category_name
2016-05-06 06:55:49 0 [DEBUG] Field name: category_path
2016-05-06 06:55:49 0 [DEBUG] Field name: file_url
2016-05-06 06:55:49 0 [DEBUG] ==========
2016-05-06 06:55:49 0 [DEBUG] CSVI Pro Version: 6.5.7
2016-05-06 06:55:49 0 [DEBUG] PHP version: 5.6.20
2016-05-06 06:55:49 0 [DEBUG] Action: import
2016-05-06 06:55:49 0 [DEBUG] Component: com_virtuemart
2016-05-06 06:55:49 0 [DEBUG] Operation: category
2016-05-06 06:55:49 0 [DEBUG] Source: fromupload
2016-05-06 06:55:49 0 [DEBUG] Load from your computer: /home/victori/public_html/tmp/com_csvi/1462517746/category list test1.csv
2016-05-06 06:55:49 0 [DEBUG] Load from server:
2016-05-06 06:55:49 0 [DEBUG] Delete after import: No
2016-05-06 06:55:49 0 [DEBUG] Load from URL: http://
2016-05-06 06:55:49 0 [DEBUG] FTP Host:
2016-05-06 06:55:49 0 [DEBUG] FTP Port:
2016-05-06 06:55:49 0 [DEBUG] FTP Root Folder:
2016-05-06 06:55:49 0 [DEBUG] FTP Filename:
2016-05-06 06:55:49 0 [DEBUG] Autodetect delimiters: Yes
2016-05-06 06:55:49 0 [DEBUG] Field Delimiter: comma
2016-05-06 06:55:49 0 [DEBUG] Text Enclosure:
2016-05-06 06:55:49 0 [DEBUG] Use file extension:
2016-05-06 06:55:49 0 [DEBUG] I'm Mac: No
2016-05-06 06:55:49 0 [DEBUG] Use file for configuration: No
2016-05-06 06:55:49 0 [DEBUG] Add extra fields: No
2016-05-06 06:55:49 0 [DEBUG] Skip first line: No
2016-05-06 06:55:49 0 [DEBUG] Overwrite existing data: Yes
2016-05-06 06:55:49 0 [DEBUG] Skip new items: No
2016-05-06 06:55:49 0 [DEBUG] Record name:
2016-05-06 06:55:49 0 [DEBUG] Category separator: /
2016-05-06 06:55:49 0 [DEBUG] Recreate alias: No
2016-05-06 06:55:49 0 [DEBUG] Process images: Yes
2016-05-06 06:55:49 0 [DEBUG] Location category images:
2016-05-06 06:55:49 0 [DEBUG] Change case: none
2016-05-06 06:55:49 0 [DEBUG] Fill media fields: No
2016-05-06 06:55:49 0 [DEBUG] Delete image relations: No
2016-05-06 06:55:49 0 [DEBUG] Keep original file: No
2016-05-06 06:55:49 0 [DEBUG] Convert image type: none
2016-05-06 06:55:49 0 [DEBUG] Save images on server: No
2016-05-06 06:55:49 0 [DEBUG] Re-download image: Yes
2016-05-06 06:55:49 0 [DEBUG] Resize large image: No
2016-05-06 06:55:49 0 [DEBUG] Full image width:
2016-05-06 06:55:49 0 [DEBUG] Full image height:
2016-05-06 06:55:49 0 [DEBUG] Check filetype: No
2016-05-06 06:55:49 0 [DEBUG] Automatic thumbnail creation: No
2016-05-06 06:55:49 0 [DEBUG] Thumbnail type: none
2016-05-06 06:55:49 0 [DEBUG] Thumbnail width: 90
2016-05-06 06:55:49 0 [DEBUG] Thumbnail height: 90
2016-05-06 06:55:49 0 [DEBUG] Maximum width resize: 1024
2016-05-06 06:55:49 0 [DEBUG] Maximum height resize: 768
2016-05-06 06:55:49 0 [DEBUG] Watermark: No
2016-05-06 06:55:49 0 [DEBUG] Right margin:
2016-05-06 06:55:49 0 [DEBUG] Bottom margin:
2016-05-06 06:55:49 0 [DEBUG] Image:
2016-05-06 06:55:49 0 [DEBUG] Lines per import: 1000
2016-05-06 06:55:49 0 [DEBUG] Time between imports: 5
2016-05-06 06:55:49 0 [DEBUG] Override system limits?: No
2016-05-06 06:55:49 0 [DEBUG] Maximum execution time:
2016-05-06 06:55:49 0 [DEBUG] Maximum amount of memory:
2016-05-06 06:55:49 0 [DEBUG] Maximum size of POST data in megabytes:
2016-05-06 06:55:49 0 [DEBUG] Maximum allowed size for uploaded files in megabytes:
2016-05-06 06:55:49 0 [DEBUG] ==========
Accepted Answer Pending Moderation
Hello,
I get a 500 server error upon the final step of importing the csv file.
Here is the server log - do you have any tips for me?

500 internal server error is something which dont give us any information on what went wrong. Have a look at 500 internal server error document and see if it helps. If not you need to collect your server logs from your hosting provider which would give us the cause for the error.
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
Accepted Answer Pending Moderation
Thanks Tharuna,
We are running php 5.6 (and I also tested briefly with 7.0 and had the same issue). The file permissions are right and there is no issue with the upload file size (as it is a tiny file!)
My provider can confirm that there is no firewall issue, no mod_security rule is not triggered by your service.
They say they can't see any error logs related to this issue.
What else can we do to get this working?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

They say they can't see any error logs related to this issue.
That I actually doubt, the server always logs a 500 error because it is a fatal error. Unless they setup the server to not log them but that would be really weird.

What else can we do to get this working?
Without the actual error it is anybody's guess. It is not even looking for a needle in a haystack but rather looking for a needle in the ocean.

If the server people can't spot a fatal error in the log, perhaps ask them for the error log (not the access log) so we can check that.
Kind regards,

RolandD

=========================
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
Accepted Answer Pending Moderation
Thanks Roland,
They couldn't spot fatal errors in the log, but here is the error log itself.
It doesn't look too helpful too me - is it useful for you?

[04-May-2016 08:22:01 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[04-May-2016 10:11:53 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[04-May-2016 10:15:05 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[04-May-2016 10:15:17 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[04-May-2016 10:31:32 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[04-May-2016 10:31:36 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[04-May-2016 10:32:08 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:13:51 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:14:16 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:16:38 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:16:39 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:16:47 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:16:53 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 00:16:57 UTC] PHP Warning: Header may not contain more than a single header, new line detected in /home/victori/public_html/libraries/joomla/application/web.php on line 961
[06-May-2016 08:23:54 UTC] PHP Warning: Declaration of plgVMPaymentPayzen::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/payzen/payzen.php on line 833
[06-May-2016 08:23:54 UTC] PHP Warning: Declaration of plgVMPaymentSystempay::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/systempay/systempay.php on line 833
[09-May-2016 05:27:02 UTC] PHP Warning: Declaration of plgVMPaymentPayzen::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/payzen/payzen.php on line 833
[09-May-2016 05:27:02 UTC] PHP Warning: Declaration of plgVMPaymentSystempay::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/systempay/systempay.php on line 833
[09-May-2016 05:27:15 UTC] PHP Warning: Declaration of plgVMPaymentPayzen::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/payzen/payzen.php on line 833
[09-May-2016 05:27:15 UTC] PHP Warning: Declaration of plgVMPaymentSystempay::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/systempay/systempay.php on line 833
[09-May-2016 05:27:24 UTC] PHP Warning: Declaration of plgVMPaymentPayzen::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/payzen/payzen.php on line 833
[09-May-2016 05:27:24 UTC] PHP Warning: Declaration of plgVMPaymentSystempay::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/systempay/systempay.php on line 833
[09-May-2016 05:27:26 UTC] PHP Warning: Declaration of plgVMPaymentPayzen::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/payzen/payzen.php on line 833
[09-May-2016 05:27:26 UTC] PHP Warning: Declaration of plgVMPaymentSystempay::emptyCart($session_id) should be compatible with vmPSPlugin::emptyCart($session_id = NULL, $order_number = NULL) in /home/victori/public_html/plugins/vmpayment/systempay/systempay.php on line 833
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

There are no errors here but the warnings are either Joomla itself or VirtueMart nothing related to CSVI. Is this all the info they have?
Kind regards,

RolandD

=========================
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. # 5
Accepted Answer Pending Moderation
I seem to get it working now - thanks for your help.
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi, I have now been able to import about 50% of the categories I will be using.
However, the others are giving me this strange error:
The last category in the category path does not match the name set in the category name field. The last category is Books, Pads, & Self-adhesive Notes///Repositionable Notes and the category name is Repositionable Notes
It repeats similar warnings about the name not matching - but I can't see anything wrong with the name as in the above example.
The import has bee setup to look for /// as the category divider and it works fine for about 50% of the categories I am importing.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
The last category in the category path does not match the name set in the category name field. The last category is Books, Pads, & Self-adhesive Notes///Repositionable Notes and the category name is Repositionable Notes
It repeats similar warnings about the name not matching - but I can't see anything wrong with the name as in the above example.

The error is shown when your category_name doesnt match the last path in your category_path field. But then CSVI imports the category_name from category_path field, i mean the last entry in category_path field will be taken as the category name, so you can remove the field category_name from your import.

The import has bee setup to look for /// as the category divider and it works fine for about 50% of the categories I am importing.

The category divider has nothing to do with the error. Can you try doing the changes i mentioned above and try import again? If you still see issue post your debug log and 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. # 8
Accepted Answer Pending Moderation
Thank you Tharuna,
following your steps, I have been able to successfully import all the categories.
I am now importing thousands of products supplied by the client.
The list of products does not have the category_id from virtumart - but has the complete category_path
Would this work ok to import - i.e. does your system automatically find the category_name from the category_path and identify the category ID for import - or do I need to manually correlate this in the CSV file prior to importing?
Thanks for your help - you have been really great!
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
Would this work ok to import - i.e. does your system automatically find the category_name from the category_path and identify the category ID for import - or do I need to manually correlate this in the CSV file prior to importing?

Yes, you just need to give the category_path for a product and CSVI will find the corresponding category ID and insert in database. You dont need category_name field here.
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. # 10
Accepted Answer Pending Moderation
Excellent - thanks for your valuable assistance.
The product list that I am importing includes names of various manufacturers that do not exist in the system.
Do I need to make a separate list of manufacturers and import - or can the system simply create these new manufacturers based on the names of manufacturers in the import of products?
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,

You can use the same file you use for product import also for manufacturer import. Depending on how you setup the manufacturer import template you may get a warning of unsupported fields. This will happen if you set the Use file for configuration to Yes. If you set this option to No, you need to add the fields yourself to the template and the ones you don't use, you can choose the skip field for that and CSVI will skip them.
Kind regards,

RolandD

=========================
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. # 12
Accepted Answer Pending Moderation
Brilliant Roland,
Regarding product prices - do I need to import these separately from the main products import or can they be in the same file?
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,

If you use one price per product only they can be in the same file. If you use multiple prices you are better off in a separate file. The reason being, you would need to duplicate all other data as well for each price, that usually is too much overkill.
Kind regards,

RolandD

=========================
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. # 14
Accepted Answer Pending Moderation
Thanks for your great help!
  1. more than a month ago
  2. RO CSVI
  3. # 15
  • Page :
  • 1


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