PDA

View Full Version : Rev. 1983 (trunnk) fails when accessing web page



Robin Bowes
2005-02-09, 02:29
Dan,

I've just updated to rev. 1983 and find that slimserver dies when I open
the slimserver "home" page.

Message in the error log is:

2005-02-09 09:28:15.739965500 DBD::SQLite::db prepare_cached failed: no
such column: playcount(1) at dbdimp.c line 263 at
/usr/local/slimserver/CPAN/Ima/DBI.pm line 391.
2005-02-09 09:28:15.740074500 DBD::SQLite::db prepare_cached failed: no
such column: playcount(1) at dbdimp.c line 263 at
/usr/local/slimserver/CPAN/Ima/DBI.pm line 391.

Gotta go now but available tonight (GMT) to debug if necessary.

R.
--
http://robinbowes.com

kdf
2005-02-09, 02:32
Quoting Robin Bowes <robin-lists (AT) robinbowes (DOT) com>:

> Dan,
>
> I've just updated to rev. 1983 and find that slimserver dies when I open
> the slimserver "home" page.
>
> Message in the error log is:
>
> 2005-02-09 09:28:15.739965500 DBD::SQLite::db prepare_cached failed: no
> such column: playcount(1) at dbdimp.c line 263 at
> /usr/local/slimserver/CPAN/Ima/DBI.pm line 391.
> 2005-02-09 09:28:15.740074500 DBD::SQLite::db prepare_cached failed: no
> such column: playcount(1) at dbdimp.c line 263 at
> /usr/local/slimserver/CPAN/Ima/DBI.pm line 391.
>
> Gotta go now but available tonight (GMT) to debug if necessary.
>

erase your db file, and you should be ok. There isn't any facility to add new
table fields on startup.

-kdf

Dan Sully
2005-02-09, 02:34
* Robin Bowes shaped the electrons to say...

>I've just updated to rev. 1983 and find that slimserver dies when I open
>the slimserver "home" page.

I meant to send out a quick note about this - everyone will need to wipe
their DB and start over, I've added a few new columns.

-D
--
<nil> It sucks to discover that you are the foremost authority on some set of things when you've got a problem.

Dan Sully
2005-02-09, 02:35
* kdf shaped the electrons to say...

>erase your db file, and you should be ok. There isn't any facility to add new
>table fields on startup.

There is, I just didn't use it. :)

(See: SQL/SQLite/Upgrades/*)

-D
--
<nil> It sucks to discover that you are the foremost authority on some set of things when you've got a problem.