[mythtv-users] Problems on backend Scheme ???

Per Jørgensen myth at pbj-design.dk
Sun Jun 21 19:30:28 UTC 2009


Hey Guys.

I ended up with a corrupt database - which ended in a total reinstall.
I'm using ArchLinux as an backend and running mythtv-svn rev. 20138
Although I reinstalled precompiled packages - I'm ending up with this 
error each time I'm starting the backend from scratch a fresh new database:

2009-06-21 21:23:14.544 mythbackend version: trunk [20138:20731M] 
www.mythtv.org
2009-06-21 21:23:14.549 Using runtime prefix = /usr
2009-06-21 21:23:14.558 New DB connection, total: 1
2009-06-21 21:23:14.564 Closing DB connection named 'DBManager0'
2009-06-21 21:23:14.568 New DB DataDirect connection
2009-06-21 21:23:14.572 Database schema is old. Waiting to see if DB is 
being upgraded.
2009-06-21 21:23:15.573 New DB connection, total: 2
2009-06-21 21:23:19.588 Timed out waiting.
2009-06-21 21:23:19.601 Newest Schema Version : 1232
2009-06-21 21:23:19.604 Inserting MythTV initial database information.
2009-06-21 21:23:19.605 New DB connection, total: 3
2009-06-21 21:23:19.608 Upgrading to schema version 1226
2009-06-21 21:23:19.609 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-06-21 21:23:19.610 Database Schema upgrade FAILED, unlocking.
2009-06-21 21:23:19.611 Couldn't upgrade database to new schema
^C

When trying to to run mythtv setup - it results in a crash - and no data 
are being stored. Cannot change the master backend IP.
I don't know how to get through this scheme problem - a've struckled for 
new 4days.

P


More information about the mythtv-users mailing list