[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