- Status Closed
- Percent Complete
- 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
Opened by rolfcronberg - 2008-02-17
Last edited by pizza - 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.
2008-02-18 15:25
Reason for closing: Fixed
Additional comments about closing: r1916.
Loading...
Available keyboard shortcuts
- Alt + ⇧ Shift + l Login Dialog / Logout
- Alt + ⇧ Shift + a Add new task
- Alt + ⇧ Shift + m My searches
- Alt + ⇧ Shift + t focus taskid search
Tasklist
- o open selected task
- j move cursor down
- k move cursor up
Task Details
- n Next task
- p Previous task
- Alt + ⇧ Shift + e ↵ Enter Edit this task
- Alt + ⇧ Shift + w watch task
- Alt + ⇧ Shift + y Close Task
Task Editing
- Alt + ⇧ Shift + s save task
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.
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.
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)
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...