Trouble within Mysql,QT or MythTV

[Benoit LORAND <benoit.lorand@…>]

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.

[danielk]

Please ask for help on the mythtv-users mailing list.