DroneDB no such column and entries not found

Compiled and attempting to use DroneDB with mixed success:

user@node1:/path/code# ~/ddb/build/./ddb init
no such column: TRUE
user@node1:/path/code# ~/ddb/build/./ddb add images/
Table 'entries' not found (not a valid database: /path/code/./.ddb/dbase.sqlite)

Any thoughts on what might have gone wrong?

Huh, this looks like a bug. What if you switch directory:

cd ~/ddb/build

And then ./ddb init ?

~/ddb/build# ./ddb init
no such column: TRUE

Mm, could you run the command with the verbose flag to get more info?

./ddb init --verbose

Also, is there a .ddb directory in the current directory? Does removing it resolve this?

I deleted the .ddb directory and then ran:

./ddb init --verbose
2019-10-29 19:04:03.053 DEBUG [31383] [ddb::create@29] Checking if .ddb directory exists...
2019-10-29 19:04:03.054 DEBUG [31383] [ddb::create@34] .ddb created
2019-10-29 19:04:03.054 DEBUG [31383] [ddb::create@40] Checking if dbase exists...
2019-10-29 19:04:03.054 DEBUG [31383] [ddb::create@44] Creating .ddb/dbase.sqlite
2019-10-29 19:04:03.054 DEBUG [31383] [Database::open@32] Opening connection to .ddb/dbase.sqlite
2019-10-29 19:04:03.054 DEBUG [31383] [Database::createTables@90] About to create tables...
2019-10-29 19:04:03.055 DEBUG [31383] [Database::close@50] Closing connection to .ddb/dbase.sqlite
2019-10-29 19:04:03.055 VERB  [31383] [ddb::create@55] Exception caught, cleaning up...
no such column: TRUE

I wonder if it’s related to the version of sqlite3; for reference here’s what I’m using:

2019-10-29 15:14:22.841 VERB  [11018] [main@53] DDB v0.9.0
2019-10-29 15:14:22.841 VERB  [11018] [main@54] SQLite version: 3.29.0
2019-10-29 15:14:22.841 VERB  [11018] [main@55] SpatiaLite version: 4.3.0a

I’ve replaced the “TRUE” constant with “1”, which might work with older versions. Update/rebuild/retry? https://github.com/uav4geo/DroneDB/commit/3bf5b3c837db36b3ba512b1e8965f494d8733834

That’s a little better!

./ddb init --verbose
2019-10-29 20:30:45.182 VERB  [5710] [main@53] DDB v0.9.0
2019-10-29 20:30:45.182 VERB  [5710] [main@54] SQLite version: 3.22.0
2019-10-29 20:30:45.182 VERB  [5710] [main@55] SpatiaLite version: 4.3.0a
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::create@29] Checking if .ddb directory exists...
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::create@34] .ddb created
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::create@40] Checking if dbase exists...
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::create@44] Creating .ddb/dbase.sqlite
2019-10-29 20:30:45.182 DEBUG [5710] [Database::open@32] Opening connection to .ddb/dbase.sqlite
2019-10-29 20:30:45.187 DEBUG [5710] [Database::createTables@90] About to create tables...
2019-10-29 20:30:45.372 DEBUG [5710] [Database::createTables@92] Created tables
2019-10-29 20:30:45.372 DEBUG [5710] [Database::close@50] Closing connection to .ddb/dbase.sqlite
Initialized empty database in .ddb

Oooh, new error:

~/ddb/build/./ddb add images/
terminate called after throwing an instance of 'Exiv2::BasicError<char>'
  what():  No namespace info available for XMP prefix `drone-dji'
Aborted (core dumped)

Progress :clap:

If you send me a link (even privately) to a few of the images (5-10, not the entire dataset) I can try to troubleshoot this further.

Haven’t done much testing outside of datasets captured with DJI equipment.

1 Like

You have the link. It’s on the server you are oh so familiar with. :slight_smile:

1 Like