Retrieving datadirect data...
Grabbing data for Sat Mar 5 2005 offset 13
From : Fri Mar 18 05:00:00 2005 To : Sat Mar 19 05:00:00 2005 (UTC)
Your subscription expires on 05/20/05 05:19:53
Grab complete. Actual data from Fri Mar 18 05:00:00 2005 to Fri Mar 18 23:59:59 2005 (UTC)
Clearing data for source...
Clearing from Fri Mar 18 00:00:00 2005 to Fri Mar 18 18:59:59 2005 (localtime)
Data for source cleared...
Main temp tables populated. Updating myth channels...
Updating icons for sourceid: 1
Channels updated.. Updating programs...
Adjusting program database end times...
0 replacements made.
Marking repeats...found 4486
Unmarking repeats from grabber that fall within our new episode window...found 11
2005-03-05 02:10:34.636 Connecting to backend server: 192.168.0.110:6543 (try 1 of 5)
2005-03-05 02:10:34.646 Using protocol version 14
DB Error (UpdateMatches):
Query was:
INSERT INTO recordmatch (recordid, chanid, starttime) SELECT record.recordid, program.chanid, prog$
AND program.subtitle REGEXP "(Orioles|Nationals|)"
AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10) OR ((record.st$
Driver error was [2/1139]:
QMYSQL3: Unable to execute query
Database error was:
Got error 'empty (sub)expression' from regexp
And sure enough, my entire Scheduled Recordings screen was cleared out. Not only the baseball games are cleared out -- everything is, even the shows that I manually set using "Record only this showing."
Here's the output of the mysql query:
*************************** 1. row ***************************
type: 4
title: MLB%Baseball:Orioles:::: (Power Search)
description: AND program.title LIKE "%MLB%Baseball%" AND program.subtitle LIKE "%Orioles%"
*************************** 2. row ***************************
type: 4
title: MLB (Power Search)
description: AND program.title LIKE "MLB%Baseball"
AND program.subtitle REGEXP "(Orioles|Nationals|)"
*************************** 3. row ***************************
type: 4
title: MLB%Baseball:Nationals:::: (Power Search)
description: AND program.title LIKE "%MLB%Baseball%" AND program.subtitle LIKE "%Nationals%"
*************************** 4. row ***************************
type: 4
title: South Park::::: (Power Search)
description: AND program.title LIKE "%South Park%"
4 rows in set (0.00 sec)
(Note: I notice that I have duplicative rules. If you can tell me how to delete number 2, I'd be most grateful -- I don't know the first thing about mysql commands.)
Scott
Bruce Markey wrote:
Scott Minneman wrote:
That's the method I used to set it up. I followed all of those instructions exactly, and it works for the rest of that day, but clears out after that.
I run mythfilldatabase at night, so I think that's the culprit. Not running mythdatabase, however, is obviously not an option. I could reduce its run frequency, but resetting my search rules once a week is only marginally less of a hassle than resetting them once a day.
You shouldn't have to reset the rules. If the schedule is correct when add a search rule it should be okay any other time the scheduler runs. The logs for mythfilldatabase and the master backend should have clues if something went wrong. Look for error messages and also check for the lines that say how many items where scheduled.
2005-03-04 06:41:59.496 Reschedule requested for id -1.
2005-03-04 06:42:05.502 Scheduled 378 items in 3.9 = 2.98 match + 0.88 place
If it had items before but then zero when mythfilldatabase runs, that would be a problem. Also, you can try running mythfilldatabase from the command line to see if that causes a problem.
So, was the schedule okay after you first set the rule? Is the schedule okay when you restart the master backend? When the schedule is blank, does running "mythbackend --resched" from another shell fix the problem? If this does happen when mythfilldatabase runs, is there show information in the Program Guide?
If it does seem to be related to having search rules, could you sent the output of:
$ mysql -u mythtv -pmythtv mythconverg mysql> select type,title,description from record where search=1\G
-- bjm
------------------------------------------------------------------------
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
--
Scott Minneman J.D. Candidate, 2007 The George Washington University Law School
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
