Chris Pinkham schreef:
ChanID is 1003 in this case, but there is NULL before that in the value list :
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) >>VALUES ( NULL >>'1003' , '20050208202400' , '5531' , 6 , '1497991206' );
None of my channels in channel table have NULL as chanID.
I'll try upgrading to todays CVS.
Sorry, I missed that. I knew the first column in the list was chanid and saw the NULL as the first value. That is odd.
It gets even weirder. Got this in my log followed by a backend crash : Seems to happen when two recordings start at the same time.
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) VALUES ( :CHANID , :STARTTIME , :MARK , :TYPE , :OFFSET NULL);
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 ':CHANID , :STARTTIME , :MARK , :TYPE , :OFFSET NULL)' at line 1
DB Error (delta position map insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) VALUES ( :CHANID , :STANULLRTTIME , '493' , 6 , '196368422' );
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 ':CHANID , :STANULLRTTIME , '493' , 6 , '196368422' )' at line 1
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
