Error in advanced rules breaks recurring recordings

[XJW]

I was halfway through editing an advanced rule and saved the manual recording. I can no longer access Recurring Recordings. It produces an unhandled exception.

title like '%octonauts%' AND time(

[sub]

Zip and attach your database and I'll take a look.

[XJW]

Attached. Ta.
Is it just me or will that rule bugger everyone ?

[sub]

I can see your database being broken when you try to view that list, but I'm not quite sure how you got it like that. I've tried to reproduce it, but it was fine here with the text you supplied above. It wouldnt have matched any shows, but it didnt cause any crashes.

Can you tell me more about how it happened? Where you entering a manual recording in the Recordings screen, or in a plugin, or in NEWA?

[XJW]

I was in the standard npvr recordings screen submitting a manual recurring recording. Is there other data I can pull ?

************** Exception Text **************
System.Xml.XmlException: '', hexadecimal value 0x16, is an invalid character. Line 10, position 57.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args)
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
at System.Xml.XmlTextReaderImpl.ParseText()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at NUtility.RecurringRecording.get_MatchRulesDoc()
at NUtility.RecurringRecording.get_ChannelOID()
at NextPVR.TV.Recordings2.LoadList(UiList uiList, RecordingView recordingView)
at NextPVR.TV.Recordings2.NextView()
at NextPVR.TV.Recordings2.OnKeyDown(KeyEventArgs e)
at NextPVR.ControllerForm.OnKeyDown(Object sender, KeyEventArgs e)
at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at NextPVR.ControllerForm.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[XJW]

Is there anyway I can fix the db ?

[XJW]

I managed to create what appeared to be a clean copy of the recurring recordings but it would not import the file. The import tool does not appear to like "All Channels". I will raise another thread on this.

In the end I restarted with the empty db and re-entered all my recurring recordings manually.