Hi,
In CVS from last night I see this error:
DB Error (SetMarkupMap checking record table):
Query was:
SELECT starttime FROM recorded WHERE chanid = '1051' AND starttime : STARTTIME ;
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near ': STARTTIME' at
line 1
Which is fixed with the attached patch.
Happy Holidays,
Shane
--- mythtv-dec24-cvs/libs/libmythtv/programinfo.cpp 2004-12-24 22:28:11.000000000 -0500
+++ mythtv-dec24.2/libs/libmythtv/programinfo.cpp 2004-12-25 11:15:07.000000000 -0500
@@ -1425,7 +1425,7 @@
// check to make sure the show still exists before saving markups
query.prepare("SELECT starttime FROM recorded"
" WHERE chanid = :CHANID"
- " AND starttime : STARTTIME ;");
+ " AND starttime = :STARTTIME ;");
query.bindValue(":CHANID", chanid);
query.bindValue(":STARTTIME", recstartts.toString("yyyyMMddhhmm00"));
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
