I have this
UPDATE files SET playCount = 1 WHERE strFilename LIKE "%%s04e03 EPT 4 - Barcelona Final Table.avi"
xbmc.executehttpapi( "ExecVideoDatabase(%s)" % urllib.quote_plus(query.encode( "utf-8", "ignore" )), )
This is just my guess... somewhere after that the double % get handle as %s (due to the filename starting with s) and that wont return a match.
If I remove the %% it works, but I need em in some cases.
If I change the first s to upper case it works, but not really a fix.
What am I doing wrong