[mythtv-users] Database upgrade problems with weather

[Tom Dexter]

On Sun, May 4, 2008 at 12:20 PM, J <jsweepstakes at gmail.com> wrote:

>
> I tired running that command but it told me that xprop cannot open that
> display (I'm sshed in and I cannot get the xserver to pass through a
> connection...)
>

If you enable X11Forwarding in sshd on the backend and then ssh in
using "ssh -X -Y" it'll work.

> the errors that the database outputs are:
> rb:~$ mysqlcheck -r -umythtv -p mythconverg
>  mythconverg.archiveitems                           OK
> mythconverg.callsignnetworkmap                     OK
> mythconverg.capturecard                            OK
> mythconverg.cardinput                              OK
>  mythconverg.channel                                OK
> mythconverg.codecparams                            OK
> mythconverg.credits                                OK
> mythconverg.customexample                          OK
>  mythconverg.diseqc_config                          OK
> mythconverg.diseqc_tree                            OK
> mythconverg.displayprofilegroups                   OK
> mythconverg.displayprofiles                        OK
>  mythconverg.dtv_multiplex                          OK
> mythconverg.dtv_privatetypes                       OK
> mythconverg.dvdbookmark                            OK
> mythconverg.dvdinput                               OK
>  mythconverg.dvdtranscode                           OK
> mythconverg.eit_cache                              OK
> mythconverg.favorites                              OK
> mythconverg.filemarkup                             OK
>  mythconverg.gallerymetadata                        OK
> mythconverg.gamemetadata                           OK
> mythconverg.gameplayers                            OK
> mythconverg.housekeeping                           OK
>  mythconverg.inputgroup                             OK
> mythconverg.inuseprograms                          OK
> mythconverg.jobqueue                               OK
> mythconverg.jumppoints                             OK
>  mythconverg.keybindings                            OK
> mythconverg.keyword                                OK
> mythconverg.movies_movies                          OK
> mythconverg.movies_showtimes                       OK
>  mythconverg.movies_theaters                        OK
> mythconverg.music_albumart                         OK
> mythconverg.music_albums                           OK
> mythconverg.music_artists                          OK
>  mythconverg.music_directories                      OK
> mythconverg.music_genres                           OK
> mythconverg.music_playlists                        OK
> mythconverg.music_smartplaylist_categories         OK
>  mythconverg.music_smartplaylist_items              OK
> mythconverg.music_smartplaylists                   OK
> mythconverg.music_songs                            OK
> mythconverg.music_stats                            OK
>  mythconverg.musicmetadata                          OK
> mythconverg.musicplaylist                          OK
> mythconverg.mythlog                                OK
> mythconverg.mythweb_sessions                       OK
>  mythconverg.netflix                                OK
> mythconverg.networkiconmap                         OK
> mythconverg.newssites                              OK
> mythconverg.oldfind                                OK
>  mythconverg.oldprogram                             OK
> mythconverg.oldrecorded                            OK
> mythconverg.people                                 OK
> mythconverg.phonecallhistory                       OK
>  mythconverg.phonedirectory                         OK
> mythconverg.pidcache                               OK
> mythconverg.playgroup                              OK
> mythconverg.powerpriority                          OK
>  mythconverg.profilegroups                          OK
> mythconverg.program                                OK
> mythconverg.programgenres                          OK
> mythconverg.programrating                          OK
>  mythconverg.recgrouppassword                       OK
> mythconverg.record                                 OK
> mythconverg.record_tmp                             OK
> mythconverg.recorded                               OK
>  mythconverg.recordedcredits                        OK
> mythconverg.recordedfile                           OK
> mythconverg.recordedmarkup                         OK
> mythconverg.recordedprogram                        OK
>  mythconverg.recordedrating                         OK
> mythconverg.recordedseek                           OK
> mythconverg.recordingprofiles                      OK
> mythconverg.recordmatch                            OK
>  mythconverg.romdb                                  OK
> mythconverg.schemalock                             OK
> mythconverg.settings                               OK
> mythconverg.storagegroup                           OK
>  mythconverg.streams                                OK
> mythconverg.tvchain                                OK
> mythconverg.upnpmedia                              OK
> mythconverg.videocast                              OK
>  mythconverg.videocategory                          OK
> mythconverg.videocountry                           OK
> mythconverg.videogenre                             OK
> mythconverg.videometadata                          OK
>  mythconverg.videometadatacast                      OK
> mythconverg.videometadatacountry                   OK
> mythconverg.videometadatagenre                     OK
> mythconverg.videosource                            OK
>  mythconverg.videotypes                             OK
> mythconverg.weatherdatalayout
> note     : The storage engine for the table doesn't support repair
> mythconverg.weatherscreens
> note     : The storage engine for the table doesn't support repair
>  mythconverg.weathersourcesettings
> note     : The storage engine for the table doesn't support repair
> mythconverg.websites                               OK
>
>
> I don't think this will help much through?
>  -J
>

Those errors about the weather tables are normal, as innodb tables
don't aren't supported by that repair command.

Tom