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