Categories
View Replies (6)

Resolved status error: 504 Status message: Gateway Timeout

  1. studio_ericpaap
    studio_ericpaap
  2. RO CSVI
  3. Wednesday, 16 November 2022
  4.  Subscribe via email
Hi
I have a problem with uploading/import a .csv file with a special import file template (Hikashop file import) of 5.8 Mb to my webshop. It will by about 10.000 productcodes. I have put the rules of import very low: 100. The Time between imports also very low: 5. But still a get the error during the import. Sometimes at 8.500 products but sometimes already at 2.500 products.

So the server says: I will stop now and is not responding anymore? Why this error?
status error: 504
Status message: Gateway Timeout
504 Gateway Time-out
The server didn't respond in time.
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The image icon is already uploaded in Upload and I use only a .csv file with product_code and file_path in a import template.

If the image has been uploaded and with import it is linked to a product then it should be faster compared to downloading an image from remote location.

Now I have simply cut the .csv file in more parts. I hope that will work better.

Yes this is a better option when cron job is not supported.

I have put the rules of import very low: 50. It takes now a long time to finish all the products. I must be patient....

50 is a less number if the import records are huge. As long as import finishes without timeout error everything should be good.
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
studio_ericpaap
studio_ericpaap
Accepted Answer Pending Moderation
Hoi
thnks. I use already a two step import. First the basic info. The image icon is already uploaded in Upload and I use only a .csv file with product_code and file_path in a import template. Now I have simply cut the .csv file in more parts. I hope that will work better. I have put the rules of import very low: 50. It takes now a long time to finish all the products. I must be patient....
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eric,

A webhost without a cron option :o I am amazed they are still around. I understand why they tell you to use a VPS, simply due to the amount of products. This may only be an issue when running the actual import and not the actual shop. You will have to see how that performs.

As for the import, I am not sure what you are importing but if you are also importing images and doing image tasks, it might be better to do a 2-step import, first the basic product information and a second run to add the images. This way the first import will be mucht faster and you do not have to wait so long to have the product information in.

In reality, you want to import this using a cron command or via the CLI. A service like crontab generator is not going to help you because they access your site just like a regular visitor, so you are still limited to the web limits of the host.
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
studio_ericpaap
studio_ericpaap
Accepted Answer Pending Moderation
Can I use https://crontab-generator.org/ to generate a cronjob with your instructions without the provider? Using /administrator/components/com_csvi/helper/cron.php?
  1. more than a month ago
  2. RO CSVI
  3. # 4
studio_ericpaap
studio_ericpaap
Accepted Answer Pending Moderation
Thnks. I have now put the rules of import on 50. And is still going on. I am now at 12.000 files. .....

But my client has the site Linux hosted at Leaseweb and in Plesk I cannot find any advanced buttons to run a cronjob. I have ask the helpdesk of LW but they are only suggestion to change to a VPS server. Time to leave Leasweb I think.
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
So the server says: I will stop now and is not responding anymore? Why this error?
status error: 504
Status message: Gateway Timeout
504 Gateway Time-out
The server didn't respond in time.

This error occurs when server hits limits. In your case server hits its limits sometimes at 8.500 products and sometimes at 2.500 products based on what data is imported. To solve this run the import as cron job. There are no server limits with cron job so you should not be seeing timeout errors. Try and let me know on how it goes.
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. # 6
  • Page :
  • 1


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