PDA

View Full Version : UPLOAD to database problem, please help


geantbrun
29th of May 2007 (Tue), 22:48
Hi all,
I upgraded to EE2 from 1.5RC4. Everything seemed fine. I have no problems adding photos to my old 1.5 exhibition ("1. My First Exhibition"). But when I create a new exhibition ("2. New exhibition") and do an upload, here is the message EE2 sends:

There are 1 images left todo in previous batch. All settings on the forms below match this batch. Click here to continue it. (http://photography-on-the.net/forum/EDITOR_perform_upload.php)
If you do now a new upload the last batch info will be erased.

I don't understand why it's impossible to upload photos to a new exhibition (I tried with another one). What am I missing? I followed all the instructions at http://photography-on-the.net/forum/showthread.php?t=223149

Any hint is greatly appreciated
Patrick, junior member!

wkitty42
30th of May 2007 (Wed), 09:48
you're not missing anything, geantbrun... i get this all the time and it depends on how many photos i'm uploading at once as to how many it tells me there are left...

why doesn't the batch complete? well, what happens in my case is that one of several timeouts kicks in and that stops the processing... right off the top of my head, i can think of the timeouts to the database and the one for how long a script can run... my server isn't the fastest thing and it does get a load on it at times and all this contributes to the speed of the processing...

i also learned that additional processing, like letting the system add a watermark, adds a lot more time to the task... when i was letting the system do the watermarking, it actually doubled the processing time for each photo being uploaded (added... that really needs to be changed) to the database...

jeronimo
31st of May 2007 (Thu), 07:25
You both sould add a .htacces file in the root of your server containing

php_value max_execution_time 360
php_value upload_max_filesize 8M

The first one is the time php my take to do a process. The longer the more safe, however, you can make your site "hang".
The second one is about the size you can upload in one time by use of php.

You can check those values in the admin panel under install check

wkitty42
1st of June 2007 (Fri), 13:32
i'm way way way ahead of you in that regard, jeronimo... and with much larger numbers but i'd like to do that only in the admin folder and keep the root one with more normal numbers... i've just not taken the time to copy the .htaccess to my admin folder and test it... it should work just fine, though...

geantbrun
1st of June 2007 (Fri), 14:41
Thank you guys!
Pat

iam408
18th of June 2007 (Mon), 14:07
You both sould add a .htacces file in the root of your server containing

php_value max_execution_time 360
php_value upload_max_filesize 8M

The first one is the time php my take to do a process. The longer the more safe, however, you can make your site "hang".
The second one is about the size you can upload in one time by use of php.

You can check those values in the admin panel under install check

Hi Jeronimo,
I had both value set to increase but seems like the uploading are never finish (even with one image at a time)

php_value max_execution_time 600 (per Pekka suggestion)
php_value upload_max_filesize 20M

My installcheck are cleaned. (no errors)

The file size i try to upload is usually 5mb each, i upload the file via FTP to the UPLOAD folder and then use EE interface to upload to the database.

FTP is definedtely the better way to update the files in batch instead of using "STEP 3 : send photos to upload folder " which is vey tedious and time consuming if you want to upload 10-20 photos at a time.

I had watermark and resharp set to OFF, Here's my resize path:

/htdocs/gallery/path/normal (resize to 50% of the original upload size)
/htdocs/gallery/path/thumb
/htdocs/gallery/path/microthumb

Any experience this? Suggestion are greatly appriciated!

Thanks
Kevin

wkitty42
19th of June 2007 (Tue), 00:15
php_value max_execution_time 600 (per Pekka suggestion)
if this is in the .htaccess in your admin directory, add another zero to the above, just for grins, and see if it works out... i've had to raise my settings quite a bit due to the load on my server... again, i created a .htaccess in my admin folder so it would not affect the normal stuff and possibly cause problems later on...