[mythtv-users] Need help with MythArchive and MySQL
Keith Richie
disturbed1976 at gmail.com
Mon Apr 6 21:32:11 UTC 2009
On 4/6/09, Michael Drons <mdrons at yahoo.com> wrote:
>
> ----- Original Message ----
>
> From: Keith Richie <disturbed1976 at gmail.com>
> To: mythtv-users at mythtv.org
> Sent: Monday, April 6, 2009 5:41:25 AM
> Subject: [mythtv-users] Need help with MythArchive and MySQL
>
> I'm using trunk (20306) and am getting errors starting mythfrontend
>
>
>
>
>
> The issue is the character set that is used. The default from myth is utf8
> now. I believe the way I
> got around this issue was to backup the table and then drop it. Allow
> the upgrade to happen and then run a query and insert to move the data
> back in, changing the charset. Search the dev list there was discussion on
> this awhile back.
>
> Mike
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Thanks for the reply.
Do you happen to have that link. My search results only turned up the
QT 4.5 error which was already fixed in
mythtv/libs/libmythtv/dbcheck.cpp
Hacking on mytharchive/dbcheck.cpp -works without fussing around with
char sets.
Of course all plugins that have in dbcheck.cpp
while (thequery != "")
{
query.exec(thequery);
if (query.lastError().type() != QSqlError::None)
Fail.
Adapting http://svn.mythtv.org/trac/attachment/ticket/6344/mythtv-6344-workaround_for_Qt_4_5_lastError_bug.patch
fixes the issue.
More information about the mythtv-users
mailing list