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

Wayde Milas wmilas at rarcoa.com
Wed Mar 11 15:56:13 UTC 2009


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.


I read a thread a while back stating that mysql was configured wrong
during compile (in gentoo) and that it left the latin1 flag out. I've
re-compiled with the latin1 flag in. I've also gone into my.cnf and
changed all the utf8 references to latin1. Still no dice.

Any idea whats going wrong here? I'm guessing it has something to do
with character encoding but I can't figure out what...

Thanks much,

Wayde


More information about the mythtv-users mailing list