Hi,

I'm using SlimServer svn revision 1828 on Linux with a mysql backend.

If I try to scan a .ogg file, the server dies with an SQL error. I traced the
DBI layer with "DBI_TRACE=1 ./slimserver.pl --d_sql". If I remove the .ogg files
from my music directory, the scan finishes successfully.

Just in case that might be a problem with my database, I dropped all the tables
and let slimserver recreate the whole database; the result is the same

 T  <- prepare_cached('INSERT INTO contributor_track (track, namesort, role,
contributor)
VALUES (?, ?, ?, ?)
')= DBIx::ContextualFetch::st=HASH(0x9985970) at DBI.pm line 391
 T  <- FETCH('Taint')= 1 at ContextualFetch.pm line 49
    <- STORE('Taint' 0)= 1 at ContextualFetch.pm line 50
    <- execute('1200' 'SHANIA TWAIN' ...)= 1 at ContextualFetch.pm line 51
 T  <- STORE('Taint' 1)= 1 at ContextualFetch.pm line 52
 T  <- FETCH('mysql_insertid')= '780' at DBI.pm line 649
 T  <- prepare_cached('UPDATE tracks
SET    bitrate = ?, vbr_scale = ?, age = ?, ct = ?, size = ?, rate = ?,
titlesort = ?, tag = ?, fs = ?, offset = ?, channels = ?, secs = ?, tracknum =
?, album = ?, title = ?, year = ?
WHERE  id=?
')= DBIx::ContextualFetch::st=HASH(0x9ba8bdc) at DBI.pm line 391
 T  <- FETCH('Taint')= 1 at ContextualFetch.pm line 49
    <- STORE('Taint' 0)= 1 at ContextualFetch.pm line 50
    !! ERROR: 1064 'You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use n
ear ' age = 1038843474, ct = 'ogg', size = 1720013, rate = 44.1, tit' (err#0)
    <- execute(64001 '' ...)= undef at ContextualFetch.pm line 51
DBD::mysql::st execute failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right synt
ax to use near ' age = 1038843474, ct = 'ogg', size = 1720013, rate = 44.1, tit
at /home/slimserver/SlimServer_svn/slim/trunk/server/CPAN/DBIx/Contextu
alFetch.pm line 51.
Can't update
file:///home/slimserver/Music/S-Z/Shania%20Twain/Come%20On%20Over/Shania%20Twain%20-%20Black%20Eyes,%20Blue%20Tears.ogg:
DBD::mysql::st ex
ecute failed: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near '
age = 1038843474, ct = 'ogg', size = 1720013, rate = 44.1, tit at
/home/slimserver/SlimServer_svn/slim/trunk/server/CPAN/DBIx/ContextualFetch.pm
line 5
1.
 at
/home/slimserver/SlimServer_svn/slim/trunk/server/Slim/DataStores/DBI/DBIStore.pm
line 364
    <- disconnect_all= '' at DBI.pm line 673
    <- disconnect_all= (not implemented) at DBI.pm line 673
       ERROR: 1064 'You have an error in your SQL syntax.  Check