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

[Xavier Hervy]

Asciimonster wrote:
> 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...

I see one mail about this problem (probably yours ?) and it talk about 
an error in log, then send me the log to know which sql query failed.
And can you tell me what you can see in the recgroup fields of recorded, 
record tables ?


Xavier