Photo Organizer

  • Status Closed
  • Percent Complete
    100%
  • Task Type Bug Report
  • Category Backend / Core → Import
  • Assigned To No-one
  • Operating System All
  • Severity Critical
  • Priority Very Low
  • Reported Version 2.35
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Photo Organizer
Opened by Rolf Cronberg - 2008-02-17
Last edited by Solomon Peachy - 2008-02-18

FS#330 - Import of big images fail.

I try to import an image larger than 10 Mb. The result is the same for all images larger than 10 Mb

The image is not imported and the result is as follows.

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

* 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 (748, '2', '12', 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.

Closed by  Solomon Peachy
2008-02-18 15:25
Reason for closing:  Fixed
Additional comments about closing:  r1916.
Admin
Solomon Peachy commented on 2008-02-17 12:50

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.

Rolf Cronberg commented on 2008-02-17 16:40

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

Admin
Solomon Peachy commented on 2008-02-17 16:54

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?

Admin
Solomon Peachy commented on 2008-02-17 17:00

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.

Admin
Solomon Peachy commented on 2008-02-17 17:03

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

Rolf Cronberg commented on 2008-02-17 17:12

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.

Rolf Cronberg commented on 2008-02-17 17:32

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'

Admin
Solomon Peachy commented on 2008-02-17 17:33

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?

Admin
Solomon Peachy commented on 2008-02-17 18:22

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

Rolf Cronberg commented on 2008-02-17 20:15

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

Would you be interested in a translation to Swedish?

Admin
Solomon Peachy commented on 2008-02-18 00:41

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...

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing