public inbox for gentoo-user@lists.gentoo.org
 help / color / mirror / Atom feed
From: Michael Schreckenbauer <grimlog@gmx.de>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] Mythtv problems
Date: Thu, 27 Oct 2011 01:08:46 +0200	[thread overview]
Message-ID: <1867301.kFsaRzJUYc@pc> (raw)
In-Reply-To: <4EA890E6.40104@gmail.com>

Am Mittwoch, 26. Oktober 2011, 17:59:50 schrieb Michael Sullivan:
> > So your mythtv-tables are ok afaics. you need to repair your php-bb
> > tables at some time, but that's a different topic.
> > From your other post I conclude, that connecting to the backend now
> > works, but you don't get a program listing. I'll answer there, to keep
> > things related together.
> > 
> > Best,
> > Michael
> 
> I spent some time repairing tables.  Does this look better?
> 
> camille ~ # mysql_upgrade -p
> Enter password:
> Looking for 'mysql' as: mysql
> Looking for 'mysqlcheck' as: mysqlcheck
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA
> DIRECTORY NAME
> Error: Incorrect database name '#mysql50#mythconverg.bak'

this looks strange. I have no idea what to do about this currently.

> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> myFantasy.actions                                  OK
> myFantasy.allyAbilities                            OK
> myFantasy.characters                               OK
> myFantasy.class                                    OK
> myFantasy.enemy                                    OK
> myFantasy.enemyAbility                             OK
> myFantasy.magic                                    OK
> myFantasy.party                                    OK
> mysql.columns_priv                                 OK
> mysql.db                                           OK
> mysql.event                                        OK
> mysql.func                                         OK
> mysql.general_log
> Error    : You can't use locks with log tables.
> status   : OK
> mysql.help_category                                OK
> mysql.help_keyword                                 OK
> mysql.help_relation                                OK
> mysql.help_topic                                   OK
> mysql.host                                         OK
> mysql.ndb_binlog_index                             OK
> mysql.plugin                                       OK
> mysql.proc                                         OK
> mysql.procs_priv                                   OK
> mysql.servers                                      OK
> mysql.slow_log
> Error    : You can't use locks with log tables.
> status   : OK
> mysql.tables_priv                                  OK
> mysql.time_zone                                    OK
> mysql.time_zone_leap_second                        OK
> mysql.time_zone_name                               OK
> mysql.time_zone_transition                         OK
> mysql.time_zone_transition_type                    OK
> mysql.user                                         OK
> mysql_cpp_data.images                              OK
> mysql_cpp_data.stock
> Error    : Table 'mysql_cpp_data.stock' doesn't exist
> status   : Operation failed

Dito.
I miss your php-bb tables here. Deleted? ;)

> mythconverg.archiveitems                           OK
> mythconverg.callsignnetworkmap                     OK
> mythconverg.capturecard                            OK
> mythconverg.cardinput                              OK
> mythconverg.channel                                OK
> mythconverg.channelgroup                           OK
> mythconverg.channelgroupnames                      OK
> mythconverg.channelscan                            OK
> mythconverg.channelscan_channel                    OK
> mythconverg.channelscan_dtv_multiplex              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.filemarkup                             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.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
> mysqlcheck: Got error: 1102: Incorrect database name
> '#mysql50#mythconverg.bak' when selecting the database

Same as at the beginning. Was there before your repair. I missed it somehow.

> mythconverg.music_smartplaylists                   OK
> mythconverg.music_songs                            OK
> mythconverg.music_stats                            OK
> mythconverg.mythlog                                OK
> mythconverg.mythweb_sessions                       OK
> mythconverg.netflix                                OK
> mythconverg.networkiconmap                         OK
> mythconverg.oldfind                                OK
> mythconverg.oldprogram                             OK
> mythconverg.oldrecorded                            OK
> mythconverg.people                                 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.tvchain                                OK
> mythconverg.tvosdmenu                              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
> FATAL ERROR: Upgrade failed

The rest looks ok to me.

Best,
Michael




  reply	other threads:[~2011-10-26 23:10 UTC|newest]

Thread overview: 38+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-10-26 14:23 [gentoo-user] Mythtv problems Michael Sullivan
2011-10-26 14:45 ` [gentoo-user] " Michael Sullivan
2011-10-26 18:20   ` Raffaele BELARDI
2011-10-26 16:07 ` [gentoo-user] " Neil Bothwick
2011-10-26 16:29   ` Michael Sullivan
2011-10-26 16:36     ` Mark Knecht
2011-10-26 18:31       ` Michael Sullivan
2011-10-26 19:03         ` Michael Sullivan
2011-10-26 19:05           ` Michael Sullivan
2011-10-26 19:45             ` Michael Sullivan
2011-10-26 19:51               ` Michael Sullivan
2011-10-26 20:01                 ` Michael Sullivan
2011-10-26 21:19               ` Michael Sullivan
2011-10-27 10:17                 ` Matt Harrison
2011-10-27  0:03         ` kashani
2011-10-27  0:15           ` Michael Sullivan
2011-10-26 18:46     ` Neil Bothwick
2011-10-26 20:08       ` Michael Sullivan
2011-10-26 21:25         ` Michael Sullivan
2011-10-26 21:46           ` Michael Schreckenbauer
2011-10-26 21:51             ` Michael Sullivan
2011-10-26 22:06               ` Michael Schreckenbauer
2011-10-26 22:14                 ` Michael Sullivan
2011-10-26 22:32                   ` Michael Schreckenbauer
2011-10-26 22:42                     ` Michael Sullivan
2011-10-26 22:53                       ` Michael Schreckenbauer
2011-10-26 22:59                         ` Michael Sullivan
2011-10-26 23:08                           ` Michael Schreckenbauer [this message]
2011-10-26 22:09               ` Michael Schreckenbauer
2011-10-26 22:30                 ` Michael Sullivan
2011-10-26 22:36                   ` Michael Schreckenbauer
2011-10-26 22:33                 ` Michael Sullivan
2011-10-26 22:58                   ` Michael Schreckenbauer
2011-10-26 23:10                     ` Michael Sullivan
2011-10-26 23:16                       ` Michael Schreckenbauer
2011-10-27  1:13                         ` [gentoo-user] Mythtv problems [SOLVED] Michael Sullivan
2011-10-27 10:08                           ` Michael Schreckenbauer
2011-10-26 22:44         ` [gentoo-user] Mythtv problems Neil Bothwick

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=1867301.kFsaRzJUYc@pc \
    --to=grimlog@gmx.de \
    --cc=gentoo-user@lists.gentoo.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox