PDA

View Full Version : crash navigating to "Various Artists"



BKDotCom
2006-11-01, 18:46
Via Event Viewer:

Carp::Clan::__ANON__(): Error executing 'SELECT COUNT( DISTINCT( album.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( me.role = ? ) ) )': DBD::mysql::st execute failed: Unknown column 'me.role' in 'where clause' at C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

kdf
2006-11-01, 18:56
and the server version would be....?

please be kind, there are many versions in common use, including any
number of nightly builds.
-kdf

Ben Sandee
2006-11-01, 18:57
On 11/1/06, BKDotCom <BKDotCom.2gmgtb1162432201 (AT) no-mx (DOT) forums.slimdevices.com>
wrote:
>
>
> Via Event Viewer:
>
> Carp::Clan::__ANON__(): Error executing 'SELECT COUNT( DISTINCT(
> album.id ) ) FROM contributors me LEFT JOIN contributor_album
> contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN
> albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( (
> me.role = ? ) ) )': DBD::mysql::st execute failed: Unknown column
> 'me.role' in 'where clause' at
> C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.


Maybe throw us a frickin' vSlimServer ersion number of something.

Ben

BKDotCom
2006-11-02, 08:26
Maybe throw us a frickin' vSlimServerersion number of something.
BenBut of course: 6.5.1 nightlies: 11/2/2006 (and 10/16)

search for "various", click on various artists = crash

jonheal
2006-11-02, 08:49
On 11/1/06, BKDotCom <BKDotCom.2gmgtb1162432201 (AT) no-mx (DOT) forums.slimdevices.com>
wrote:
>
>
> Via Event Viewer:
>
> Carp::Clan::__ANON__(): Error executing 'SELECT COUNT( DISTINCT(
> album.id ) ) FROM contributors me LEFT JOIN contributor_album
> contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN
> albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( (
> me.role = ? ) ) )': DBD::mysql::st execute failed: Unknown column
> 'me.role' in 'where clause' at
> C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.


Maybe throw us a frickin' vSlimServer ersion number of something.

Ben

You don't have much patience for the unwashed masses, do you.

ceejay
2006-11-02, 08:51
How exactly are you doing the search? If I click on "Search Music" from the SS web home page, and put "Various" in the search box, I don't get "Various Artists" among my results. Do you? If so, do you have some albums tagged with "Various Artists" as the Artist or Album Artist?

Ceejay

JJZolx
2006-11-02, 10:42
Yes, the basic search brings up Various Artists for me. And clicking the link crashes the server in 7.0, r10536.

http://bugs.slimdevices.com/show_bug.cgi?id=4461

ceejay
2006-11-02, 11:02
Ah, you're using 7.0 ... you might want to note Dan's observation that the code is unstable and to hold off doing too many bug reports at the moment...

http://forums.slimdevices.com/showthread.php?t=29218

Ceejay

JJZolx
2007-01-28, 14:33
If anyone is following this, it's been fixed in 6.5.1 release and in 7.0. Maybe the result of the changes/fixes to other VA behavior.