FireFly Media Server (formerly mt-daapd) › Firefly Media Server Forums › Firefly Media Server › Nightlies Feedback › svn-1303 – thinks it is a new database on startup? › Reply To: svn-1303 – thinks it is a new database on startup?
hm I just peeked at db-sql.c in the trunk.
Looks like you handled that thing in
still looking weird to me though, being used to PL/SQL and plain C 😉
anyway, I suggest you put a NVL() around
select value from config where term='version'
so it would read:
select nvl(value, 0) from config where term='version'
where it would return 0 if the value is null, missing, ^NIL 😉
that would be a proper approach, from the DB side, at least.