LinHES Forums
http://forums.linhes.org/

Problems upgrading to .16
http://forums.linhes.org/viewtopic.php?f=6&t=2491		 Page 1 of 1
Author:  Dinki [ Fri Sep 24, 2004 7:10 pm ]
Post subject:  Problems upgrading to .16
Sigh!

I ran mythbackup as instructed. I attempted to upgrade using the iso with autoupgrade. All goes well until the setup wants to run 'mythtv-setup' . This bombs. I tried running it from an xterm and this is the output I'm getting:

mythtv@mythtv$ mythtv-setup
2004-09-25 00:05:54 Upgrading to schema version 1051
DB Error (Performing database upgrade):
Query was:
ALTER TABLE recorded ADD COLUMN lastmodified TIMESTAMP NOT NULL;
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'lastmodified'


I can access mysql using 'mysql -u mythtv -p' with password of 'mythtv' and look at the different databases/tables/etc ..

Anyone have any ideas on this? Any help is greatly appreciated.
Author:  mgrassi99 [ Fri Sep 24, 2004 7:19 pm ]
Post subject: 
I'm having the EXACT same problem.

Thank you for making me feel a little better ;)

-Mike
Author:  Dinki [ Fri Sep 24, 2004 7:23 pm ]
Post subject: 
Misery loves company! Hopefully someone will be able to shed some light on this.
Author:  tjc [ Fri Sep 24, 2004 7:28 pm ]
Post subject: 
Basically it's falling over because the change has already been made. If you're feeling brave you can delete that column and retry the update. However I don't remember off the top of my head it it wants "drop", "delete" or "remove" in place of the add to do that...
Author:  mgrassi99 [ Fri Sep 24, 2004 7:47 pm ]
Post subject: 
...and here's a fix...

Go to webmin, go to the mythconverg DB and open the "recorded" table. Click on the "lastmodified" item and delete it and then the "filesize" item and delete it, then restart your mythtv-setup on your backend. Seems to have fixed it over here.
Author:  Dinki [ Fri Sep 24, 2004 8:22 pm ]
Post subject: 
Well that definitely helped. I can get in the gui now! Thanks!
Author:  tjc [ Fri Sep 24, 2004 8:28 pm ]
Post subject: 
For anyone who is interested I'll be posting a walk through on the deb upgrade shortly. Tomorrow morning-ish I'll try to take the plunge and do the full autoupdate and write that up as well.

EDIT - That walk through can be found here: http://mysettopbox.tv/phpBB2/viewtopic.php?t=2495
Author:  scottf [ Fri Sep 24, 2004 11:32 pm ]
Post subject: 
Two things I had difficulties with...

first the update site for sources was listed wrong...

it should be:

Code:
deb http://knoppmyth.geekweb.net/updates ./
not
deb http://knoppmyth.geekweb/ipdates ./


secondly I had an issue with mythlib being installed (might have been due to stuff I'd done to the box, but I had to force the install of mythtv-i686-lirc to finish things...
Author:  Charles [ Sat Sep 25, 2004 11:33 am ]
Post subject: 
scottf wrote:
secondly I had an issue with mythlib being installed (might have been due to stuff I'd done to the box, but I had to force the install of mythtv-i686-lirc to finish things...


How did you do this? It may be the problem that I am having....
Author:  scottf [ Sat Sep 25, 2004 12:04 pm ]
Post subject: 
when you type apt-get -f install, you'll get the full path of the file name...

I generally change directory into the apt cache archive folder and then install from there... but you don't have to do this. I don't have the deb on my system any longer as I was dealing with other issues, but the

the basic installation command is something like the command below:

Code:
dpkg --install --force overwrite mythtv-i686-lirc.deb


(this can be found elsewhere in this forum I think I originally saw it under the ogle/xine installation thread)
Author:  lynchaj [ Sun Sep 26, 2004 10:10 am ]
Post subject: 
mgrassi99 wrote:
...and here's a fix...

Go to webmin, go to the mythconverg DB and open the "recorded" table. Click on the "lastmodified" item and delete it and then the "filesize" item and delete it, then restart your mythtv-setup on your backend. Seems to have fixed it over here.


I am having this exact problem. Would you be so kind as to detail your exact steps on how to accomplish this feat? I am in webmin and do not see the mythconverg DB. Help!

Thanks!

Andrew Lynch
Author:  Xsecrets [ Sun Sep 26, 2004 10:33 am ]
Post subject: 
you'll have to go to the mysql part first.
Author:  mgrassi99 [ Mon Sep 27, 2004 10:53 pm ]
Post subject: 
Go to the servers tab, then mysql, then click on mythconverg. BTW, I only felt comfortable editing the DB since I knew I still had my original DB backed up, and actually did have to restore it again once after editing something that I should not have...I suggest you have it handy as well!
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/