[mythtv-users] mytharchive table missing in DB on svn?

[Paul Harrison]

Stephen Hocking wrote:
> Hi,
>
> I recently upgraded my SVN and noticed that the MythArchive plugin was
> now enabled. However, when I go to mark the recording I wish to have
> archived, the console window tells me that the appropriate table does
> not exist in the DB. Does anyone have the appropriate bit of SQL
> floating about, or should I just wait a little while longer.
>
>
>     Stephen
>   
You don't say what table is missing I assume you mean the archiveitems 
table which should have been automatically created for you the first 
time you run the MythArchive plugin?

What value does the ArchiveDBSchemaVer setting in the settings table 
have? You can find out by using this query in mysql:
SELECT * FROM settings WHERE value = 'ArchiveDBSchemaVer';

Anyway if you delete the ArchiveDBSchemaVer setting then the next time 
the plugin is run the table will be recreated for you and all will be 
well :-)

Paul H.