PDA

View Full Version : UPLOAD TO DATABASE


chriz
7th of October 2003 (Tue), 09:50
I'm still having problems when trying to upload a lot of pictures.

When selecting 100 pictures for upload:
1. the browser times out
when refreshing
2. upload process aborted
when checking photo album
3. no photos visible

IT DOES WORK WHEN I SELECT A BATCH OF ABOUT 20 TO 30 PICTURES AT A TIME.

As i often have to upload hundreds of photographs I really would like to see a solution to this problem ?

chriz

Pekka
7th of October 2003 (Tue), 10:18
What is your "maxtime:" in EE editor top?

PHP will limit execution time to that amount (seconds) and there is no way out of it. You can change max_execution_time using htaccess in Apache or by contacting your sysadmin. Or if system admin is not a sport then you are stuck with 30 or 60 seconds.

If browser times out: that is weird because there is a system in EE to prevent that - a system that works very well also in EE Backup. What browser you were using?

If PHP times out no photos are written to database, because that is done after successfull upload only.

I have a very good method of working round these time problems and it is seen in EE Backup's slow restore function. It is virtually foolproof and requires no Javascript or fancy tricks. I will see that this will be integrated into EE upload.

Meanwhile, upload only smaller amounts at a time.

chriz
7th of October 2003 (Tue), 10:55
maxtime in EE editor top is 30

browser is IE version 6.0 under windows XP

I'll upload smaller amounts for the time being, thanks.

Pekka
7th of October 2003 (Tue), 11:40
chriz wrote:
maxtime in EE editor top is 30

browser is IE version 6.0 under windows XP

I'll upload smaller amounts for the time being, thanks.



Try also adding a file .htaccess to gallery root, with content:

php_value max_execution_time 360

chriz
7th of October 2003 (Tue), 11:46
htaccess is already in root (installed by default I guess)

Chriz

Pekka
7th of October 2003 (Tue), 12:20
chriz wrote:
htaccess is already in root (installed by default I guess)

Chriz

Can you add

php_value max_execution_time 360

to it?

chriz
7th of October 2003 (Tue), 12:24
Sorry... what I meant was:
htaccess is in root
and it has already: php_value max_execution_time 360

Isn't that installed by default then, I did not put that file in, at least not consciously.

Chriz

chriz
7th of October 2003 (Tue), 14:51
Just got a message from my sys admin at opensourcehost and they changed the setting max_execution_time to 300

Pekka
7th of October 2003 (Tue), 15:36
chriz wrote:
Sorry... what I meant was:
htaccess is in root
and it has already: php_value max_execution_time 360

Isn't that installed by default then, I did not put that file in, at least not consciously.

Chriz

No EE places there one 'htaccess', not '.htaccess' - there is a big difference between the two. You need to have '.htaccess' if you need it to give commands to Apache.

Pekka
7th of October 2003 (Tue), 15:37
chriz wrote:
Just got a message from my sys admin at opensourcehost and they changed the setting max_execution_time to 300

Nice!