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

FireFly Media Server Firefly Media Server Forums Firefly Media Server Setup Issues svn-1489: Error: near "create": syntax error

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1027
    Digital Larry
    Participant

    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!

    #8660
    rpedde
    Participant

    @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

Viewing 2 posts - 1 through 2 (of 2 total)
  • The forum ‘Setup Issues’ is closed to new topics and replies.