I've now tried the following versions of Squeezecenter and get the same mysql crash whenever trying to play music or add to a playlist:
7.3.3 7.3.4-28402 7.4.2-29203 7.5.0-29225 The scan completes on all versions. The queries seem to be the problem - not DBD::mysql - the same query crashes when run directly against the database (this is against the tables 7.3.4 created): [root @ oxygen][~]: mysql -u squeezecenter -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.30-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use squeezecenter; Database changed mysql> SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak, me.extid FROM tracks me JOIN albums album ON ( album.id = me.album ) LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) JOIN contributors contributor ON ( contributor.id = contributorTracks.contributor ) WHERE ( audio = '1' AND contributor.id = '1' AND remote = '0' ) GROUP BY me.id ORDER BY concat(album.titlesort, '0'), me.disc, me.tracknum, concat(me.titlesort, '0'); ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> -- cudgel ------------------------------------------------------------------------ cudgel's Profile: http://forums.slimdevices.com/member.php?userid=34218 View this thread: http://forums.slimdevices.com/showthread.php?t=71222 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/unix
