1 |
Am Mittwoch, 26. Oktober 2011, 17:59:50 schrieb Michael Sullivan: |
2 |
> > So your mythtv-tables are ok afaics. you need to repair your php-bb |
3 |
> > tables at some time, but that's a different topic. |
4 |
> > From your other post I conclude, that connecting to the backend now |
5 |
> > works, but you don't get a program listing. I'll answer there, to keep |
6 |
> > things related together. |
7 |
> > |
8 |
> > Best, |
9 |
> > Michael |
10 |
> |
11 |
> I spent some time repairing tables. Does this look better? |
12 |
> |
13 |
> camille ~ # mysql_upgrade -p |
14 |
> Enter password: |
15 |
> Looking for 'mysql' as: mysql |
16 |
> Looking for 'mysqlcheck' as: mysqlcheck |
17 |
> Running 'mysqlcheck' with connection arguments: '--port=3306' |
18 |
> '--socket=/var/run/mysqld/mysqld.sock' |
19 |
> Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA |
20 |
> DIRECTORY NAME |
21 |
> Error: Incorrect database name '#mysql50#mythconverg.bak' |
22 |
|
23 |
this looks strange. I have no idea what to do about this currently. |
24 |
|
25 |
> Running 'mysqlcheck' with connection arguments: '--port=3306' |
26 |
> '--socket=/var/run/mysqld/mysqld.sock' |
27 |
> myFantasy.actions OK |
28 |
> myFantasy.allyAbilities OK |
29 |
> myFantasy.characters OK |
30 |
> myFantasy.class OK |
31 |
> myFantasy.enemy OK |
32 |
> myFantasy.enemyAbility OK |
33 |
> myFantasy.magic OK |
34 |
> myFantasy.party OK |
35 |
> mysql.columns_priv OK |
36 |
> mysql.db OK |
37 |
> mysql.event OK |
38 |
> mysql.func OK |
39 |
> mysql.general_log |
40 |
> Error : You can't use locks with log tables. |
41 |
> status : OK |
42 |
> mysql.help_category OK |
43 |
> mysql.help_keyword OK |
44 |
> mysql.help_relation OK |
45 |
> mysql.help_topic OK |
46 |
> mysql.host OK |
47 |
> mysql.ndb_binlog_index OK |
48 |
> mysql.plugin OK |
49 |
> mysql.proc OK |
50 |
> mysql.procs_priv OK |
51 |
> mysql.servers OK |
52 |
> mysql.slow_log |
53 |
> Error : You can't use locks with log tables. |
54 |
> status : OK |
55 |
> mysql.tables_priv OK |
56 |
> mysql.time_zone OK |
57 |
> mysql.time_zone_leap_second OK |
58 |
> mysql.time_zone_name OK |
59 |
> mysql.time_zone_transition OK |
60 |
> mysql.time_zone_transition_type OK |
61 |
> mysql.user OK |
62 |
> mysql_cpp_data.images OK |
63 |
> mysql_cpp_data.stock |
64 |
> Error : Table 'mysql_cpp_data.stock' doesn't exist |
65 |
> status : Operation failed |
66 |
|
67 |
Dito. |
68 |
I miss your php-bb tables here. Deleted? ;) |
69 |
|
70 |
> mythconverg.archiveitems OK |
71 |
> mythconverg.callsignnetworkmap OK |
72 |
> mythconverg.capturecard OK |
73 |
> mythconverg.cardinput OK |
74 |
> mythconverg.channel OK |
75 |
> mythconverg.channelgroup OK |
76 |
> mythconverg.channelgroupnames OK |
77 |
> mythconverg.channelscan OK |
78 |
> mythconverg.channelscan_channel OK |
79 |
> mythconverg.channelscan_dtv_multiplex OK |
80 |
> mythconverg.codecparams OK |
81 |
> mythconverg.credits OK |
82 |
> mythconverg.customexample OK |
83 |
> mythconverg.diseqc_config OK |
84 |
> mythconverg.diseqc_tree OK |
85 |
> mythconverg.displayprofilegroups OK |
86 |
> mythconverg.displayprofiles OK |
87 |
> mythconverg.dtv_multiplex OK |
88 |
> mythconverg.dtv_privatetypes OK |
89 |
> mythconverg.dvdbookmark OK |
90 |
> mythconverg.dvdinput OK |
91 |
> mythconverg.dvdtranscode OK |
92 |
> mythconverg.eit_cache OK |
93 |
> mythconverg.filemarkup OK |
94 |
> mythconverg.gamemetadata OK |
95 |
> mythconverg.gameplayers OK |
96 |
> mythconverg.housekeeping OK |
97 |
> mythconverg.inputgroup OK |
98 |
> mythconverg.inuseprograms OK |
99 |
> mythconverg.jobqueue OK |
100 |
> mythconverg.jumppoints OK |
101 |
> mythconverg.keybindings OK |
102 |
> mythconverg.keyword OK |
103 |
> mythconverg.music_albumart OK |
104 |
> mythconverg.music_albums OK |
105 |
> mythconverg.music_artists OK |
106 |
> mythconverg.music_directories OK |
107 |
> mythconverg.music_genres OK |
108 |
> mythconverg.music_playlists OK |
109 |
> mythconverg.music_smartplaylist_categories OK |
110 |
> mythconverg.music_smartplaylist_items OK |
111 |
> mysqlcheck: Got error: 1102: Incorrect database name |
112 |
> '#mysql50#mythconverg.bak' when selecting the database |
113 |
|
114 |
Same as at the beginning. Was there before your repair. I missed it somehow. |
115 |
|
116 |
> mythconverg.music_smartplaylists OK |
117 |
> mythconverg.music_songs OK |
118 |
> mythconverg.music_stats OK |
119 |
> mythconverg.mythlog OK |
120 |
> mythconverg.mythweb_sessions OK |
121 |
> mythconverg.netflix OK |
122 |
> mythconverg.networkiconmap OK |
123 |
> mythconverg.oldfind OK |
124 |
> mythconverg.oldprogram OK |
125 |
> mythconverg.oldrecorded OK |
126 |
> mythconverg.people OK |
127 |
> mythconverg.pidcache OK |
128 |
> mythconverg.playgroup OK |
129 |
> mythconverg.powerpriority OK |
130 |
> mythconverg.profilegroups OK |
131 |
> mythconverg.program OK |
132 |
> mythconverg.programgenres OK |
133 |
> mythconverg.programrating OK |
134 |
> mythconverg.recgrouppassword OK |
135 |
> mythconverg.record OK |
136 |
> mythconverg.record_tmp OK |
137 |
> mythconverg.recorded OK |
138 |
> mythconverg.recordedcredits OK |
139 |
> mythconverg.recordedfile OK |
140 |
> mythconverg.recordedmarkup OK |
141 |
> mythconverg.recordedprogram OK |
142 |
> mythconverg.recordedrating OK |
143 |
> mythconverg.recordedseek OK |
144 |
> mythconverg.recordingprofiles OK |
145 |
> mythconverg.recordmatch OK |
146 |
> mythconverg.romdb OK |
147 |
> mythconverg.schemalock OK |
148 |
> mythconverg.settings OK |
149 |
> mythconverg.storagegroup OK |
150 |
> mythconverg.tvchain OK |
151 |
> mythconverg.tvosdmenu OK |
152 |
> mythconverg.upnpmedia OK |
153 |
> mythconverg.videocast OK |
154 |
> mythconverg.videocategory OK |
155 |
> mythconverg.videocountry OK |
156 |
> mythconverg.videogenre OK |
157 |
> mythconverg.videometadata OK |
158 |
> mythconverg.videometadatacast OK |
159 |
> mythconverg.videometadatacountry OK |
160 |
> mythconverg.videometadatagenre OK |
161 |
> mythconverg.videosource OK |
162 |
> mythconverg.videotypes OK |
163 |
> FATAL ERROR: Upgrade failed |
164 |
|
165 |
The rest looks ok to me. |
166 |
|
167 |
Best, |
168 |
Michael |