dem Wrote:
> To downgrade, do this:
>
> service slimserver stop
> rpm -Uhv --force perl-5.8.8-4.i386.rpm
> service slimserver start
>
Oops! I'd had a guess at what was needed already! Being too impatient
for my own good I just waded straight in with:
Code:
--------------------
service slimserver stop
rpm -Uvh perl-5.8.8-4.i386.rpm --oldpackage
service slimserver start
--------------------
This seemed to have done the trick.
The good news is that this made a very marked improvemnt in all web
related accesses. It also seems to have removed the random delays I
kept getting via the remote (though it is early days on this). Triode
had recently done some optimisation, and now with the additional
improvements from this Perl change, I'm well happy!
There is a downside to this. Unfortunately browsing albums on the
squeezebox (3) doesn't seem to work for me with this Perl version. When
I browse to a list of albums, I just get a blank screen, and then I need
to press the power button (after a short wait) to wake the squeezebox
again.
>From the log:
Code:
--------------------
2006-07-16 19:12:01.2857 DBD::mysql::st execute failed: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '(0xbeee68c), me.disc' at line 1 at
/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-07-16 19:12:01.2866 ERROR: Error executing 'SELECT me.id, me.titlesort,
me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc,
me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak,
me.musicbrainz_id, me.title FROM albums me LEFT JOIN contributor_album
contributorAlbums ON ( contributorAlbums.album = me.id ) WHERE (
contributorAlbums.role IN ( ?, ? ) ) GROUP BY me.id ORDER BY HASH(0xbeee68c),
me.disc' (`1', `5'): DBD::mysql::st execute failed: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near '(0xbeee68c), me.disc' at line 1 at
/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 525.
2006-07-16 19:12:01.2870 ERROR: Backtrace follows:
2006-07-16 19:12:01.2881 Backtrace:
frame 0: Slim::Schema::Storage::throw_exception
(/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 530)
frame 1: DBIx::Class::Storage::DBI::_execute
(/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 577)
frame 2: DBIx::Class::Storage::DBI::_select
(/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 118)
frame 3: DBIx::Class::Storage::DBI::Cursor::all
(/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 743)
frame 4: DBIx::Class::ResultSet::all
(/usr/local/slimserver/Slim/Buttons/BrowseDB.pm line 685)
frame 5: Slim::Buttons::BrowseDB::setMode
(/usr/local/slimserver/Slim/Buttons/Common.pm line 1092)
frame 6: (eval) (/usr/local/slimserver/Slim/Buttons/Common.pm line 1092)
frame 7: Slim::Buttons::Common::pushMode
(/usr/local/slimserver/Slim/Buttons/Common.pm line 1154)
frame 8: Slim::Buttons::Common::pushModeLeft
(/usr/local/slimserver/Slim/Buttons/Home.pm line 396)
frame 9: Slim::Buttons::Home::homeExitHandler
(/usr/local/slimserver/Slim/Buttons/Input/List.pm line 307)
frame 10: Slim::Buttons::Input::List::exitInput
(/usr/local/slimserver/Slim/Buttons/Input/List.pm line 65)
frame 11: Slim::Buttons::Input::List::__ANON__
(/usr/local/slimserver/Slim/Hardware/IR.pm line 737)
frame 12: Slim::Hardware::IR::executeButton
(/usr/local/slimserver/Slim/Control/Commands.pm line 141)
frame 13: Slim::Control::Commands::buttonCommand
(/usr/local/slimserver/Slim/Control/Request.pm line 1405)
frame 14: (eval) (/usr/local/slimserver/Slim/Control/Request.pm line 1405)
frame 15: Slim::Control::Request::execute
(/usr/local/slimserver/Slim/Control/Request.pm line 731)
frame 16: Slim::Control::Request::executeRequest
(/usr/local/slimserver/Slim/Player/Client.pm line 1012)
frame 17: Slim::Player::Client::execute
(/usr/local/slimserver/Slim/Hardware/IR.pm line 750)
frame 18: Slim::Hardware::IR::processCode
(/usr/local/slimserver/Slim/Hardware/IR.pm line 574)
frame 19: Slim::Hardware::IR::processIR
(/usr/local/slimserver/Slim/Control/Commands.pm line 257)
frame 20: Slim::Control::Commands::irCommand
(/usr/local/slimserver/Slim/Control/Request.pm line 1405)
frame 21: (eval) (/usr/local/slimserver/Slim/Control/Request.pm line 1405)
frame 22: Slim::Control::Request::execute
(/usr/local/slimserver/Slim/Control/Request.pm line 731)
frame 23: Slim::Control::Request::executeRequest
(/usr/local/slimserver/Slim/Player/Client.pm line 1012)
frame 24: Slim::Player::Client::execute
(/usr/local/slimserver/Slim/Hardware/IR.pm line 110)
frame 25: Slim::Hardware::IR::idle (/usr/local/slimserver/slimserver.pl line
473)
frame 26: main::idle (/usr/local/slimserver/slimserver.pl line 452)
frame 27: main::main (/usr/local/slimserver/slimserver.pl line 1048)
2006-07-16 19:12:01.2890 DBD::mysql::st fetchall_arrayref failed: fetch()
without execute() at
/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 119.
2006-07-16 19:12:01.2899 Couldn't push into new mode: [browsedb] !:
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at
/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 119.
--------------------
I did an upgrade install of the latest SS build, just in case it fixed
it but no joy.
I'm running the very latest (8456) 6.5b1 build. I guess the problem is,
we can't really expect the developers to support SS on older Perl
libraries, and I don't have sufficient knowledge to fix this myself.
Have I done something stupid in the way I downgraded Perl?
This is such a dramatic improvement, it'd be a real shame to have to go
back to 5.8.8-5.....
Cheers,
Richard
--
SadGamerGeek
------------------------------------------------------------------------
SadGamerGeek's Profile: http://forums.slimdevices.com/member.php?userid=6145
View this thread: http://forums.slimdevices.com/showthread.php?t=25559
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
