Categories
View Replies (5)

Resolved Error 504 Gateway Time-out Issue

  1. beyond18
    beyond18
  2. RO CSVI
  3. Wednesday, 01 November 2017
  4.  Subscribe via email
I tried to import a large file of 8mb and I got the error 504.

Then I tried to contact my server admin to increase the max_execution_time like what you suggested in another post.
https://csvimproved.com/forum?view=topic&catid=44&id=33808

My server admin set the following in php.ini:
memory_limit = 768M
max_execution_time = 120

But after that I still get the same error. How can I resolve this?
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Have a look at Manage time out document to know on how to solve import time out issue.
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
beyond18
beyond18
Accepted Answer Pending Moderation
Hi,

I have followed the "Manage Time Out" document and adjusted "Lines per import" to 200.

However, the problem still exist when I hit 800 lines. I suspect there's some large chunks of data at around 800 lines there. But I am not sure.

So I tried to split the file into several smaller files with csv splitter software. However, the csv file becomes messy and I still face the same problem.

Can I send you the file and see whether it is file problem?

Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
How about you set lines per import to 50? Does it stop at line 800 then? If you still see that issue then post the 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. # 3
beyond18
beyond18
Accepted Answer Pending Moderation
seems to work after I adjusted to 50.

Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Glad to know that it worked with 50 lines per import. The concept behind this is that every time the number of lines per import is reached the script restarts and the memory used is released for the new import cycle which makes server not hit its limit.

We would appreciate if you can give us a review on Joomla Extension Directory :)
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
  • Page :
  • 1


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