From: Michael Schreckenbauer <grimlog@gmx.de>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] Mythtv problems
Date: Thu, 27 Oct 2011 00:53:13 +0200 [thread overview]
Message-ID: <4222185.FBQZVabzRX@pc> (raw)
In-Reply-To: <4EA88CC6.7000008@gmail.com>
Am Mittwoch, 26. Oktober 2011, 17:42:14 schrieb Michael Sullivan:
> On 10/26/11 17:32, Michael Schreckenbauer wrote:
> > So you did run mysql_upgrade and same as before? Some words about what
> > you did and some relevant output of the command (if any) wouldn't hurt
> > ;) Have you tried mysql_fix_privilege_tables? After that, you would
> > need to run the steps mentioned in the wiki again (I think), giving the
> > password you entered in myth-setup to the UPDATE command.
> >
> > Best,
> > Michael
>
> 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'
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> forum.phpbb_auth_access
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_auth_access`" or dump/reload to fix it!
> forum.phpbb_banlist
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_banlist`" or dump/reload to fix it!
> forum.phpbb_categories
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_categories`" or dump/reload to fix it!
> forum.phpbb_config
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_config`" or dump/reload to fix it!
> forum.phpbb_confirm
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_confirm`" or dump/reload to fix it!
> forum.phpbb_disallow
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_disallow`" or dump/reload to fix it!
> forum.phpbb_forum_prune
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_forum_prune`" or dump/reload to fix it!
> forum.phpbb_forums
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_forums`" or dump/reload to fix it!
> forum.phpbb_groups
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_groups`" or dump/reload to fix it!
> forum.phpbb_posts
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_posts`" or dump/reload to fix it!
> forum.phpbb_posts_text
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_posts_text`" or dump/reload to fix it!
> forum.phpbb_privmsgs
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_privmsgs`" or dump/reload to fix it!
> forum.phpbb_privmsgs_text
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_privmsgs_text`" or dump/reload to fix it!
> forum.phpbb_ranks
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_ranks`" or dump/reload to fix it!
> forum.phpbb_search_results
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_search_results`" or dump/reload to fix it!
> forum.phpbb_search_wordlist
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_search_wordlist`" or dump/reload to fix it!
> forum.phpbb_search_wordmatch
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_search_wordmatch`" or dump/reload to fix it!
> forum.phpbb_sessions
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_sessions`" or dump/reload to fix it!
> forum.phpbb_sessions_keys
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_sessions_keys`" or dump/reload to fix it!
> forum.phpbb_smilies
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_smilies`" or dump/reload to fix it!
> forum.phpbb_themes
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_themes`" or dump/reload to fix it!
> forum.phpbb_themes_name
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_themes_name`" or dump/reload to fix it!
> forum.phpbb_topics
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_topics`" or dump/reload to fix it!
> forum.phpbb_topics_watch
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_topics_watch`" or dump/reload to fix it!
> forum.phpbb_user_group
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_user_group`" or dump/reload to fix it!
> forum.phpbb_users
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_users`" or dump/reload to fix it!
> forum.phpbb_vote_desc
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_vote_desc`" or dump/reload to fix it!
> forum.phpbb_vote_results
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_vote_results`" or dump/reload to fix it!
> forum.phpbb_vote_voters
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_vote_voters`" or dump/reload to fix it!
> forum.phpbb_words
> error : Table upgrade required. Please do "REPAIR TABLE
> `phpbb_words`" or dump/reload to fix it!
> movies.also_available
> error : Table upgrade required. Please do "REPAIR TABLE
> `also_available`" or dump/reload to fix it!
> movies.do_not_watch
> error : Table upgrade required. Please do "REPAIR TABLE
> `do_not_watch`" or dump/reload to fix it!
> movies.movies_to_review
> error : Table upgrade required. Please do "REPAIR TABLE
> `movies_to_review`" or dump/reload to fix it!
> movies.reviews
> error : Table upgrade required. Please do "REPAIR TABLE `reviews`" or
> dump/reload to fix it!
> movies.to_do_list
> error : Table upgrade required. Please do "REPAIR TABLE `to_do_list`"
> or dump/reload to fix it!
> myFantasy.actions
> error : Table upgrade required. Please do "REPAIR TABLE `actions`" or
> dump/reload to fix it!
> myFantasy.allyAbilities
> error : Table upgrade required. Please do "REPAIR TABLE
> `allyAbilities`" or dump/reload to fix it!
> myFantasy.characters
> error : Table upgrade required. Please do "REPAIR TABLE `characters`"
> or dump/reload to fix it!
> myFantasy.class
> error : Table upgrade required. Please do "REPAIR TABLE `class`" or
> dump/reload to fix it!
> myFantasy.enemy
> error : Table upgrade required. Please do "REPAIR TABLE `enemy`" or
> dump/reload to fix it!
> myFantasy.enemyAbility
> error : Table upgrade required. Please do "REPAIR TABLE
> `enemyAbility`" or dump/reload to fix it!
> myFantasy.magic
> error : Table upgrade required. Please do "REPAIR TABLE `magic`" or
> dump/reload to fix it!
> myFantasy.party
> error : Table upgrade required. Please do "REPAIR TABLE `party`" or
> dump/reload to fix it!
> 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
> error : Table upgrade required. Please do "REPAIR TABLE
> `help_category`" or dump/reload to fix it!
> mysql.help_keyword
> error : Table upgrade required. Please do "REPAIR TABLE
> `help_keyword`" or dump/reload to fix it!
> mysql.help_relation
> error : Table upgrade required. Please do "REPAIR TABLE
> `help_relation`" or dump/reload to fix it!
> mysql.help_topic
> error : Table upgrade required. Please do "REPAIR TABLE `help_topic`"
> or dump/reload to fix it!
> 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
> error : Table upgrade required. Please do "REPAIR TABLE `time_zone`"
> or dump/reload to fix it!
> mysql.time_zone_leap_second
> error : Table upgrade required. Please do "REPAIR TABLE
> `time_zone_leap_second`" or dump/reload to fix it!
> mysql.time_zone_name
> error : Table upgrade required. Please do "REPAIR TABLE
> `time_zone_name`" or dump/reload to fix it!
> mysql.time_zone_transition
> error : Table upgrade required. Please do "REPAIR TABLE
> `time_zone_transition`" or dump/reload to fix it!
> mysql.time_zone_transition_type
> error : Table upgrade required. Please do "REPAIR TABLE
> `time_zone_transition_type`" or dump/reload to fix it!
> mysql.user OK
> mysql_cpp_data.images OK
> mysql_cpp_data.stock
> Error : Table 'mysql_cpp_data.stock' doesn't exist
> status : Operation failed
> 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
> mysqlcheck: Got error: 1102: Incorrect database name
> '#mysql50#mythconverg.bak' when selecting the database
> 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
> 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 OKcamille ~ #
> mysql_fix_privilege_tables
> This script updates all the mysql privilege tables to be usable by
> the current version of MySQL
>
> done
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
next prev parent reply other threads:[~2011-10-26 22:54 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 [this message]
2011-10-26 22:59 ` Michael Sullivan
2011-10-26 23:08 ` Michael Schreckenbauer
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=4222185.FBQZVabzRX@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