CSV Import doesn't trigger Success Event after 1 minute

Server Side Components General
#1

I have a rather simple CSV import set up with a query that checks if the record exists and then some inserts.
On the front-end there’s an on:success notification to see when the import finishes…
It all works great on small CSV files (few hundred rows) but using a larger one causes some problems…
If the operation takes more than 1 minute I get “405 Not Allowed”

image
image1262×444 4.97 KB

EVEN THOUGH the database is still processing it and adding records - albeit not all of them… Out of around 2k rows I get roughly 1700…
If I split the CSV into smaller ones it works as intended but I can’t expect all users to be doing that every time… I tried changing the script timeout setting in the server action but it doesn’t seem to be changing anything - it’s always exactly one minute till I get the error.

#2

If on php, maybe have a look at

max_execution_time
and
max_input_time

settings in your php.ini file?

1 Like
#3

This will probably sound very dumb but where am I supposed to find this file?

#4

If you unzip this file, copy it into your project folder root, and then open it in a browser, it will show you where the .ini is location.

phpinfo.php.zip (516 Bytes)

1 Like
#5

Got it, thx!
sadly it didn’t help… I also changed a bunch of other settings just to see if anything changed but it still goes for exactly 1 min…

max_execution_time = 999
max_input_time = 999
mssql.timeout = 180
mysql.connect_timeout = 180
default_socket_timeout = 180

#6

Depending on your server setup, you may need to restart the web server.

Also, take a look through the web server error logs to look for problems.