[mythtv-users] MythArchive problem??? Table 'mythconverg.archiveitems' doesn't exist

[Joe Ripley]

On 5/23/07, A JM <vbtalent at gmail.com> wrote:
> Anyone know why this error shows and how to fix it?
>
>
> 2007-05-23 21:50:57.440 Upgrading to MythArchive schema version 1001
> 2007-05-23 21:50:57.441 DB Error (Performing database upgrade):
> Query was: ALTER TABLE archiveitems MODIFY size BIGINT UNSIGNED NOT NULL;
> Error was: Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table 'mythconverg.archiveitems' doesn't exist
>
> new version: 1001
> 2007-05-23 21:50:57.441 Couldn't upgrade database to new schema, exiting.
> 2007-05-23 21:50:57.442 Unable to initialize plugin 'mytharchive'.
> 2007-05-23 21:50:57.442 Unable to configure plugin 'mytharchive': not
> initialized
> 2007-05-23 21:50:58.519 Upgrading to MythArchive schema version 1001
> 2007-05-23 21:50:58.520 DB Error (Performing database upgrade):
> Query was: ALTER TABLE archiveitems MODIFY size BIGINT UNSIGNED NOT NULL;
> Error was: Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table 'mythconverg.archiveitems' doesn't exist
>
> new version: 1001
> 2007-05-23 21:50:58.520 Couldn't upgrade database to new schema, exiting.
> 2007-05-23 21:50:58.520 Unable to initialize plugin 'mytharchive'.
> 2007-05-23 21:50:58.520 Unable to configure plugin 'mytharchive': not
> initialized
> 2007-05-23 21:51:02.532 Upgrading to MythArchive schema version 1001
> 2007-05-23 21:51:02.532 DB Error (Performing database upgrade):
> Query was: ALTER TABLE archiveitems MODIFY size BIGINT UNSIGNED NOT NULL;
> Error was: Driver error was [2/1146]:
> QMYSQL3: Unable to execute query

Well, the archiveitems table doesn't exist in your mythconverg
database.  To fix it, you'll probably have to recreate the table.  Use
something like this to recreate the table:

USE mythconverg;
CREATE TABLE `archiveitems` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `type` set('Recording','Video','File') default NULL,
  `title` varchar(128) default NULL,
  `subtitle` varchar(128) default NULL,
  `description` text,
  `startdate` varchar(30) default NULL,
  `starttime` varchar(30) default NULL,
  `size` int(10) unsigned NOT NULL,
  `filename` text NOT NULL,
  `hascutlist` tinyint(1) NOT NULL default '0',
  `cutlist` text,
  PRIMARY KEY  (`intid`),
  KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
Joe Ripley
vitaminjoe at gmail.com