Songs don't load with latest build

[Stevan Pettit]

running OpenLP 2.1.0 build bzr2146, Win 7

Song list is empty.

Following traceback in in log file

2013-01-16 08:37:11,220 root ERROR Traceback (most recent call last):
  File "D:\OpenLP_Code\Trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.songs.lib.mediaitem", line 168, in onSearchTextButtonClicked
  File "D:\OpenLP_Code\Trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.songs.lib.mediaitem", line 240, in displayResultsSong
  File "D:\OpenLP_Code\Trunk\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.core.lib", line 451, in create_separated_list
ValueError: unsupported format character ' ' (0x20) at index 2
None

[Andreas Preikschat (googol-deactivatedaccount)]

Can you attach the song database please...

[Stevan Pettit (elderp-deactivatedaccount)]

Here's the songs db

[matysek (mzibricky)]

Does this happen only with windows build or is it reproducible on other platforms too?

[Stevan Pettit (elderp-deactivatedaccount)]

This error appears to occur if the displayed song title contains certain "special" characters.

an ' (apostrophe) 'Tis so Sweet
a , (comma) Away In A Manger (Martin Luther, John Thomas McFarland) -- Multiple authors

I haven't tried to determine if other characters cause the problem.

[Michael Williams (mdubwilliams94)]

I am having a similar problem. However, it doesn't seem to be a problem with special characters. I'll list the details of my issue:
-all but 3 songs are missing in the songs tab (2 created by me, 1 included with the default database)
-I can still access all the songs from the export and import menus
-any new songs I create disappear was well
-My OS is Windows 7 Ultimate 64-bit with an Intel i3 Processor
-I am using OpenLP 2.0

We recently cleaned up the computer but OpenLP ran without a problem after that for a week or two. This past Friday the problem came up. As far as I know, nothing was changed or messed with in the computer.
Also, we have a partition running Ubuntu 12.10 with OpenLP on it (1.92 I believe). I'm not sure if this relevant, but just so you know.

Included is the bug report.

If you need any more tech info, let me know! Any help is appreciated.

[Michael Williams (mdubwilliams94)]

by "cleaned up" I mean we manually defragmented the Hard Drive