svn-1489: Error: near "create": syntax error

[Digital Larry]

Briefly –

Running on Kurobox HG. OS is so-called “Sylver” which some guy made starting with Debian, but it’s lost its pedigree somewhere along the way.

Built svn-1489 and installed in place on top of a much older mt-daapd version from 2005 (which was included with the Kurobox Sylver image I installed). So I suspect that at least part of my problem is that the new version is trying to eat crumbs left over from the old one and not liking them too much.

Initially, config file was not found, the default location moved, but I copied the existing (old) config file to the new location. Then at least it doesn’t complain about that when I do the startup.

the build configuration was only to enable sqlite support, as I don’t use OGG Vorbis and trying Flac threw some errors about the header files missing.

The main clue I have about what is going on is from the mt-daapd log file:

2007-01-22 08:08:03 (00000400): Firefly Version svn-1489: Starting with debuglevel 2
2007-01-22 08:08:03 (00000400): Starting rendezvous daemon
2007-01-22 08:08:03 (00000400): Starting signal handler
2007-01-22 08:08:03 (00000400): Old database version: 6, expecting 13
2007-01-22 08:08:03 (00000400): Upgrading db: 6 –> 7
2007-01-22 08:08:03 (00000400): Upgrading db: 7 –> 8
2007-01-22 08:08:03 (00000400): Query: create index idx_songid on playlistitems(songid)
create index idx_playlistid on playlistitems(playlistid)
update config set value=8 where term=’version’;

2007-01-22 08:08:03 (00000400): Error: near “create”: syntax error
2007-01-22 08:08:03 (00000400): Error upgrading db: Misc SQL Error: near “create”: syntax error
2007-01-22 08:08:03 (00000400): Error opening db: Misc SQL Error: near “create”: syntax error

OK so it’s expecting database version 13, does a convert from 6 to 7 and 7 to 8, but after that, bad news? Can I just blow away the songs.db and have it recreated?

Thx!

[rpedde]

@Digital Larry wrote:

OK so it’s expecting database version 13, does a convert from 6 to 7 and 7 to 8, but after that, bad news? Can I just blow away the songs.db and have it recreated?

Yes. Meanwhile, I’ll take a look at that upgrade script.

— Ron

[Author]

Posts