Categories
View Replies (7)

Resolved 500 Internal Server error (import virtuemart)

  1. frandevelop
    frandevelop
  2. RO CSVI
  3. Thursday, 30 July 2015
  4.  Subscribe via email
Hi,

I get the following error when I try to make "preview" a csv file with one record.

500 Internal Server error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@xxxxxxxx.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I even set the permissions to 777 as shown in this post: http://www.csvimproved.com/en/support/questions-and-answers/854-500-internal-server-error

the file initially don't contains images, just a record with a few columns.

In the hosting logs I see little information:
- FastCGI: comm with server "/var/www/vhost/http://xxxxxxxxx.com/fcgi-bin/php.fcgi" aborted: idle timeout (30 sec), referer: http://www.xxxxxxxxx.com/administrator/index.php?option=com_csvi&view=importsource&runId=10
- FastCGI: incomplete headers (0 bytes) received from server "/var/www/vhost/http://xxxxxxxxx.com/fcgi-bin/php.fcgi", referer: http://www.xxxxxxxxx.com/administrator/index.php?option=com_csvi&view=importsource&runId=10
- File does not exist: /var/www/vhost/http://xxxxxxxxx.com/home/errors/500.html, referer: http://www.xxxxxxxxx.com/administrator/index.php?option=com_csvi&view=importsource&runId=10

Can you help me?
0
Responses (7)
frandevelop
frandevelop
Accepted Answer Pending Moderation
Sorry, versions of products:

CSVI: Pro 6.0.1
VIRTUEMART: 3.0.9
JOOMLA: 3.4.3
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

First of all, do not set any files or folders to 777 this is a security risk. Folders should always be 755 and files should always be 644.

Can you post the file you are testing with?

One thing you can try is to set the Autodetect delimiters to No in the template and specify the field delimiter and text enclosure yourself. Save the template and give it another try.
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. # 2
frandevelop
frandevelop
Accepted Answer Pending Moderation
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@xxxxxxx.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Attachments (1)
ProductosEN.csv
  1. more than a month ago
  2. RO CSVI
  3. # 3
frandevelop
frandevelop
Accepted Answer Pending Moderation
I think the problem is with the category_name field, if adjusted for categoria_id if that works :S
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
The problem is that the file is not saved as UTF-8, this can cause an internal server error because all text in Joomla must be UTF-8. You can use the category_path of course but the file must be saved as UTF-8. Check the Save file as UTF-8 document to see how to save a file as UTF-8.
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
frandevelop
frandevelop
Accepted Answer Pending Moderation
The problem persist :S

Any other ideas?
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
If the problem persist then I still believe something is wrong with your CSV file. In your template also set the Auto-detect delimiters to No and specify the field delimiter and text enclosure yourself.

Post your CSV file, so I can check it is a valid UTF-8 file.
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
  • Page :
  • 1


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