Adding recording rule with accent : Kodi doesn't find show; NextPVR do

[nonob]

Hi,

I'm on Windows 7 with Kodi 18.3, NextPVR add-on 3.3.15 and NextPVR back-end 4.2.4 (190307) on the same PC.

First, thanks a lot for NextPVR, i'm a new user switching from Argus (that i used for years) and it seems great !

My issue :

If i add a recording rule from Kodi, type "repeat keyword" : L'hebdo de la musique :



Kodi doesn't found any programs :



But if i launch NextPVR and select the reccuring recording i created : "find all", it found programs :



I thing the issue is related to the accent because if i search the same keywords without it : "hebdo de la musique" :



Kodi find programs :



Can you help me with this issue ?

Thanks

[mvallevand]

I tried with v5 and it works fine from Kodi when I pick from the guide or enter accents from the french keyboard. I don't think it should match without the accents.

Martin

[nonob]

Hi,

Sorry for my late reply.

I'm new on NextPVR (i used Argus TV for years). If i'm right, v5 is in beta stage.

Is it recommended to use it ? Is it stable enought ?

My issue come when i add a manual shedule with "keyword", not when i pick from the guide; and it is related to "bracket" : ' , not accents.

Can you try ?

Thanks

[mvallevand]

What is the purpose of your "bracket" characters that you want me to test? I tried a rule from Kodi for ncis: and I got 56 recordings scheduled for ncis: los angeles and ncis: new orleans so the semi colons.

Martin

[nonob]

Sorry i made a mistake : i want to say "apostrophe", like "L'hebdo de la musique".

[mvallevand]

Thanks I should have noticed what might have been the issue. I duplicate it but I'm also mad at myself for breaking my rules about asking for logs since the answer is there.

The rule seems fine from Kodi

Code:

2019-08-27 12:19:35.905    [DEBUG][28]    method=recording.recurring.save
2019-08-27 12:19:35.905    [DEBUG][28]    parameters:
2019-08-27 12:19:35.905    [DEBUG][28]       method: recording.recurring.save
2019-08-27 12:19:35.905    [DEBUG][28]       recurring_id: 0
2019-08-27 12:19:35.905    [DEBUG][28]       name: L'arme fatale
2019-08-27 12:19:35.905    [DEBUG][28]       channel_id: 8969
2019-08-27 12:19:35.906    [DEBUG][28]       start_time: 1566954000
2019-08-27 12:19:35.906    [DEBUG][28]       end_time: 1566957600
2019-08-27 12:19:35.906    [DEBUG][28]       keep: 0
2019-08-27 12:19:35.906    [DEBUG][28]       pre_padding: 1
2019-08-27 12:19:35.906    [DEBUG][28]       post_padding: 3
2019-08-27 12:19:35.906    [DEBUG][28]       directory_id: Default
2019-08-27 12:19:35.906    [DEBUG][28]       keyword: L'arme fatale
2019-08-27 12:19:35.906    [DEBUG][28]       only_new: false
2019-08-27 12:19:35.906    [DEBUG][28]       sid: d4c366a9705041c5a5a660d3e83e536b
2019-08-27 12:19:35.906    [DEBUG][28]       client_ip: 172.16.3.219
2019-08-27 12:19:35.906    [DEBUG][28]       user_agent: Kodi/18.3 (Windows NT 10.0.18362; Win64; x64) App_Bitness/64 Version/18.3-Git:20190619-89472b7d69

But the sql call is not being formed correctly.

Code:

2019-08-27 12:19:36.337    [DEBUG][28]    LoadListingByAdvancedRules(channel=8969,advancedRules=(title like '%L'arme fatale%' or subtitle like '%L'arme fatale%' or description like '%L'arme fatale%'))
2019-08-27 12:19:36.337    [DEBUG][28]    SQL: select * from EPG_EVENT where channel_oid = 8969 and (title like '%L'arme fatale%' or subtitle like '%L'arme fatale%' or description like '%L'arme fatale%') order by start_time
2019-08-27 12:19:36.460    [ERROR][28]    Unexpected error in LoadListingByAdvancedRules: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'near "arme": syntax error'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at NShared.EPGManager.LoadListingByAdvancedRules(Channel channel, String advancedRules)
2019-08-27 12:19:36.461    [DEBUG][28]    <?xml version="1.0" encoding="utf-8" ?>
<rsp stat="ok">
  <recurring>
    <id>451</id>
    <name>L&apos;arme fatale</name>
  </recurring>
</rsp>

Martin

[nonob]

Great .

What should i do now ?

Are you the add-on and/or NextPVR creator ?

Thanks

[mvallevand]

Sub is the author of both but I have submitted some code for Kodi. Wait for sub not sure if he will fix it in both v4 and v5 and in the meantime use NextPVR to create manual rules with apostrophe's.

Martin

[nonob]

Ok. So i tried to creat the rule in NextPVR but it tell me "Invalid keyword" :

[ATTACH=CONFIG]47477[/ATTACH]

[mvallevand]

For this case, I suggest ignoring the L' since it is a wild card match and the chance of a mismatch is low. If you really want to use the full title you can use two apostrophe characters, but that rule might break if and when sub fixes this.

Martin