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

Changed theme, Setup menu choice disappeared?
http://forum.linhes.org/viewtopic.php?f=11&t=6428		 Page 1 of 1
Author:  haertig [ Thu Oct 13, 2005 7:02 pm ]
Post subject:  Changed theme, Setup menu choice disappeared?
Now I've gotten myself into a pickle. Because the text in various selection screens wasn't lining up with the highlights for me, I thought I'd try some different themes included with KnoppMyth to see if they were better. Most were no better.

Then I tried "Minimalist something-or-other theme" (I think!) and now I have no menu choice for Setup anymore. I want to get out of this theme, but without Setup I have no idea how to. Is there some file I can edit to get myself back to the default Blue theme? Barring that, is there some magic keystroke incantation/shortcut to get me directly to Setup->Appearance? BTW, the KnopMyth menu choise that was there in Blue is missing now as well. Maybe others too - I don't remember all the old menu choices I used to have off the top of my head.
Author:  tjc [ Thu Oct 13, 2005 8:35 pm ]
Post subject: 
Search for a post by me which mentions "theme" "settings" and "sql". It has directions on how to do this.
Author:  haertig [ Thu Oct 13, 2005 9:00 pm ]
Post subject: 
tjc wrote:
Search for a post by me which mentions "theme" "settings" and "sql". It has directions on how to do this.
Ok, I found your earlier post. I can handle delete and insert statements. Now I have an even more basic (and newbie) question. I'm fine running direct SQL, using Informix and Oracle on many Unix boxes for years. But I'm unfamiliar with MySQL. So far I've gotten in partly, but not to a database.

I ran "mysql -h localhost -u mythtv -p"
It prompted me for a password and I got in using "mythtv"
Now I think I need to access a specific database, I believe using "connect" or "use"
But I don't know a database name. Guessing "mythtv" as a DB name didn't work.

Once I get to a prompt where I can run something like "describe settings;" I'll be in good shape (I think). But how do I get there? Your previous post said "Click on the Execute SQL button". Huh? What button? I'm at the Linux command line. Is this within the Myth frontend? Where? Maybe under some advanced settings or something (I might guess), but I don't have a Settings menu item.

Man I feel stupid right now. Can't even get into the friggin' database to run some simple SQL. I'm hopeless!
Author:  tjc [ Thu Oct 13, 2005 9:23 pm ]
Post subject: 
As root you can do:
Code:
mysql mythconverg -e "insert baloon into pot"

Or:
Code:
mysql mythconverg <commands.sql

or any of a number of variations. As a ordinary user you can say:
Code:
mysql -u mythtv -p mythtv mythconverg <<EOF
delete from gifts where desc = 'pot of honey' or desc = 'inflated baloon';
insert into gifts ('empty pot')
insert into gifts ('broken baloon');
EOF

Note that "localhost" is the assumed default. Finally you can issue the SQL commands using the webmin interface as was discussed further up that thread.
Author:  Xsecrets [ Thu Oct 13, 2005 9:25 pm ]
Post subject: 
the database name is mythconverg but if you are using mysql command line there is no clicking. if someone mentioned clicking they were probably talking about in webmin. for more info on webmin check the wiki.

also for getting out of a wide theme on a regular tv I thought there was a post about being able to use the pgdown or pgup keys to see what you need to change it. you might want to search the forum for that, as it would be easier than changing the database directly.
Author:  haertig [ Thu Oct 13, 2005 9:41 pm ]
Post subject: 
Thanks both tjc and Xsecrets! It was a most trivial exercise once you guys forwarded the database name to me. I first ran "update settings set data = 'Blue' where value = 'Theme';" The frontend wouldn't start (probably it's not "Blue", but rather "blue" ... whatever) Anyway, I used "Iulius" and that got the frontend going again and from there I was able to use the regular frontend GUI to set things back to Blue.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/