PDA

View Full Version : Scanner syntax error



begould
2008-12-06, 15:04
I am getting the error below each time I rescan in an attempt to get all tracks scanned in. Apparently the syntax in some album titles is causing this. Any fix for this?


Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO albums (title) VALUES (?)': 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 syntax to use near '' periment On A Flat Plane')' at line 1 at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
]

Siduhe
2008-12-06, 15:31
Could be a couple of things - what OS are you running and how did you install Squeezecenter? Are you using a custom version of SQL?

One simple thing to check - are you missing a ' at the start of the album tag anywhere - have a look at all the tags in a full featured tagger like mp3tag. See this similar thread:

http://forums.slimdevices.com/showthread.php?t=36949&highlight=error+SQL+syntax