[mythtv-users] Current Trunk, mysql latin1 and gentoo oddities

[Michael T. Dean]

On 03/11/2009 02:31 PM, Michael T. Dean wrote:
> On 03/11/2009 11:56 AM, Wayde Milas wrote:
>> I'm hoping someone  can help me. I'm currently struggling to get an
>> initial mythconverg database setup for svn trunk. I'm getting the
>> following error:
>>
>> 2009-03-09 19:15:18.762 The database seems to be empty - not attempting
>> a backup
>> 2009-03-09 19:15:18.772 Newest Schema Version : 1232
>> 2009-03-09 19:15:18.773 Inserting MythTV initial database information.
>> 2009-03-09 19:15:18.773 New DB connection, total: 3
>> 2009-03-09 19:15:18.774 Connected to database 'mythconverg' at host:
>> localhost
>> 2009-03-09 19:15:18.774 Upgrading to schema version 1226
>> 2009-03-09 19:15:18.774 DB Error (Performing database upgrade):
>> Query was: ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8;
>> Error was: Driver error was [2/1295]:
>> QMYSQL3: Unable to prepare statement
>> Database error was:
>> This command is not supported in the prepared statement protocol yet
>>
>> new version: 1226
>> 2009-03-09 19:15:18.774 Database Schema upgrade FAILED, unlocking.
>> 2009-03-09 19:15:18.774 Couldn't upgrade database to new schema.
> It's actually a bug in Qt 4.5.0.  You can either run Qt 4.4.x or apply 
> a patch to Qt.  I have such a patch, but am still trying to create a 
> reproducible test case before uploading the patch/reporting the bug to 
> Qt's bug tracker.  I'll post more details once I get the bug reported.

I posted the patch/report to Qt's bug tracker, but I can't get a link 
(looks like the bug tracker is moderated, so it's waiting on approval or 
something--also means I can't post the test case I made for them :).

In the interim, you can apply a patch to Myth which works around the bug 
in the Qt MySQL driver.  See http://svn.mythtv.org/trac/ticket/6344 .

Mike