DroneDB no such column and entries not found

Compiled and attempting to use DroneDB with mixed success:

[email protected]:/path/code# ~/ddb/build/./ddb init
no such column: TRUE
[email protected]:/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::[email protected]] Checking if .ddb directory exists...
2019-10-29 19:04:03.054 DEBUG [31383] [ddb::[email protected]] .ddb created
2019-10-29 19:04:03.054 DEBUG [31383] [ddb::[email protected]] Checking if dbase exists...
2019-10-29 19:04:03.054 DEBUG [31383] [ddb::[email protected]] Creating .ddb/dbase.sqlite
2019-10-29 19:04:03.054 DEBUG [31383] [Database::[email protected]] Opening connection to .ddb/dbase.sqlite
2019-10-29 19:04:03.054 DEBUG [31383] [Database::[email protected]] About to create tables...
2019-10-29 19:04:03.055 DEBUG [31383] [Database::[email protected]] Closing connection to .ddb/dbase.sqlite
2019-10-29 19:04:03.055 VERB  [31383] [ddb::[email protected]] 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] [[email protected]] DDB v0.9.0
2019-10-29 15:14:22.841 VERB  [11018] [[email protected]] SQLite version: 3.29.0
2019-10-29 15:14:22.841 VERB  [11018] [[email protected]] 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] [[email protected]] DDB v0.9.0
2019-10-29 20:30:45.182 VERB  [5710] [[email protected]] SQLite version: 3.22.0
2019-10-29 20:30:45.182 VERB  [5710] [[email protected]] SpatiaLite version: 4.3.0a
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::[email protected]] Checking if .ddb directory exists...
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::[email protected]] .ddb created
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::[email protected]] Checking if dbase exists...
2019-10-29 20:30:45.182 DEBUG [5710] [ddb::[email protected]] Creating .ddb/dbase.sqlite
2019-10-29 20:30:45.182 DEBUG [5710] [Database::[email protected]] Opening connection to .ddb/dbase.sqlite
2019-10-29 20:30:45.187 DEBUG [5710] [Database::[email protected]] About to create tables...
2019-10-29 20:30:45.372 DEBUG [5710] [Database::[email protected]] Created tables
2019-10-29 20:30:45.372 DEBUG [5710] [Database::[email protected]] 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