[mythtv-users] database upgrade fail: schema 1160 to 1244
jeff at jeffbryner.com
Wed Dec 9 04:40:38 UTC 2009
Just updated mythtv from 20 to 22 and am stuck on the database update.
Here's the error:
2009-12-08 20:24:31.875 DB Error (Performing database upgrade):
Query was: `/w
Error was: Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '`/w' at line 1
new version: 1170
2009-12-08 20:24:31.875 Database Schema upgrade FAILED, unlocking.
2009-12-08 20:24:31.875 Couldn't upgrade database to new schema
The odd character makes me think I may be a victim of the mysql
latin/utf collation bug (I'm gentoo), but I though skipping .21 and
moving to .22 would avoid that no?
Anyone recognize this as either a collation-related item or an
existing bug? I searched the archives to no avail..but I did find
other things I'm going to run into.
FWIW here's my mysql info:
mythtv # mysql -umythtv -p mythconverg -e 'status;'
mysql Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (x86_64) using readline 6.0
Connection id: 39
Current database: mythconverg
Current user: mythtv at localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.84-log Gentoo Linux mysql-5.0.84-r1
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 9 hours 5 min 4 sec
Thanks for any guidance!
More information about the mythtv-users