Opened 14 years ago

Closed 14 years ago

Last modified 14 years ago

#7610 closed defect (duplicate)

MythTv 0.22 doesn't work with mysql 5.1.41

Reported by: pyther@… Owned by: Isaac Richards
Priority: blocker Milestone: unknown
Component: MythTV - General Version: 0.22
Severity: high Keywords:
Cc: Ticket locked: no

Description

Well after running installing updates from my distro myth stopped working. After some trouble shooting I have determined it has something to do with the mysql 5.1.41 upgrade.

I have started with a clean database (backed up my old one). This are the errors I am getting in mythtv-setup making it impossible to do anything!

2009-11-18 22:52:42.949 DB Error (CardUtil::GetVideoDevices?): Query was: SELECT videodevice FROM capturecard WHERE hostname = ? AND cardtype = ? Bindings were: :CARDTYPE=DVB, :HOSTNAME=M2N Driver error was [2/1210]: QMYSQL3: Unable to execute statement Database error was: Incorrect arguments to mysqld_stmt_execute

2009-11-18 22:52:49.660 DB Error (SimpleDBStorage::Save() update): Query was: UPDATE capturecard SET cardid = ?, dvb_eitscan = ? WHERE cardid = ?; Bindings were: :SETCARDID=2, :SETDVB_EITSCAN=0, :WHERECARDID=2 Driver error was [2/1210]: QMYSQL3: Unable to execute statement Database error was: Incorrect arguments to mysqld_stmt_execute

Please let me know what other information I can provide.

Change History (3)

comment:1 Changed 14 years ago by pyther@…

This might be a distro packaging bug: ​http://bbs.archlinux.org/viewtopic.php?pid=657860#p657860

I don't know enough about mysql + myth so I'm not sure how to track this down further. Any help would be appreciated.

comment:2 Changed 14 years ago by sphery

Resolution: → duplicate
Status: new → closed

Dup of #6683 (and, yes, it's a distro/packaging bug).

comment:3 Changed 14 years ago by pyther@…

What needs to be done to fix this then? I am really kinda lost here.

Note: See TracTickets for help on using tickets.