Error 502

[tomi]

Hello, I use:
Wordpress: Version 4.5.3
Event calender pro 4.2.3

if I want to upload data via csv file (file size 606 kb) is always comes 504 Gateway Time-out
while I’ve screwed up the time on the server 560 sec.
and max_input_vars = 100000

what can still be?

[Cliff]

Hi. Thanks for your detailed question. Sorry you’re experiencing this.

Your CSV file has 6,317 lines/rows. If it were to fully complete, you’d be creating 6,317 new posts in the database (a lot at once for any site to handle). I’d suggest splitting that into multiple files and seeing if this works for you.

https://gist.github.com/barryhughes/f7cce65e5aa0c5a50a64

You might also want to increase your site’s memory limit.

(FYI: I used Excel to detected you have 90 duplicate lines.)

Please let me know how things go for you.

[tomi]

How many lines can it about process ?

[Cliff]

That will depend on your host/server. I’d try with 1,000 and if that doesn’t work, try with 500, then 250, then 100, etc.

If you’re just doing an initial import (i.e. not importing 6,000 items every week), it should just be a little extra time up front to get things up and running.

[tomi]

if it can process less than 1,000 lines, it is absolutely out of question for me

[Cliff]

It, meaning our code, isn’t limited.

It, meaning your server and/or WordPress settings and resources, is limited (there’s no such thing as a server with “unlimited” resources).

You’ll need to do trial and error to figure out your site’s limitations. It could be that you have resource-intensive plugins (e.g. BuddyPress) or a lot of traffic at the time you try to do your import that causes it to fail.

I can offer our generally-recommended troubleshooting steps:

Could you please make sure all your Modern Tribe plugins (and WordPress core) are at their latest versions?

• Downloads / Version Numbers
• TEC Automatic Updates
• or TEC Manual Updates
• WordPress core updates

Once you verify you’re on the latest versions, please test to see if the issue is still happening for you.

If it is, please follow our Testing for Conflicts Guide (basically switch to TwentySixteen theme and deactivate all plugins and custom code other than Modern Tribe plugins) and see if that helps narrow down the cause of this.

If it doesn’t, please enable WP_DEBUG and WP_DEBUG_LOG and share any PHP errors you see while changing tickets quantity, navigating your site’s home page, events page, single-event pages, and any other of your site’s pages relevant to this ticket.

Then, please share your System Information (while in Testing for Conflicts mode).

You might also see if you can spot any console errors at your site. (If needed, you may reference our KB article Using Google Chrome Developer Tools.)

Let us know what you find out.

Thanks.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts