[mythtv] schema update problem with SVN 11777

Ross Campbell ross.campbell at gmail.com
Sun Nov 19 03:13:19 UTC 2006


After upgrading from SVN of about two weeks ago to today's SVN 11777,
I get the following error when starting mythfrontend when trying to
upgrade from schema 1167 to 1168. Can anyone help?

-Ross


[root at mythtv .mplayer]# mythfrontend&
[1] 9615
[root at mythtv .mplayer]# 2006-11-18 19:08:27.822 Using runtime prefix = /usr
2006-11-18 19:08:27.850 DPMS is disabled.
2006-11-18 19:08:27.864 New DB connection, total: 1
2006-11-18 19:08:27.868 Connected to database 'mythconverg' at host: localhost
2006-11-18 19:08:27.871 Total desktop dim: 1024x768, with 1 screen[s].
2006-11-18 19:08:27.877 Using screen 0, 1024x768 at 0,0
2006-11-18 19:08:27.909 Current Schema Version: 1167
2006-11-18 19:08:27.910 Newest Schema Version : 1168
2006-11-18 19:08:27.911 New DB connection, total: 2
2006-11-18 19:08:27.913 Connected to database 'mythconverg' at host: localhost
2006-11-18 19:08:27.914 Setting Lock for Database Schema upgrade. If
you see a long pause here it means the Schema is already locked and is
being upgraded by another Myth process.
2006-11-18 19:08:27.915 New DB connection, total: 3
2006-11-18 19:08:27.920 Connected to database 'mythconverg' at host: localhost
2006-11-18 19:08:27.922 Upgrading to schema version 1168
2006-11-18 19:08:27.925 DB Error (Performing database upgrade):
Query was: CREATE TABLE IF NOT EXISTS dvdbookmark (   serialid
varchar(16) NOT NULL default '',   name varchar(32) default NULL,
title smallint(6) NOT NULL default 0,   audionum tinyint(4) NOT NULL
default -1,   subtitlenum tinyint(4) NOT NULL default -1,   framenum
bigint(20) NOT NULL default 0,   timestamp timestamp NOT NULL default
  CURRENT_TIMESTAMP,   PRIMARY KEY (serialid));
Error was: Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax near 'CURRENT_TIMESTAMP,
PRIMARY KEY (serialid))' at line 1

new version: 1168
2006-11-18 19:08:27.925 Database Schema upgrade FAILED, unlocking.
2006-11-18 19:08:27.925 Couldn't upgrade database to new schema, exiting.


More information about the mythtv-dev mailing list