apostrophe in artist name (1 Viewer)

[nino]

TV-Server Version:
MediaPortal Version: 0.2.3.0 SVN 16750
MediaPortal Skin: Xface
Windows Version: XP SP2
CPU Type:
HDD:
Memory:
Motherboard:
Motherboard Chipset:
Motherboard Bios:
Video Card:
Video Card Driver:
Sound Card:
Sound Card AC3:
Sound Card Driver:
1. TV Card: Digital Everywhere FireDTV
1. TV Card Type: DVB-C
1. TV Card Driver: BDA
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote: MCE
TV:
TV - HTPC Connection: DVI


Hi -

If the name of an artist contains an apostrophe (i.e. Pavlov's Dog, Guns N' Roses) the songs of an album don't show up in album view. After removing the apostrophe from the arist id3 tag all songs of that album are listed correctly. I read about "apostrophe issues" with respect to cover art, however, I couldn't find a hint on this problem.
Is there another solution than removing the apostrophes from the artist name?

Thanks!

nino

 

[hwahrmann]

is it only the album view or other views as well?
this should work.

Please post mediaportal.log, we should see a sql error inside.

 

[nip.nyborg]

Hi Nino

I had the same problem, until I found out that somehow there was a space between apostrophe and next letter,
on the thumbs, but not on the artist. (or opposite don´t remember) Make sure it is eksacly the same.
Hope it helps you.

Nip

 

[nino]

Hi hwahrmann and nip.nyborg

Thanks for your replies!

Its not a "space problem" - indeed there is an sql exception.

I updated the tag of one song so that Mediaportal would update the database. In Mediaportal.log the following showed up:

2008-01-02 21:07:19.125000 [Info.][MPMain]: SQLiteClient: MusicDatabaseV10.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:near "s": syntax error query:select * from tracks where strAlbumArtist like '%| Pavlov''s Dog |%' and strAlbum like 'At The Sound Of The Bell' and strAlbumArtist like '%| Pavlov's Dog |%' order by iTrack asc
2008-01-02 21:07:19.140625 [Info.][MPMain]: musicdatabase exception errQLiteClient: MusicDatabaseV10.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:near "s": syntax error query:select * from tracks where strAlbumArtist like '%| Pavlov''s Dog |%' and strAlbum like 'At The Sound Of The Bell' and strAlbumArtist like '%| Pavlov's Dog |%' order by iTrack asc stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Music.Database.MusicDatabase.GetSongsByFilter(String aSQL, List`1& aSongs, String filter)
2008-01-02 21:07:19.140625 [Info.][MPMain]: MusicDatabase: Opening database
2008-01-02 21:07:19.140625 [Info.][MPMain]: MusicDatabase: Database opened

When viewing a plain song listing ("title view"?) the songs are visible.

Cheers,

Nino

 

[hwahrmann]

Please post the complete log, i need to see, where the sql is generated.
please note that i'll be out of town the next days, so a fix will be available on monday, when i'm back.

Edit: Nevermind. found the problem. fix is included n next public build.

 

[nino]

Great!

I installed the latest svn version - it works like a charm now!

I'm impressed by that short "from bug report to bug fix time"

Thank you very much,

Cheers,

nino