[mythtv-users] Re: database upgrade error in upgrade from mythtv .15.to .16

Vince Busam vince at busam.com
Mon Oct 25 03:40:23 UTC 2004


I'm trying to upgrade from .15 to .16 using Jarod's apt-get instructions but
am getting the error about duplicate column name 'lastmodified' when either
frontend or backend are started (upgrading to schema version 1051).

I'm trying to follow the instructions provided by jsalch on 9/20/04.  I've
tried to drop the lastmodified column numerous times both logged in as user
root and mythtv and using both root and mythtv in mysql.

Below is a sample where it looks like the column is removed but then it
comes back.  I can't figure out what is going on.  For db mythconverg the
mysql mythtv with the default password in /usr/share/mythtv/mysql.txt works
from the command line and it has all privileges, except grant.  I did a grep
for running processes with "myth" and none showed up.

Can anyone tell me what to do?  Or what is going on?

Thanks,
Vince

[root at a22g .mythtv]# mysql -u root -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3175 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> alter table recorded drop column lastmodified;
Query OK, 31 rows affected (0.00 sec)
Records: 31  Duplicates: 0  Warnings: 0

mysql> describe recorded;
+-------------+------------------+------+-----+---------------------+-------
+
| Field       | Type             | Null | Key | Default             | Extra
|
+-------------+------------------+------+-----+---------------------+-------
+
| chanid      | int(10) unsigned |      | PRI | 0                   |
|
| starttime   | datetime         |      | PRI | 0000-00-00 00:00:00 |
|
| endtime     | datetime         |      | MUL | 0000-00-00 00:00:00 |
|
| title       | varchar(128)     |      |     |                     |
|
| subtitle    | varchar(128)     |      |     |                     |
|
| description | text             |      |     |                     |
|
| category    | varchar(64)      |      |     |                     |
|
| hostname    | varchar(255)     |      |     |                     |
|
| bookmark    | varchar(128)     | YES  |     | NULL                |
|
| editing     | int(10) unsigned |      |     | 0                   |
|
| cutlist     | text             | YES  |     | NULL                |
|
| autoexpire  | int(11)          |      |     | 0                   |
|
| commflagged | int(10) unsigned |      |     | 0                   |
|
| recgroup    | varchar(32)      |      |     | Default             |
|
| recordid    | int(11)          | YES  |     | NULL                |
|
| seriesid    | varchar(12)      |      | MUL |                     |
|
| programid   | varchar(12)      |      | MUL |                     |
|
| filesize    | bigint(20)       |      |     | 0                   |
|
+-------------+------------------+------+-----+---------------------+-------
+
18 rows in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> describe recorded;
+--------------+------------------+------+-----+---------------------+------
-+
| Field        | Type             | Null | Key | Default             | Extra
|
+--------------+------------------+------+-----+---------------------+------
-+
| chanid       | int(10) unsigned |      | PRI | 0                   |
|
| starttime    | datetime         |      | PRI | 0000-00-00 00:00:00 |
|
| endtime      | datetime         |      | MUL | 0000-00-00 00:00:00 |
|
| title        | varchar(128)     |      |     |                     |
|
| subtitle     | varchar(128)     |      |     |                     |
|
| description  | text             |      |     |                     |
|
| category     | varchar(64)      |      |     |                     |
|
| hostname     | varchar(255)     |      |     |                     |
|
| bookmark     | varchar(128)     | YES  |     | NULL                |
|
| editing      | int(10) unsigned |      |     | 0                   |
|
| cutlist      | text             | YES  |     | NULL                |
|
| autoexpire   | int(11)          |      |     | 0                   |
|
| commflagged  | int(10) unsigned |      |     | 0                   |
|
| recgroup     | varchar(32)      |      |     | Default             |
|
| recordid     | int(11)          | YES  |     | NULL                |
|
| seriesid     | varchar(12)      |      | MUL |                     |
|
| programid    | varchar(12)      |      | MUL |                     |
|
| filesize     | bigint(20)       |      |     | 0                   |
|
| lastmodified | timestamp(14)    | YES  |     | NULL                |
|
+--------------+------------------+------+-----+---------------------+------
-+
19 rows in set (0.00 sec)

mysql>




More information about the mythtv-users mailing list