Categories
View Replies (6)

Resolved 503 Error importing virtuemart products

  1. bellezasecret
    bellezasecret
  2. RO CSVI
  3. Saturday, 19 May 2018
  4.  Subscribe via email
We have always used the CSV INPROVED component in the importation of products and it has worked very well, this import could be done with all the products of the store, about 3000 products in a single file and it took approximately 15 minutes.

Now we have a problem when importing the file with the products, at 12 seconds the error 503 (img) appears, but we see that despite the error the system keeps importing product records in the database, very slowly and it gets to insert about 350 products, at the end of 30 minutes it stops (maximum process time of the server).

We thought it was a bug in the hosting service but we have been reviewing for several days, the speed and time of processes have increased and it is not solved.

We have renewed the version of the component in case there is some kind of incompatibility with the new version of joomla or virtuemart but it still fails.
I attach the product file, and one of the logs
We use CSVI 7.6.2
JOOMLA 3.8.6
Virtuemart 3.2.14
PHP version 6.6.36
0
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

PHP version 6 doesn't exist :)

Now we have a problem when importing the file with the products, at 12 seconds the error 503 (img) appears, but we see that despite the error the system keeps importing product records in the database
This error usually means some kind of code error is triggered. This is not really a hosting problem but we would need to see what the server error log says. Have a look at the 500 Internal Server Error document and see what you can find in the error log. Once we know that error, we also know what action to take to resolve this issue.
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
bellezasecret
bellezasecret
Accepted Answer Pending Moderation
PHP Versión 5.6.36 I wanted to say

./administrator/components/com_csvi/rantai/error_log

and these are the last lines of the file:

[21-May-2018 12:32:06 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422
[21-May-2018 12:32:11 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422
[21-May-2018 12:32:16 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422
[21-May-2018 12:32:21 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422


I have copied the first 27 products of this log file related to CSVI
com_csvi.log.86MODIFICADO.txt

I have activated in developer mode in the joomla configuration but I do not know where the log file 500 internal server error is located
Attachments (1)
com_csvi.log.86MODIFICADO.txt
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
/administrator/components/com_csvi/rantai/error_log

You have an error_log folder at this location? Just wondering how you have your error log folder set to CSVI location.

and these are the last lines of the file:

[21-May-2018 12:32:06 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422
[21-May-2018 12:32:11 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422
[21-May-2018 12:32:16 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422
[21-May-2018 12:32:21 UTC] PHP Notice: A non well formed numeric value encountered in /home2/belleza9/public_html/administrator/components/com_csvi/rantai/import/engine.php on line 422

These notices are not related to the issue you have with import but with the date value you are importing for product_available_date field. I would like to see your import file to find why you have these notices.

I have copied the first 27 products of this log file related to CSVI

Some thing i noticed in your import debug log, you have set Lines per import: No in your import template settings on Limit tab. This is the number of lines you import in one cycle and which is 1000 by default. You should be setting a number instead of No in this field. Try setting this to 500 or to a lesser number and see if your import works.

I have activated in developer mode in the joomla configuration but I do not know where the log file 500 internal server error is located

You should be getting the details of 500 internal server error from your server error logs. You can check with your hosting if you cant find its location.
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
bellezasecret
bellezasecret
Accepted Answer Pending Moderation
CSV_BS Ficha de Producto_19-05-2018_11.54.22(8b).csv CSV_BS Ficha de Producto_19-05-2018_11.54.22(8b).csv I attach an import file with few products
Attachments (1)
CSV_BS Ficha de Producto_19-05-2018_11.54.22(8b).csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
As expected, the format of product_available_date value is wrong and so you were seeing those notices. The value in your import file is 0000-00-00T00: 00: 00. Having the letter T in date is not a valid format of the date.

Did you run your import changing the Lines per import to a number? Do you still see error on your import?
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. # 5
bellezasecret
bellezasecret
Accepted Answer Pending Moderation
"Some thing i noticed in your import debug log, you have set Lines per import: No in your import template settings on Limit tab. This is the number of lines you import in one cycle and which is 1000 by default. You should be setting a number instead of No in this field. Try setting this to 500 or to a lesser number and see if your import works."

I have configured this with a value of 500 and it has worked !!!
Now I can import the whole file with all the products in a very fast way.
Thank you very much for your help.
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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