Bug 3112 – Files with no "DATE" attribute are not added to library when using MySQL

Bug 3112 - Files with no "DATE" attribute are not added to library when using MySQL

Summary:

Files with no "DATE" attribute are not added to library when using MySQL

Status:	CLOSED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Database
Version:	6.2.1
Platform:	PC Windows XP

Importance:	P2 major (vote)
Target Milestone:	---
Assigned To:	Dan Sully

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-03-05 20:47 UTC by Jordan Hirsch
Modified:	2008-12-15 11:58 UTC (History)
CC List:	1 user (show)

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Jordan Hirsch 2006-03-05 20:47:12 UTC

I am using MySQL 5.0 on Windows XP.  When I scan my library, I get this message for any file that does not have a DATE attribute defined:

2006-03-05 22:52:11.4554 DBD::mysql::st execute failed: Incorrect integer value: '' for column 'year ' at row 1 at C:\Program Files\SlimServer\server\CPAN/DBIx/ContextualFetch.pm line 51.
2006-03-05 22:52:11.4633 Backtrace:

   frame 0: Slim::DataStores::DBI::DBIStore::newTrack (/PerlApp/Slim/DataStores/DBI/DBIStore.pm line 595)
   frame 1: Slim::DataStores::DBI::DBIStore::updateOrCreate (/PerlApp/Slim/DataStores/DBI/DBIStore.pm line 226)
   frame 2: Slim::DataStores::DBI::DBIStore::objectForUrl (/PerlApp/Slim/Utils/Scan.pm line 542)
   frame 3: Slim::Utils::Scan::readList (/PerlApp/Slim/Utils/Scan.pm line 217)
   frame 4: Slim::Utils::Scan::addToList_run (/PerlApp/Slim/Utils/Scheduler.pm line 99)
   frame 5: Slim::Utils::Scheduler::run_tasks (slimserver.pl line 618)
   frame 6: main::idle (slimserver.pl line 570)
   frame 7: main::main (slimserver.pl line 59)
   frame 8: PerlSvc::Interactive (perlsvc.pl line 1485)
   frame 9: PerlSvc::_interactive (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

2006-03-05 22:52:11.4993 Couldn't create track for file:///J:/Music/Al%20Cohn/America/07%20Comin%27%20In%20Home.mp3 : Can't insert new Slim::DataStores::DBI::Track: DBD::mysql::st execute failed: Incorrect 

integer value: '' for column 'year' at row 1 at C:\Program Files\SlimServer\server\CPAN/DBIx/ContextualFetch.pm line 51. at /PerlApp/Slim/DataStores/DBI/DBIStore.pm line 489

Consequently these tracks never make it into the database.

Comment 1 Dan Sully 2006-04-10 22:38:34 UTC

Fixed - will be in the 2006-04-11 6.2.2 nightly.

Comment 2 Jordan Hirsch 2006-04-30 12:20:51 UTC

Thank you!  I am now using a 6.5 beta build, so I can't test this until it makes its way into the 6.5 trunk; but thank you for working on it.

Comment 3 Dan Sully 2006-04-30 12:46:59 UTC

Jordan - this patch is in trunk as well.

Comment 4 Jordan Hirsch 2006-04-30 12:51:42 UTC

Oh great!  What version of 6.5 should I install to test it out?  I am currently running SlimServer Version: 6.5b1 - 6542 - Windows XP - EN - cp1252

Forgive me if I mis-used the word "trunk," CVS is not my native language.

Comment 5 Dan Sully 2006-04-30 12:57:47 UTC

Anything past 2006-04-11. I would recommend the latest. 2006-04-30

Comment 6 James Richardson 2008-12-15 11:58:00 UTC

This bug has been fixed in the latest release of SqueezeCenter!

Please download the new version from http://www.slimdevices.com/su_downloads.html if you haven't already.  

If you are still experiencing this problem, feel free to reopen the bug with your new comments and we'll have another look.