Photo Organizer

What's your max upload filesize and max POST size? On the photo upload page, it lists the max size ("Maximum upload file size: 300M")

ALso, your web server may be configured to limit the max size too.

I routinely upload a couple hundred megs at once; and indeed many of my individual images are over 10M.

My max upload size is 400 M

I get the same result on your demosite for the stable version. It seem to be related to the database transaction.

Importing 'DSC_1803.NEF' (Nikon Raw Format) into folder test.

* Extracting Image Metadata (EXIF) ... done
* Extracting Image Metadata (XMP) ... done
* Extracting Image Metadata (IPTC) ... done
* ERROR: current transaction is aborted, commands ignored until end of transaction block
* Failed to update database.
*

insert into photo
(identifier, users, folder, location,
caption, date_of_exposure, access_rights, copyright_statement,
views, hide_original, author, title,
caption_writer, category, credit, source,
headline, instructions, transmission_reference,
supplemental_category, web_statement, store_url, comments)
values (872, '417', '859', 0,
'', '2007-12-23 15:59:29', '1', 'Copyright (c) 2008 Rolf Cronberg',
0, 't', 'Rolf Cronberg', 'ERIK CRONBERG',
'', '', '', '',
'', '', '',
'', '', '', '')

* Cleaning up the mess.

All images imported.

With best regards
Rolf Cronberg

Odd. I imported a NEF this morning. Granted, it was only 9.4M.

Can you attach the file you're using, so I can watch the logs when I upload it?

The problem isn't the size of the file.

The ISO value in the file is 'Hi 3200' -- since we treat it as a numeric value, the DB chokes.

The attached patch (commtted in r1913) will solve the import failing, but the ISO isn't properly imported yet.

   exif_iso_fix.diff (0.4 KiB)

Ok, So what are the solution,

I can change the ISO value manually, but what would you say about the future. Maybe it shouldn't be a numeric value In this case it come from a Nikon D80.

   DSC_1803.NEF (11.7 MiB)

I've tried the patch but it doesn't solve the problem

Errormessage changed to

2008-02-17 18:25:12 CET ERROR: invalid input syntax for integer: "Hi 3200"
2008-02-17 18:25:12 CET STATEMENT:
select identifier
from film_iso
where value = 'Hi 3200'

I'm working on something else right now, but when that's done I'll fix this bug properly. In the mean time, can you attach the image that breaks, so I can test it out on my end?

Try the attached patch. (on top of the first)

   exif_iso_fix2.diff (0.6 KiB)

It seems to work alright now. Thank you for you effort.

Would you be interested in a translation to Swedish?

Cool, I'll commit the patch and close the ticket as soon as that's done.

And yes, I'd love a Swedish translation. The more the merrier...