View Full Version : Column 'genre' cannot be null

Dave C
2008-09-28, 17:51
Hey there! Some years back I was a pretty advanced user of slimserver. I haven't touched it in a while, until now. I'm having trouble getting it going and hoping to find some help here.

I've checked version 7.2 out of svn, onto an ArchLinux box. I'm connecting the server to an existing mysql database. A couple errors I cannot figure out...

First, theres something about mDNS. I doubt this is serious but if anyone can help me fix it great:

[08-09-28 17:29:59.9893] Slim::Utils::Misc::msg (1398) Warning: [17:29:59.9879] Can't exec "/home/dave/devel/squeezecenter-7.2/Bin/i386-linux/mDNSResponderPosix": No such file or directory at /home/dave/devel/squeezecenter-7.2/CPAN/Proc/Background/Unix.pm line 54.

But my real problem is that it wont scan my music library. I get errors about genre being null. Anyone know how to fix this?

[08-09-28 17:36:00.6219] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'INSERT INTO genre_track (genre, track) VALUES (?, ?)': DBD::mysql::st execute failed: Column 'genre' cannot be null at /home/dave/devel/squeezecenter-7.2/CPAN/DBIx/Class/Storage/DBI.pm line 771.

I also see some of these, possibly related?

[08-09-28 17:36:00.4365] Slim::Schema::throw_exception (236) Error: Can't update Slim::Schema::Progress=HASH(0x53f9a48): row not found
[08-09-28 17:36:00.4373] Slim::Schema::throw_exception (236) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/home/dave/devel/squeezecenter-7.2/Slim/Schema.pm line 236)
frame 1: Slim::Schema::throw_exception (/home/dave/devel/squeezecenter-7.2/CPAN/DBIx/Class/Row.pm line 461)
frame 2: DBIx::Class::Row::throw_exception (/home/dave/devel/squeezecenter-7.2/CPAN/DBIx/Class/Row.pm line 117)
frame 3: DBIx::Class::Row::update (/home/dave/devel/squeezecenter-7.2/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30)
frame 4: DBIx::Class::Relationship::CascadeActions::update (/home/dave/devel/squeezecenter-7.2/CPAN/DBIx/Class/InflateColumn.pm line 222)
frame 5: DBIx::Class::InflateColumn::update (/home/dave/devel/squeezecenter-7.2/Slim/Schema/DBI.pm line 35)
frame 6: Slim::Schema::DBI::update (/home/dave/devel/squeezecenter-7.2/Slim/Utils/Progress.pm line 115)
frame 7: Slim::Utils::Progress::total (/home/dave/devel/squeezecenter-7.2/Slim/Utils/Scanner.pm line 324)
frame 8: Slim::Utils::Scanner::scanDirectory (/home/dave/devel/squeezecenter-7.2/Slim/Music/MusicFolderScan.pm line 79)
frame 9: Slim::Music::MusicFolderScan::startScan (/home/dave/devel/squeezecenter-7.2/Slim/Music/Import.pm line 491)
frame 10: Slim::Music::Import::runImporter (/home/dave/devel/squeezecenter-7.2/Slim/Music/Import.pm line 335)
frame 11: Slim::Music::Import::runScan (/home/dave/devel/squeezecenter-7.2/scanner.pl line 213)
frame 12: (eval) (/home/dave/devel/squeezecenter-7.2/scanner.pl line 207)
frame 13: main::main (/home/dave/devel/squeezecenter-7.2/scanner.pl line 353)

Any help is greatly appreciated! Thanks.

2008-09-28, 21:22

Dave C
2008-09-30, 03:18
Thanks for that. It let me know that version 7.2 and 7.3 (the two I had tried) will not work on my box, running perl 5.10.

But 7.1 will, and it seems to be indexing my library OK. Trouble is, my squeezebox (Boom) refuses to connect to it. It insists that SqueezeCenter needs an upgrade. So, no music for me. I wish there were some way to tell it, "no really, use the firmware from this older server."

2008-09-30, 08:17
The 7.2 release should work fine for you. 7.2 from SVN won't.

Dave C
2008-09-30, 11:34
Hey, that appears to be true! I went for the svn hoping to use the latest and greatest. But I'm happy now that it's running. Thanks.

2008-09-30, 11:58
The latest is sometimes not so great ;)