[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