[mythtv-users] Setup problem with MythTV 0.18

[Jerome Rannikko]

Hi all!
I was just installing MythTV but a problem occured when trying to run
mythtv-setup. The database and the mythtv user were created fine w/ the
mc.sql script but running mythtv-setup produced the following output:

2005-04-26 15:32:10.344 Unable to read configuration file mysql.txt
2005-04-26 15:32:10.345 Writing settings file
/home/jerome/.mythtv/mysql.txt
2005-04-26 15:32:10.354 New DB connection, total: 1
Total desktop width=1280, height=1024, numscreens=1
2005-04-26 15:32:10.359 Using screen 0, 1280x1024 at 0,0
2005-04-26 15:32:10.372 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.
2005-04-26 15:32:10.373 New DB connection, total: 2
2005-04-26 15:32:10.375 Inserting MythTV initial database information.
2005-04-26 15:32:10.376 New DB connection, total: 3
2005-04-26 15:32:10.377 Upgrading to schema version 1060
2005-04-26 15:32:10.421 DB Error (Performing database upgrade):
Query was: CREATE TABLE IF NOT EXISTS conflictresolutionoverride (  chanid
int(10) unsigned NOT NULL default '0',  starttime timestamp(14) NOT NULL,
endtime timestamp(14) NOT NULL default '00000000000000',  KEY chanid
(chanid,starttime),  KEY endtime (endtime));
Error was: Driver error was [2/1067]: QMYSQL3: Unable to execute query
Database error was: Invalid default value for 'endtime'

As a result only tables callsignnetworkmap, capturecard, cardinput,
channel, codecparams, conflictresolutionany, and schemalock got created in
the database. This causes mythbackend and mythfilldatabase to fail when
trying to run them after setup.

Has anyone had similar problems and/or know how to fix this? I installed
MythTV from ATrpms.

//jerome


-- 
       /\     Jerome.Rannikko at REMOVE.tut.fi	 GSM +358 40 8021 982
   \  /  \
    ><    >   "Some see the glass half full, some see the glass half empty
   /  \  /     and some birds don't see the glass at all."
       \/      					-- Unknown Philosopher