[mythtv-users] Trouble within Mysql,QT or MythTV

Benoît LORAND benoit.lorand at blorand.org
Tue Dec 22 18:36:17 UTC 2009


Le 21/12/2009 11:18, Benoît LORAND a écrit :
>  Hi,
>
>     I juste recompile my system in x86_64 and update Mythtv to 0.22-fixes
>  branches. (same problem with 0.22 release). Database is blank, i run
>  mythtv-setup and when i want to add my capture card (dvb cx88xx), when i
>  select finish : i can see no capture card. I have investigate near QT 
> and
>  QTMysql it's compiled as pluguin. I have debug mythtv and Mysql, see the
>  log below :
>
>  Mythtv :
>
>  2009-12-20 23:16:56.085 MSqlQuery::exec("INSERT INTO capturecard 
> (cardid)
>  VALUES (0);")
>  2009-12-20 23:16:56.086 MSqlQuery::exec() "SELECT * FROM capturecard 
> WHERE
>  cardid = '2';"
>  2009-12-20 23:16:56.087 MSqlQuery::exec() "UPDATE capturecard SET 
> cardid =
>  '2', cardtype = 'DVB' WHERE cardid = '2';"
>  2009-12-20 23:16:56.087 MSqlQuery::exec() "SELECT * FROM capturecard 
> WHERE
>  cardid = '2';"
>  2009-12-20 23:16:56.087 MSqlQuery::exec() "UPDATE capturecard SET 
> cardid =
>  '2', videodevice = '/dev/dvb/adapter0/frontend0' WHERE cardid = '2';"
>  2009-12-20 23:16:56.087 MSqlQuery::exec() "SELECT * FROM capturecard 
> WHERE
>  cardid = '2';"
>  2009-12-20 23:16:56.088 MSqlQuery::exec() "UPDATE capturecard SET 
> cardid =
>  '2', signal_timeout = '1000' WHERE cardid = '2';"
>  2009-12-20 23:16:56.088 MSqlQuery::exec() "SELECT * FROM capturecard 
> WHERE
>  cardid = '2';"
>  2009-12-20 23:16:56.088 MSqlQuery::exec() "UPDATE capturecard SET 
> cardid =
>  '2', channel_timeout = '3000' WHERE cardid = '2';"
>  2009-12-20 23:16:56.089 MSqlQuery::exec() "SELECT * FROM capturecard 
> WHERE
>  cardid = '2';"
>  2009-12-20 23:16:56.089 MSqlQuery::exec() "UPDATE capturecard SET 
> cardid =
>  '2', defaultinput = 'DVBInput' WHERE cardid = '2';"
>  2009-12-20 23:16:56.089 MSqlQuery::exec() "UPDATE capturecard SET 
> diseqcid
>  = '0' WHERE cardid = '2'"
>  2009-12-20 23:16:56.089 MSqlQuery::exec() "SELECT * FROM capturecard 
> WHERE
>  cardid = '2';"
>  2009-12-20 23:16:56.089 MSqlQuery::exec() "UPDATE capturecard SET 
> cardid =
>  '2', hostname = 'Salon' WHERE cardid = '2';"
>  2009-12-20 23:16:56.090 MSqlQuery::exec() "SELECT cardtype FROM
>  capturecard WHERE capturecard.cardid = '2'"
>  2009-12-20 23:16:56.090 MSqlQuery::exec() "SELECT cardid, videodevice,
>  cardtype FROM capturecard WHERE hostname = 'Salon' ORDER BY cardid"
>
>  SQL :
>
>  091220 23:16:56      26 Prepare     [367] INSERT INTO capturecard 
> (cardid)
>  VALUES (0)
>                       26 Execute     [367] INSERT INTO capturecard 
> (cardid)
>  VALUES (0)
>                       25 Prepare     [605] SELECT * FROM capturecard 
> WHERE
>  cardid = ?
>                       25 Execute     [605] SELECT * FROM capturecard 
> WHERE
>  cardid = 2
>                       25 Prepare     [606] UPDATE capturecard SET 
> cardid =
>  ?, cardtype = ? WHERE cardid = ?
>                       25 Execute     [606] UPDATE capturecard SET 
> cardid =
>  '\0\0', cardtype = 1447297792 WHERE cardid = 0
>                       27 Prepare     [416] SELECT * FROM capturecard 
> WHERE
>  cardid = ?
>                       27 Execute     [416] SELECT * FROM capturecard 
> WHERE
>  cardid = 2
>                       27 Prepare     [417] UPDATE capturecard SET 
> cardid =
>  ?, videodevice = ? WHERE cardid = ?
>                       27 Execute     [417] UPDATE capturecard SET 
> cardid =
>  '\0\0', videodevice = 1680808704 WHERE cardid = 0
>                       26 Prepare     [368] SELECT * FROM capturecard 
> WHERE
>  cardid = ?
>                       26 Execute     [368] SELECT * FROM capturecard 
> WHERE
>  cardid = 2
>                       26 Prepare     [369] UPDATE capturecard SET 
> cardid =
>  ?, signal_timeout = ? WHERE cardid = ?
>                       26 Execute     [369] UPDATE capturecard SET 
> cardid =
>  '\0\0', signal_timeout = 808518656 WHERE cardid = 0
>                       25 Prepare     [607] SELECT * FROM capturecard 
> WHERE
>  cardid = ?
>                       25 Execute     [607] SELECT * FROM capturecard 
> WHERE
>  cardid = 2
>                       25 Prepare     [608] UPDATE capturecard SET 
> cardid =
>  ?, channel_timeout = ? WHERE cardid = ?
>                       25 Execute     [608] UPDATE capturecard SET 
> cardid =
>  '\0\0', channel_timeout = 808649728 WHERE cardid = 0
>                       27 Prepare     [418] SELECT * FROM capturecard 
> WHERE
>  cardid = ?
>                       27 Execute     [418] SELECT * FROM capturecard 
> WHERE
>  cardid = 2
>                       27 Prepare     [419] UPDATE capturecard SET 
> cardid =
>  ?, defaultinput = ? WHERE cardid = ?
>                       27 Execute     [419] UPDATE capturecard SET 
> cardid =
>  '\0\0', defaultinput = 1447299072 WHERE cardid = 0
>                       26 Prepare     [370] UPDATE capturecard SET 
> diseqcid
>  = ? WHERE cardid = ?
>                       26 Execute     [370] UPDATE capturecard SET 
> diseqcid
>  = 0 WHERE cardid = 0
>                       25 Prepare     [609] SELECT * FROM capturecard 
> WHERE
>  cardid = ?
>                       25 Execute     [609] SELECT * FROM capturecard 
> WHERE
>  cardid = 2
>                       25 Prepare     [610] UPDATE capturecard SET 
> cardid =
>  ?, hostname = ? WHERE cardid = ?
>                       25 Execute     [610] UPDATE capturecard SET 
> cardid =
>  '\0\0', hostname = 1632830720 WHERE cardid = 0
>                       27 Prepare     [420] SELECT cardtype FROM 
> capturecard
>  WHERE capturecard.cardid = ?
>                       27 Execute     [420] SELECT cardtype FROM 
> capturecard
>  WHERE capturecard.cardid = 2
>                       26 Prepare     [371] SELECT cardid, videodevice,
>  cardtype FROM capturecard WHERE hostname = ? ORDER BY cardid
>                       26 Execute     [371] SELECT cardid, videodevice,
>  cardtype FROM capturecard WHERE hostname = 'Salon' ORDER BY cardid
>
>  Result in SQL :
>
>  1, '', '', '', 'V4L', 'Television', , '', 0, 0, 1, 0, 0, , 0, '', 0,
>  31338, 80, '', 1000, 3000, 0, 0, 0, 0, 0, , 1
>
>  ---------------------------------
>
>  Mysql is : mysql  Ver 14.12 Distrib 5.0.85, for unknown-linux-gnu 
> (x86_64)
>  using  EditLine wrapper
>
>  MythTV Version   : 22991
>  MythTV Branch    : branches/release-0-22-fixes
>  Network Protocol : 50
>  Library API      : 0.22.20091023-1
>  QT Version       : 4.5.3
>  Options compiled in:
>   linux release using_oss using_alsa using_backend using_dvb 
> using_frontend
>  using_hdhomerun using_hdpvr using_iptv using_ivtv using_joystick_menu
>  using_lirc using_mheg using_opengl_video using_opengl_vsync 
> using_qtwebkit
>  using_v4l using_x11 using_xrandr using_xv using_xvmc using_bindings_perl
>  using_bindings_python using_opengl using_vdpau using_ffmpeg_threads
>  using_live using_mheg
>
>  Thanks for help.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
mysql database is in utf8 format, i also tried in latin1 but nothing change.


More information about the mythtv-users mailing list