Hi All,

I'm using openSUSE 11.4 (x86_64) and wanted to use latest darktable from git repository.
I finally managed the build, but a modification to the officially distributed sqlite3-devel was necessary.
I would like to share the information about this issue for others and for the SUSE build team.

That's what I did.
I collected all prerequisites from SUSE repositories using yast2.

During darktable build I've got the message "unresolved symbol sqlite3_table_column_metadata"

Google delivered a link to old MacRumors Forum from 2008 saying:
sqlit3.h says
** This API is only available if the library was compiled with the
** SQLITE_ENABLE_COLUMN_METADATA preprocessor symbol defined.*/
(That seems still to be true.)

Making sure to have the latest sqlite3-devel package installed on my opsneSUSE 11.4 did not solve the issue.

So I downloaded sqlite3 source. Building it from scratch I used following configure command:
./configure --prefix /opt/sqlite3 CPPFLAGS=-DSQLITE_ENABLE_COLUMN_METADATA
(Without uninstalling the sqlite3-devel package I just replaced the sqlite... files in /usr/include and /usr/lib64 by the new files in /opt/sqlite3 .)

After that the build process for darktable went through flawlessly.

Wouldn't it be helpful to have a fully featured sqlite3 in the SUSE repositories???

Hope this helps someone to save time