[mythtv-users] Corrupt/missing weather DB tables

[Nick Rout]

Here is what was asked for (I hope). This is on 0.21 (mythbuntu)

Current database: mythconverg

mysql> describe weatherdatalayout
   -> ;
+--------------------------------+------------------+------+-----+---------+-------+
| Field                          | Type             | Null | Key |
Default | Extra |
+--------------------------------+------------------+------+-----+---------+-------+
| location                       | varchar(64)      | NO   | PRI |
NULL    |       |
| dataitem                       | varchar(64)      | NO   | PRI |
NULL    |       |
| weatherscreens_screen_id       | int(10) unsigned | NO   | PRI |
NULL    |       |
| weathersourcesettings_sourceid | int(10) unsigned | NO   | PRI |
NULL    |       |
+--------------------------------+------------------+------+-----+---------+-------+
4 rows in set (0.04 sec)

mysql> describe weatherscreens;
+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| screen_id | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| draworder | int(10) unsigned    | NO   |     | NULL    |                |
| container | varchar(64)         | NO   |     | NULL    |                |
| hostname  | varchar(255)        | YES  |     | NULL    |                |
| units     | tinyint(3) unsigned | NO   |     | NULL    |                |
+-----------+---------------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

mysql> describe weathersourcesettings;
+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| sourceid         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| source_name      | varchar(64)      | NO   |     | NULL    |                |
| update_timeout   | int(10) unsigned | NO   |     | 600     |                |
| retrieve_timeout | int(10) unsigned | NO   |     | 60      |                |
| hostname         | varchar(255)     | YES  |     | NULL    |                |
| path             | varchar(255)     | YES  |     | NULL    |                |
| author           | varchar(128)     | YES  |     | NULL    |                |
| version          | varchar(32)      | YES  |     | NULL    |                |
| email            | varchar(255)     | YES  |     | NULL    |                |
| types            | mediumtext       | YES  |     | NULL    |                |
+------------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

On Thu, May 22, 2008 at 6:07 PM, Michael Jones
<michael at michaelandholly.com> wrote:
>
> On May 21, 2008, at 9:54 PM, Chuck Filson wrote:
>
>> On May 21, 2008 11:56:59 pm Dusty Herrman wrote:
>>> I just had a power surge and it looks like I have some corrupted/
>>> missing
>>> DB tables.  Can someone please give me the descriptions of the tables
>>> (and maybe some of the data in them)?
>>>
>>> The tables are: weatherdatalayout, weatherscreens, and
>>> weathersourcesettings.
>>>
>>> Thanks in advance
>>
>>       Backup your database first ... then try the following.
>>
>>       Delete the value of "WeatherDBSchemaVer" in the database and also
>> delete
>> those three tables, then MythWeather should create and update the
>> tables the
>> next time it runs.
>>
>> Chuck
>
> For some reason mine did the same thing at one time.. I found the
> database definitions either on the list archive or just through a
> google search on the name of the table.. (can't remember)..
>
> Sorry... I didn't keep the file..
>
>
> - Michael
>
>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>