[mythtv-users] mysql 5

[Andrew Lyon]

> 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

I'm running gentoo, I have mysql in my use flags so qt is built with
support for mysql, I bet what I need to do is re-emerge qt once mysql
is upgraded.

I will give that a try when I have time (or am forced to upgrade
mysql), for now ive just masked v5 so that it doesnt get upgraded
again.

Andy