[mythtv] [Bug][Patch] SetBookmark putting String "NULL" in db

Chris Pinkham cpinkham at bc2va.org
Wed Feb 9 01:53:56 UTC 2005


> >I confirmed it on my machine so the patch is now in CVS.  Thanks.  I also
> >added code to dbcheck.cpp to convert any existing occurances of the string
> >"NULL" to literal NULL in the recorded.bookmark column.
> >
> 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.

-- 

Chris



More information about the mythtv-dev mailing list