[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