[mythtv-users] mysql 5

[jack snodgrass]

On 11/6/06, Andrew Lyon <andrew.lyon at gmail.com> wrote:
> Hi,
>
> I take it mythtv doesnt work with mysql5? v5 has just been marked as
> stable in gentoo portage and got upgraded on my box this morning, I
> got the following errors when starting the backend:
>
> 2006-11-06 15:06:59.700 Using runtime prefix = /usr
> QSqlDatabase: QMYSQL3 driver not loaded
> QSqlDatabase: available drivers:
> 2006-11-06 15:06:59.716 New DB connection, total: 1
> 2006-11-06 15:06:59.716 Unable to connect to database!
> 2006-11-06 15:06:59.716 No error type from QSqlError?  Strange...
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2006-11-06 15:06:59.781 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-11-06 15:06:59.851 Failed to init MythContext, exiting.
>
> Luckily the upgrade doesnt seem to have changed the format of the
> database files on disk, I was able to downgrade mysql and everything
> is working again, which is nice as I had just spent a hour tweaking
> some things in the myth db and I would have lost those changes if I
> had to restore the db from a backup.
>
> Andy

I have Mysql V5 on Fedora and mythtv works fine with it.
Not sure if it was the .19 or .20 version that added support
for v5.... your bug seems more like what I recall getting
when I didn't have the qt-MySQL package installed.
I recall a couple of rpms that would install just fine, but
not run unless qt-MySQL was also installed. The dependency
checker must not have had it listed.....  do you have that  qt-MySQL
package installed?

jack