Problem with Upload to database

[landryssa]

Okay, this is my first post here, and I've done a thourough search of the forum to see if anyone else has had the same problem, but I can't seem to find it. Some people have things that seem similar but the solutions don't help me.

This is what I do when I want to upload a photo to a exhibition.

- if necessary, I make the exhibition
- if necessary, I set up new paths (each exhibition has a different default path so it has it's own folder) I know this gives me a lot of paths, but I like having things in their own folder, much less hassle
- Each photo has 3 sizes, normal made by imagemagick with a watermark, thumb and microthumb, the later to made by GD 110 (the preset)
- I upload the photo to the upload folder using CuteFTP
- I go to Upload to the Database, and select the foto in the list, choose the path, choose the exhibition, select the nessecary options and hit upload

then nothing happens, and I mean totally nothing. Not a black screen, not a page refresh, just an waiting arrow for a while (with waiting for server in the status bar) and then that changes to 'Done' and the arrow is normal.

When I look at the messages about a 15 minutes later this is what it says:

msg 17215 | ftp: Automatic database maintenance:
table: saaf_gallery.ee_order_to_exhibition | operation: repair | status: OK
table: saaf_gallery.ee_photo | operation: repair | status: OK
table: saaf_gallery.ee_photo_eng | operation: repair | status: OK
table: saaf_gallery.ee_photo_to_category | operation: repair | status: OK
table: saaf_gallery.ee_photo_to_ee_commerce_template | operation: repair | status: OK
table: saaf_gallery.ee_photo_to_exhibition | operation: repair | status: OK
msg 17214 | ftp: UPLOAD FINISHED SUCCESFULLY.
msg 17213 | database action: Photo id 631 added to database.
msg 17212 | ftp: LOCAL: DISCONNECTED
msg 17211 | ftp: LOCAL:
'Eyfi_01.jpg' UPLOADED SUCCESFULLY
SIZE: 600x450 => 43x32 microthumb (GD 43) , 1 KB in server.
msg 17210 | ftp: LOCAL: Working directory changed to '/www/landryssa/gallery/photos/CATS/eyfi/microthumb'
msg 17209 | ftp: LOCAL: Changed to passive mode
msg 17208 | ftp: LOCAL: Logged in as 'saaf'
msg 17207 | ftp: LOCAL: Connected to '127.0.0.1'
msg 17206 | ftp: LOCAL: DISCONNECTED
msg 17205 | ftp: LOCAL:
'Eyfi_01.jpg' UPLOADED SUCCESFULLY
SIZE: 600x450 => 110x82 thumb (GD 110) , 2 KB in server.
msg 17204 | ftp: LOCAL: Working directory changed to '/www/landryssa/gallery/photos/CATS/eyfi/thumb'
msg 17203 | ftp: LOCAL: Changed to passive mode
msg 17202 | ftp: LOCAL: Logged in as 'saaf'
msg 17201 | ftp: LOCAL: Connected to '127.0.0.1'
msg 17200 | ftp: LOCAL: DISCONNECTED
msg 17199 | ftp: Eyfi_01.jpg: UPLOAD ERROR. Reason: ftp_put(): Opening BINARY mode data connection for /www/landryssa/gallery/photos/CATS/eyfi/Eyfi_01.jpg
msg 17198 | imagemagick: IMAGEMAGICK COMMAND (watermark) | composite -gravity SouthEast watermarks/sandra.png UPLOAD/ee_temp_upload/Eyfi_01.jpg UPLOAD/ee_temp_upload/Eyfi_01.jpg | EXECUTED OK
msg 17197 | imagemagick: IMAGEMAGICK COMMAND (resize+sharpen) | convert -size 600x450 UPLOAD/Eyfi_01.jpg -resize 600x450! +profile '*' -quality 99 UPLOAD/ee_temp_upload/Eyfi_01.jpg | EXECUTED OK
msg 17196 | ftp: LOCAL: Working directory changed to '/www/landryssa/gallery/photos/CATS/eyfi'
msg 17195 | ftp: LOCAL: Changed to passive mode
msg 17194 | ftp: LOCAL: Logged in as 'saaf'
msg 17193 | ftp: LOCAL: Connected to '127.0.0.1'

When I look in the folder of the normal image I see an image, with the right name of 23.99kb and if I open it, it's only a small part of the image.

The thumb and microthumb appear to be fine, as is the insert into the database.

I've tried it without imagemagick, but it gives the same problem.

Also when I look on CPanel, in the ftp sessions control, there is a session that is hanging on STOR /www/landryssa/gallery/photos/CATS/eyfi/Eyfi_01.jpg

I've had this problem before, and it solves itself, only to appear, and dissapear, and appear again. The only thing I am doing is waiting an hour or two before trying again. Sometimes that works and everything is uploaded smoothly, and sometimes every hangs again.

Can anyone help me with it?

[Pekka]

Could be simply ftp server connection lost. Looks like you are using PHP ftp module. Can you switch to "Internal FTP" in FTP server editor and try again?

Also, get the fix from http://photography-on-the.net/forum/showthread.php?t=30778

Before you hit the upload button:
- clean ftp messages.
- start message autorefresh so that you see what it going on.

There is not much I can do with PHP ftp module, but with internal FTP (my own functions) I can do lots of things (there are internal ftp function bugfixes and improvements in next EE).

[landryssa]

Thanks for the response.
I did find the ftp fix, so I could upload manually.
And after some searching on the net, I also found a free watermarking program that does what I want it to do. So I was almost finished with my batch of 100 foto's when you replied.

I liked the imagemagick, but this program is even better.
not sure if i will be needing the ftp to work, but next time I'm uploading again, I'll give the internalFTP a try, and I'll let you know.

And since thumbnail making works fine, I just upload the pictures manually, and use the retumbnailer to make the thumbs.. So what that the thumb have a very small watermark..