I just ran into the following error when creating smart playlists:
When creating a smart playlist where you want to use 'genre' when filtering tv shows, xbmc creates an invalid sql query. SQLite gives 'Error 1 - ambiguous column name: idshow'
This only happens when using tv shows, movies and episodes work ok.
XBMC r28275, Ubuntu 9.10
Here's the smartplaylist:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<rule field="genre" operator="contains">Documentary</rule>
And here's pastebin: http://pastebin.com/Kb5i6Lb9
I also tried the r28718 just to see if it's been fixed on newer SVN'n, and i encountered additional bug. This version also creates bogus sql, but this time it also messed up the LIKE '%%' command. If you have 'd' as first character, it becomes %d and that translates to some "random" decimal.
.. genre.strGenre LIKE '-1337005668ocumentary%'))
And here's pastebin: http://pastebin.com/ZdCupqxT