ok, that sounds alright.
the error DB_ENUM means that firefly cant access the DB. its just a test to fetch a single line of data, which fails.
So maybe this is related to sqlite2 or sqlite3 problems.
You didnt by any chance install sqlite3 or sqlite ?
can you try and do a
sqlite /Users/john/Library/Application Support/Firefly/songs.db