2012-02-25, 13:57
Hi guys,
I made a thread here a few days back where I noticed that my Lost Seasons in MySQL were not added properly.
Well, I now built XBMC myself and I know the bug
Looking at my "path" table with phpmyadmin, I can see this (idPath ; strPath):
8 ; x:\Lost\Season 1\
The problem is that XBMC builds this SQL statement in "CVideoDatabase::GetPathId":
select idPath from path where strPath like 'x:\\Lost\\Season 1\\'
However, even if I run this SQL statement in phpmyadmin then I will get no results. If however I do
select idPath from path where strPath like 'x:\\\\Lost\\\\Season 1\\\\'
then I very well get the correct pathID and then all the parts of the season are also added (I simply changed the idPath to the correct value of MySQL).
Now my question - is this a bug in my database? MySQL on Ubuntu 10.04? Do I need to adjust a setting in my database so that it will go from "oh well, it's a \ in the database, to ask for it you'd need to do ask me in form of \\ and to pass that into me you'd please have to do \\\\ but I know what you want and will change it to also check for \\"?
Basically, all I noticed is that MySQL only works properly for movies but will fail on these TV Shows as that requires subfolders and here it breaks...
I didn't check on how to fix this but even then I have no user to do that so I thought it' post it here. My guess is that all that is needed is to do one more "\" in front of each special character and solved...
minor update: I'm running MySQL 5.1.41-3ubuntu12.10 on Ubuntu 10.04
I made a thread here a few days back where I noticed that my Lost Seasons in MySQL were not added properly.
Well, I now built XBMC myself and I know the bug
Looking at my "path" table with phpmyadmin, I can see this (idPath ; strPath):
8 ; x:\Lost\Season 1\
The problem is that XBMC builds this SQL statement in "CVideoDatabase::GetPathId":
select idPath from path where strPath like 'x:\\Lost\\Season 1\\'
However, even if I run this SQL statement in phpmyadmin then I will get no results. If however I do
select idPath from path where strPath like 'x:\\\\Lost\\\\Season 1\\\\'
then I very well get the correct pathID and then all the parts of the season are also added (I simply changed the idPath to the correct value of MySQL).
Now my question - is this a bug in my database? MySQL on Ubuntu 10.04? Do I need to adjust a setting in my database so that it will go from "oh well, it's a \ in the database, to ask for it you'd need to do ask me in form of \\ and to pass that into me you'd please have to do \\\\ but I know what you want and will change it to also check for \\"?
Basically, all I noticed is that MySQL only works properly for movies but will fail on these TV Shows as that requires subfolders and here it breaks...
I didn't check on how to fix this but even then I have no user to do that so I thought it' post it here. My guess is that all that is needed is to do one more "\" in front of each special character and solved...
minor update: I'm running MySQL 5.1.41-3ubuntu12.10 on Ubuntu 10.04