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
