1. m_pascal
  2. RO CSVI
  3. Friday, 11 September 2015
  4.  Subscribe via email
I get an "Internal Server Error" when importing a CSV file for Virtuemart products.
I'm using Joomla 3.4.4, Virtuemart 3.0.9, com_csvi_6.1.2_pro and plg_csviaddon_virtuemart_csvi_6.1.2
When I try to import the file everything work well till to preview screen. After that screen I get this error
Status error: 500
Status message: Internal Server Error

What to do?
Accepted Answer Pending Moderation
Start with the 500 Internal Server Error document. Once the real error is known, we will know where to look.
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. # 1
Accepted Answer Pending Moderation
Start with the 500 Internal Server Error document. Once the real error is known, we will know where to look.

I had already read that page before you ask the question in the forum, however:
tmp/com_csvi/ folder does not have correct priviliges
Solution: Set the correct priviliges for the tmp/com_csvi folder

Done. All the privileges were 755

Trying to resize images that are too large
Solution:
Make sure your large images are not too large
Create your own thumbnails
Set the maximum size of the large image CSVI should create a thumbnail for (CSVI Pro)

I tried even to set "Process Images=NO" in my import settings but I still have the 500 Internal Server Error

In log area of my server I found this:

[Sun Sep 13 18:17:46 2015] [error] [client 79.27.39.234:51114] - incisoriasacchetti.it - End of script output before headers: rantai.php, referer http://www.incisoriasacchetti.it/administrator/index.php?option=com_csvi&view=import
[Sun Sep 13 18:17:46 2015] [error] [client 79.27.39.234:51114] - incisoriasacchetti.it - AH01215: suexec policy violation: see suexec log for more details: /web/htdocs/http://www.incisoriasacchetti.it/home/administrator/components/com_csvi/rantai/rantai.php, referer http://www.incisoriasacchetti.it/administrator/index.php?option=com_csvi&view=import
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
I tried even to set "Process Images=NO" in my import settings but I still have the 500 Internal Server Error
That is not because of the images but because your servers suphp settings as you posted from what you found in the log.

As your log states:
AH01215: suexec policy violation: see suexec log for more details: /web/htdocs/http://www.incisoriasacchetti.it/home/administrator/components/com_csvi/rantai/rantai.php
You will need to check the suexec log why the CSVI script gets killed. Once we know that we can have a look at 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
I tried even to set "Process Images=NO" in my import settings but I still have the 500 Internal Server Error
That is not because of the images but because your servers suphp settings as you posted from what you found in the log.

As your log states:
AH01215: suexec policy violation: see suexec log for more details: /web/htdocs/http://www.incisoriasacchetti.it/home/administrator/components/com_csvi/rantai/rantai.php
You will need to check the suexec log why the CSVI script gets killed. Once we know that we can have a look at that.

The problem was due to a bug in the Aruba server where I visualized the 755 permissions on folders but evidently were not so. By using the FIX PERMISSIONS button on the control panel everything started to work as expected.
Now I'm able to import my CSV file.

However I noticed something strange: after importing 140 new products, I realized that I had to make some changes and so I changed some data in my CSV file, after I imported it again telling CSVI PRo to overwrite existing data, skip new items and do not to add extra fields.
After the procedure I noticed that in the log were marked 418 added product custom fields. It should be so?
I expected to find 418 updated custom fields. Am I doing something wrong? I'm tainting the database? Is it a bug?

And what about "Line 0"?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

It should be so?
I expected to find 418 updated custom fields. Am I doing something wrong? I'm tainting the database? Is it a bug?
Many questions but actually all the same. Custom fields are removed and then added again, that is why you see them as added. Nothing wrong, nothing tainted and no bug.

And what about "Line 0"?
What about it? Don't understand the question here.
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
Custom fields are removed and then added again, that is why you see them as added. Nothing wrong, nothing tainted and no bug.

Perfect! Thank you!

Don't understand the question here.

The question is:
- why category_name, pictue_url and picture_url_thumb unsupported? Are that field automatically compiled from Virtuemart when I'm importing my CSV file?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Those fields are only available for export, not for import. The category_name is the category_path on import but this field also exists for export. The import of images is file_url and file_url_thumb, these fields are as well available for export.
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. # 7
Accepted Answer Pending Moderation
Thank you very much.
I think that now I've all the information I need for my works ;)
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


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