[mythtv] schema update problem with SVN 11777
Chris Pinkham
cpinkham at bc2va.org
Sun Nov 19 04:35:05 UTC 2006
* On Sat Nov 18, 2006 at 07:13:19PM -0800, Ross Campbell 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?
> 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));
> You have an error in your SQL syntax near 'CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP is not MySQL 3.x compatible. I removed the "default
CURRENT_TIMESTAMP" in SVN. Can you re-update and try again?
--
Chris
More information about the mythtv-dev
mailing list