View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 8 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: Menus gone blank
PostPosted: Sun Nov 11, 2007 3:50 pm 
Offline
Joined: Sun Mar 21, 2004 10:48 am
Posts: 43
Location: SF Bay Area
My R5F27 upgrade had been working fine for over a month when this problem started. Starting about 1 1/2 weeks ago I get a black screen in any of the menus. If I navigate to the recorded programs screen by dead reconing, I can see that screen. I can also watch recordings fine*. I ctrl-alt-shift-f1 and get the text console just fine. I've searched a lot of log files for some kind of error messages that might indicate what's going on, but I've found nothing that looks relevant maybe I'm not looking in the right place.

I tried connecting via vnc on the assumption that it might be a TV-out problem. VNC shows a black screen in the same places tho.

I also tried changing the theme using these instructions on the assumption that my theme bitmaps got corrupted. No difference except that the theme has changed on the screens that I can get to.

I suspect that my kids somehow got into the settings menu and changed some setting that made menus not work anymore. I haven't been able to get to the settings menu area, either because I miss it by dead reconing or because it is also blank, so I have no easy way to experiment with what setting might have caused this. I have looked at the settings table in mysql, but I can't see any setting that looks like is could have caused this.

Does anyone have any suggestions? Does anyone know what settings could cause this? If you do I can just jam the right value into the settings table.

* One other thing: around the same time this happen all my recorded shows started having no audio. I assume this is another thing that my kids got into that is not related but I'm mentioning it here just in case it is related.

_________________
R5F27 on:
Athlon 1800+
Asus A7N8X-VM 400, 512mb
Onboard video through Asus dongle
80G Hitachi HD
Hauppauge! WinTV 401


Top
 Profile  
 
 Post subject:
PostPosted: Sun Nov 11, 2007 4:27 pm 
Offline
Joined: Sun Jun 12, 2005 2:39 pm
Posts: 464
Location: UK
If you were to rename the settings table in the database, would it create a new one with the defaults?

If it does, you could try that and see if the menus come back.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Nov 11, 2007 7:14 pm 
Offline
Joined: Sun Mar 21, 2004 10:48 am
Posts: 43
Location: SF Bay Area
Sounds interesting... Do you know for sure that if the settings table isn't there, that myth resets it with the defaults? Could this make things worse?

_________________
R5F27 on:
Athlon 1800+
Asus A7N8X-VM 400, 512mb
Onboard video through Asus dongle
80G Hitachi HD
Hauppauge! WinTV 401


Top
 Profile  
 
 Post subject:
PostPosted: Sun Nov 11, 2007 7:49 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Don't do that. It'll cause other problems. However you can try reapplying the KnoppMyth standard setup stuff.
Code:
{ echo "delete from settings;"
grep 'INSERT INTO `settings`' /usr/local/share/knoppmyth/KnoppMyth.sql |
sed "s/MythTVhost/$(hostname)/"
} | mysql -u root mythconverg

If you don't cut and paste that be _VERY_ careful about the quotes used. Single quotes _around_ the grep string, backquotes inside of it to match what is in the mysql statements, and doublequotes around the sed string.

If that doesn't cure your problem, I'd guess that you're missing theme and menu XML files. Doing a good backup and auto-upgrade as described in the R5F27 hints is probably indicated.

BTW - You can lock down the setup menus with a pin code to keep this kind of thing from happening...


Last edited by tjc on Wed Nov 14, 2007 8:25 pm, edited 1 time in total.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 12, 2007 11:43 am 
Offline
Joined: Sun Mar 21, 2004 10:48 am
Posts: 43
Location: SF Bay Area
Pretty crafty shell calisthenics there tjc! Thanks - I'll give that a try when I get back from work today.

_________________
R5F27 on:
Athlon 1800+
Asus A7N8X-VM 400, 512mb
Onboard video through Asus dongle
80G Hitachi HD
Hauppauge! WinTV 401


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 12, 2007 6:50 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Let me also recommend doing regular backups using the built-in script so that if something like this happens again you restore your settings from that. Between the regular use of the configuration backup script and keeping a copy of the install CD handy the average user should be able to recover anything but deleted content. I'm not talking about anything strenuous, just using the backup option in the GUI whenever you think of it and the box has 10-15 minutes of idle time.

"Taking advantage of the enhanced backup and restore scripts"


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 14, 2007 10:12 am 
Offline
Joined: Sun Mar 21, 2004 10:48 am
Posts: 43
Location: SF Bay Area
Yep that brought back my menus. Thanks!

_________________
R5F27 on:
Athlon 1800+
Asus A7N8X-VM 400, 512mb
Onboard video through Asus dongle
80G Hitachi HD
Hauppauge! WinTV 401


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 01, 2007 11:33 am 
Offline
Joined: Sun Mar 21, 2004 10:48 am
Posts: 43
Location: SF Bay Area
Hey - I've been meaning to follow up, but I've just been crazy busy lately. tjc the mysql settings reset fixed the menu problem but now I'm seeing another problem that seems related. When I hit my mythbox with a web browser, the main index page comes up fine, but when I go into MythWeb, I get the following:

Quote:
Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php, line 73:
SQL Error: Table 'mythweb_sessions' already exists [#1050]

If you choose to submit a bug report, please make sure to include a
brief description of what you were doing, along with the following
backtrace as an attachment (please don't paste the whole thing into
the ticket).
Backtrace:
datetime: 2007-12-01 09:34:50 (PST)
errornum: 256
error type: User Error
error string: SQL Error: Table 'mythweb_sessions' already exists [#1050]
filename: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
error line: 73

==========================================================================

Backtrace:

file: /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php
line: 73
class:
function: trigger_error
type:
args: Array
(
[0] => SQL Error: Table 'mythweb_sessions' already exists [#1050]
[1] => 256
)

file: /usr/share/mythtv/mythweb/includes/objects/Database.php
line: 220
class: database_query_mysql
function: execute
type: ->
args: Array
(
[0] => Array ( )
)


It looks like mythweb thinks this is a new instalation and it needs to create that table.

_________________
R5F27 on:
Athlon 1800+
Asus A7N8X-VM 400, 512mb
Onboard video through Asus dongle
80G Hitachi HD
Hauppauge! WinTV 401


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 13 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