Apostrophe in file name triggers SQL error on media library

What steps will reproduce the problem?
1. Leave a mp3 file with an apostrophe on it
2. Enable media library
3. Browse the media library to locate the file

What is the expected output? What do you see instead?
- I should see the file, but it does not get shown. If I browse via folder,
the filesystem replaces the apostrophe with _ and it does appear normally.

What version of the product are you using? On what operating system?
- 1.10.5 on Mac OS X 10.5.8, 32bit. (although the process appears as 64-bit)

If you are transcoding a media file, which engine are you using (mencoder,
avisynth/mencoder, tsmuxer?)
- Audio Files Engines shows MPlayer audio in bold.

If the media file is in error (or does not play flawlessly), what are the
codec informations of this file (you can use following program:
mediainfo.sourceforge.net) ? 
- It does play fine (it's a mp3)

Please provide any additional information below and PLEASE JOIN debug.log
file !!
- Relevant part:
[Thread-16707] DEBUG 03:48:38.812 Opened handler on socket
Socket[addr=/192.168.1.197,port=59633,localport=5001]
[Thread-16707] DEBUG 03:48:38.812 Received on socket: POST
/upnp/control/content_directory HTTP/1.1
[Thread-16707] DEBUG 03:48:38.812 Received on socket: X-AV-Client-Info:
av=5.0; cn="Sony Computer Entertainment Inc."; mn="PLAYSTATION 3"; mv="1.0";
[Thread-16707] DEBUG 03:48:38.819 Received on socket: Host: 192.168.1.118:5001
[Thread-16707] DEBUG 03:48:38.819 Received on socket: User-Agent: UPnP/1.0
DLNADOC/1.50
[Thread-16707] DEBUG 03:48:38.819 Received on socket: Content-Length: 917
[Thread-16707] DEBUG 03:48:38.819 Received on socket: Content-Type:
text/xml; charset="utf-8"
[Thread-16707] DEBUG 03:48:38.819 Received on socket: SOAPACTION:
"urn:schemas-upnp-org:service:ContentDirectory:1#Browse"
[Thread-16707] INFO  03:48:38.819 HTTP: upnp/control/content_directory / 0-0
[Thread-16707] DEBUG 03:48:38.819 Wrote on socket: HTTP/1.1 200 OK
[Thread-16707] DEBUG 03:48:38.819 Wrote on socket: CONTENT-TYPE: text/xml;
charset="utf-8"
[Thread-16707] DEBUG 03:48:38.819 Searching for objectId: 0$2$0$2$18 with
children option: true
[Thread-16707] TRACE 03:48:38.840 org.h2.jdbc.JdbcSQLException: Syntax
error in SQL statement select FILENAME, MODIFIED  from FILES F, AUDIOTRACKS
A where F.ID = A.FILEID AND F.TYPE = 1 AND A.ARTIST = 'Alma D'Jem[*]'; SQL
statement:
[Thread-16707] TRACE 03:48:38.840 select FILENAME, MODIFIED  from FILES F,
AUDIOTRACKS A where F.ID = A.FILEID AND F.TYPE = 1 AND A.ARTIST = 'Alma
D'Jem' [42000-105]
[Thread-16707] TRACE 03:48:38.841   at
org.h2.message.Message.getSQLException(Message.java:103)
[Thread-16707] TRACE 03:48:38.841   at
org.h2.message.Message.getSQLException(Message.java:114)
[Thread-16707] TRACE 03:48:38.841   at
org.h2.message.Message.getSQLException(Message.java:77)
[Thread-16707] TRACE 03:48:38.841   at
org.h2.message.Message.getSyntaxError(Message.java:126)
[Thread-16707] TRACE 03:48:38.842   at
org.h2.command.Parser.getSyntaxError(Parser.java:469)
[Thread-16707] TRACE 03:48:38.842   at
org.h2.command.Parser.checkRunOver(Parser.java:2986)
[Thread-16707] TRACE 03:48:38.842   at
org.h2.command.Parser.initialize(Parser.java:2910)
[Thread-16707] TRACE 03:48:38.842   at
org.h2.command.Parser.parse(Parser.java:275)
[Thread-16707] TRACE 03:48:38.842   at
org.h2.command.Parser.parse(Parser.java:264)
[Thread-16707] TRACE 03:48:38.842   at
org.h2.command.Parser.prepareCommand(Parser.java:232)
[Thread-16707] TRACE 03:48:38.843   at
org.h2.engine.Session.prepareLocal(Session.java:344)
[Thread-16707] TRACE 03:48:38.843   at
org.h2.engine.Session.prepareCommand(Session.java:305)
[Thread-16707] TRACE 03:48:38.843   at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1043)
[Thread-16707] TRACE 03:48:38.843   at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:72)
[Thread-16707] TRACE 03:48:38.843   at
org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:220)
[Thread-16707] TRACE 03:48:38.843   at
net.pms.dlna.DLNAMediaDatabase.getFiles(DLNAMediaDatabase.java:513)
[Thread-16707] TRACE 03:48:38.844   at
net.pms.dlna.virtual.MediaLibraryFolder.discoverChildren(MediaLibraryFolder.java
:40)
[Thread-16707] TRACE 03:48:38.844   at
net.pms.dlna.DLNAResource.getDLNAResources(DLNAResource.java:314)
[Thread-16707] TRACE 03:48:38.844   at
net.pms.network.Request.answer(Request.java:352)
[Thread-16707] TRACE 03:48:38.844   at
net.pms.network.RequestHandler.run(RequestHandler.java:126)
[Thread-16707] TRACE 03:48:38.844   at java.lang.Thread.run(Thread.java:637)
[Thread-16707] DEBUG 03:48:38.909 End of analysis
[Thread-16707] DEBUG 03:48:38.910 Wrote on socket: Server:
Mac_OS_X-x86_64-10.5.8, UPnP/1.0, PMS/1.10.5
[Thread-16707] DEBUG 03:48:38.910 Wrote on socket: Content-Length: 597
[Thread-16707] DEBUG 03:48:38.910 Wrote on socket: 
[Thread-16707] DEBUG 03:48:38.910 Close Connection
Original issue reported on code.google.com by pedro.pr...@gmail.com on 5 Sep 2009 at 7:08
Unknown1User / ps3mediaserver

Apostrophe in file name triggers SQL error on media library #519
