[mythtv] schema update problem with SVN 11777
Ross Campbell
ross.campbell at gmail.com
Sun Nov 19 04:06:22 UTC 2006
researching my own problem...
I'm running mysql 3.23.58
MySQL 3 does not support 'default CURRENT_TIMESTAMP on update CURRENT
TIMESTAMP' with the table definition.
So... everyone be warned - SVN 11777 BREAKS mythtv for anyone running MySQL 3.X
I would file a bug in TRAC... how do I get an account?
On 11/18/06, Ross Campbell <ross.campbell at gmail.com> wrote:
> 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?
>
> 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.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