Hello Michael,
Many thanks for the great work during all these years! I installed 7.9.0
and noticed that the rescan (Look for new and changed media files)
option is broken, at least when using MariaDB. I get the following error
in the scanner.log logfile:
[17-03-16 16:30:22.2933] Slim::Schema::Storage::throw_exception (122)
Error: DBI Exception: DBD::mysql::db selectrow_array failed: You have an
error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '== 'ssp'
) AS t1' at line 10 [for Statement "
SELECT COUNT(*) FROM (
SELECT DISTINCT(url)
FROM tracks
WHERE url NOT IN (
SELECT url FROM scanned_files
WHERE filesize != 0
)
AND url LIKE 'file:///music/playlist%'
AND virtual IS NULL
AND content_type == 'ssp'
) AS t1
"]
This can be easily fixed by updating the Scanner/Local.pm file as
follows:
187c187
< my $ctFilter = $args->{types} eq 'list' ? "= 'ssp'" : "!= 'dir'";
---
> my $ctFilter = $args->{types} eq 'list' ? "== 'ssp'" : "!= 'dir'";
Best regards,
Nicolas
------------------------------------------------------------------------
nmizel's Profile: http://forums.slimdevices.com/member.php?userid=997
View this thread: http://forums.slimdevices.com/showthread.php?t=107078
_______________________________________________
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
