jensb / iphoto2xmp

Export an Apple iPhoto image library to a new directory (using hardlinks) with all metadata saved in XMP sidecar files.
GNU General Public License v3.0
34 stars 9 forks source link

postmortem sql issue with group_modified.sql #6

Closed erkcan closed 8 years ago

erkcan commented 8 years ago

Here is one minor issue (hopefully last). I ran the following postmortem command: sqlite3 ~/Pictures/digikam4.db < group_modified.sql and I get the following error: Error: near line 1: too many terms in compound SELECT

I see that group_modified.sql is quite long; there are close to 5000 lines in it. I guess the problem might be related to the issue with sqlite inserting too many records with a single command. https://stackoverflow.com/questions/10083719/sqlite-issue-when-inserting-large-number-of-records

Would it be possible to break that command into shorter commands?

erkcan commented 8 years ago

Thanks, it works now.