View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 13 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri Sep 24, 2004 7:10 pm 
Offline
Joined: Fri Dec 26, 2003 2:25 pm
Posts: 244
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.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 7:19 pm 
Offline
Joined: Wed Jan 28, 2004 12:04 am
Posts: 68
I'm having the EXACT same problem.

Thank you for making me feel a little better ;)

-Mike


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 7:23 pm 
Offline
Joined: Fri Dec 26, 2003 2:25 pm
Posts: 244
Misery loves company! Hopefully someone will be able to shed some light on this.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 7:28 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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...


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 7:47 pm 
Offline
Joined: Wed Jan 28, 2004 12:04 am
Posts: 68
...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.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 8:22 pm 
Offline
Joined: Fri Dec 26, 2003 2:25 pm
Posts: 244
Well that definitely helped. I can get in the gui now! Thanks!


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 8:28 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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


Last edited by tjc on Fri Sep 24, 2004 11:39 pm, edited 1 time in total.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 24, 2004 11:32 pm 
Offline
Joined: Sat May 22, 2004 1:42 pm
Posts: 49
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...


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 11:33 am 
Offline
Joined: Mon Mar 01, 2004 12:51 pm
Posts: 61
Location: NYC
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....

_________________
MBE:
Chaintech 7NIF2
AMD Athlon XP 2500+
Samsung 160 GB
Hauppauge PVR-250
Knoppmyth R4V4.1

SBE:
TBA


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 25, 2004 12:04 pm 
Offline
Joined: Sat May 22, 2004 1:42 pm
Posts: 49
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)


Top
 Profile  
 
 Post subject:
PostPosted: Sun Sep 26, 2004 10:10 am 
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


Top
  
 
 Post subject:
PostPosted: Sun Sep 26, 2004 10:33 am 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
you'll have to go to the mysql part first.

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 27, 2004 10:53 pm 
Offline
Joined: Wed Jan 28, 2004 12:04 am
Posts: 68
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!


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu