[mythtv-users] How to fix the Dutch Language problem

Asciimonster asciimonster at myrealbox.com
Tue Jun 15 12:54:47 EDT 2004


Xavier Hervy wrote:

> Asciimonster wrote:
>
>> Since the 0.15 version mythtv has problems retrieving recorded 
>> programme info due to a database problem. It is trying to issue a 
>> database command with the string 'Alle Programma's' (All Programs) 
>> where the apostrophy before the s is the obvious problem. This was 
>> not fixed in the 0.15.1 version, so I'll have to fix it myself.
>
>
> Search in source all code that use table recorded or recordpassword 
> with UPDATE or INSERT INTO.
> then replace .arg(recgroup) by .arg(recgroup.replace(QRegExp("'"),"\'")
> *SNIP*
> QString querystr = QString("UPDATE recorded SET recgroup = '%1', "
>                  "starttime = '%2' WHERE chanid = '%3' AND "
>                  "starttime = '%4';")
>                  .arg(newrecgroup.replace(QRegExp("'"),"\'")
>                  .arg(starts)
>                  .arg(chanid).arg(starts);

Darned. It didn't work. MythTV still cannot find any recorded shows when 
I'm in Dutch mode...
Well, first had to change some things since newrecgroup is defined as 
const QString &newrecgroup:

QString newrecgroup2(newrecgroup);
newrecgroup2.replace(QRegExp("'"),"\'");
-> Next change every newrecgroup in newrecgroup2

Mmm. Beginning to doubt if the apostrophy is really the problem...


More information about the mythtv-users mailing list