[mythtv] [Bug][Patch] SetBookmark putting String "NULL" in db
Steven
mythmail at richardstraat.homedns.org
Wed Feb 9 08:17:53 UTC 2005
>>Would this bug also explain this message I see in the log (CVS from a
>>couple of days ago) ?
>>
>>DB Error (delta position map insert):
>>Query was:
>>INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset)
>>VALUES ( NULL
>>'1003' , '20050208202400' , '5531' , 6 , '1497991206' );
>>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 ''1003' ,
>>'20050208202400
>>' , '5531' , 6 , '1497991206' )' at lin
>
>
> NO, this looks like a problem with chanid's somewhere since chanid is
> the field that's getting a NULL passed in.
>
>
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.
Steven
More information about the mythtv-dev
mailing list