SQL Exception in log

[artmetz]

FYI - I just noticed this in the log. I have the latest build of the server. Looks like an apostrophe needs to be escaped. Let me know if you need additional info.
Art

2026-03-13 10:53:48.883 [DEBUG][92] LoadListingByAdvancedRules(channel='all channels',advancedRules=title like '%Cook's Country%')
2026-03-13 10:53:48.884 [ERROR][92] Unexpected error in LoadListingByAdvancedRules: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'near "s": 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.GetStatements(Stopwatch timer)+MoveNext()
  at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
  at NShared.EPGManager.LoadListingByAdvancedRules(Channel channel, String advancedRules)
2026-03-13 10:53:48.884 [ERROR][92] SQL: select * from EPG_EVENT where title like '%Cook's Country%' order by start_time

[mvallevand]

Is this a new or old rule? There are some changes that brought back some rules that were previously not showing.

Martin

[artmetz]

It's not a rule I created recently, if that's what you mean.
Art