From: Michael Sullivan <msulli1355@gmail.com>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] Mythtv problems
Date: Wed, 26 Oct 2011 17:59:50 -0500 [thread overview]
Message-ID: <4EA890E6.40104@gmail.com> (raw)
In-Reply-To: <4222185.FBQZVabzRX@pc>
On 10/26/11 17:53, Michael Schreckenbauer wrote:
> 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
>
>
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'
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
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
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
next prev parent reply other threads:[~2011-10-26 23:01 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 [this message]
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=4EA890E6.40104@gmail.com \
--to=msulli1355@gmail.com \
--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