hauppauge hvr1800 non-digital configuration for mythtv

[Mike McMullin]

On Wed, 2013-08-28 at 01:15 -0400, Mike McMullin wrote:
> I have an HVR-1800 that I'm trying to setup in Mythtv, I'm looking for
> the analog cable info (though I have both analog and digital fed by
> cable, there are digital issues in my area.)
>  I have v4l-cx23885-avcore-01.fw root:root, and 4vl-cx23885-enc.fw in
> the /lib/firmware directory and the /lib/firmware/uname -r directory
> (3.2.0-55generic-pae 32bit)
> 
> mythtv backend version is v0-25.2-15-g46cab93
> 
> I see the following in the tail end of the logs:
> 
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)#012Bindings were:#012:APP="mythbackend", :FILENAME="mythcommandlineparser.cpp",#012:FUNCTION="ConfigureLogging", :HOST="front-main", :LEVEL=2, :LINE=2534,#012:MESSAGE="mythbackend version: fixes/0.25 [v0.25.2-15-g46cab93] www.mythtv.org",#012:MSGTIME="2013-08-27 03:58:54", :PID=2152, :THREAD="CoreContext", :TID=2152#012Driver error was [2/1064]:#012QMYSQL: Unable to execute query#012Database error was:#012You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME,' at line 1
> Aug 28 00:47:36 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
> (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> Aug 28 00:47:36 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Table
> './mythconverg/logging' is marked as crashed and last (automatic?)
> repair failed
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
> (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Table
> './mythconverg/logging' is marked as crashed and last (automatic?)
> repair failed
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
> (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Table
> './mythconverg/logging' is marked as crashed and last (automatic?)
> repair failed
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
> (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Table
> './mythconverg/logging' is marked as crashed and last (automatic?)
> repair failed
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
> (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Table
> './mythconverg/logging' is marked as crashed and last (automatic?)
> repair failed
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
> (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES
> (:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> Aug 28 00:47:37 front-main mythbackend[2152]: E DBLogger
> mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
> to prepare statement#012Database error was:#012Table
> './mythconverg/logging' is marked as crashed and last (automatic?)
> repair failed
> 
> 
> Card type is setup as MPEG-2
> video device /dev/video0
> vbi device /dev/vbi0
> Probed info: Hauppauge WinTV-HVR1800 [cx23885]
> 
> 
> Any kind of help would be appreciated, the myth archives aren't of much
> use for this card.

  Frankly it's not supported due to a problem with the driver module.
The Kernel team has been working on the driver module since summer of
2012, but there are still outstanding issues with the analog side of the
card.