1 |
Am Mittwoch, 26. Oktober 2011, 17:42:14 schrieb Michael Sullivan: |
2 |
> On 10/26/11 17:32, Michael Schreckenbauer wrote: |
3 |
> > So you did run mysql_upgrade and same as before? Some words about what |
4 |
> > you did and some relevant output of the command (if any) wouldn't hurt |
5 |
> > ;) Have you tried mysql_fix_privilege_tables? After that, you would |
6 |
> > need to run the steps mentioned in the wiki again (I think), giving the |
7 |
> > password you entered in myth-setup to the UPDATE command. |
8 |
> > |
9 |
> > Best, |
10 |
> > Michael |
11 |
> |
12 |
> camille ~ # mysql_upgrade -p |
13 |
> Enter password: |
14 |
> Looking for 'mysql' as: mysql |
15 |
> Looking for 'mysqlcheck' as: mysqlcheck |
16 |
> Running 'mysqlcheck' with connection arguments: '--port=3306' |
17 |
> '--socket=/var/run/mysqld/mysqld.sock' |
18 |
> Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA |
19 |
> DIRECTORY NAME |
20 |
> Error: Incorrect database name '#mysql50#mythconverg.bak' |
21 |
> Running 'mysqlcheck' with connection arguments: '--port=3306' |
22 |
> '--socket=/var/run/mysqld/mysqld.sock' |
23 |
> forum.phpbb_auth_access |
24 |
> error : Table upgrade required. Please do "REPAIR TABLE |
25 |
> `phpbb_auth_access`" or dump/reload to fix it! |
26 |
> forum.phpbb_banlist |
27 |
> error : Table upgrade required. Please do "REPAIR TABLE |
28 |
> `phpbb_banlist`" or dump/reload to fix it! |
29 |
> forum.phpbb_categories |
30 |
> error : Table upgrade required. Please do "REPAIR TABLE |
31 |
> `phpbb_categories`" or dump/reload to fix it! |
32 |
> forum.phpbb_config |
33 |
> error : Table upgrade required. Please do "REPAIR TABLE |
34 |
> `phpbb_config`" or dump/reload to fix it! |
35 |
> forum.phpbb_confirm |
36 |
> error : Table upgrade required. Please do "REPAIR TABLE |
37 |
> `phpbb_confirm`" or dump/reload to fix it! |
38 |
> forum.phpbb_disallow |
39 |
> error : Table upgrade required. Please do "REPAIR TABLE |
40 |
> `phpbb_disallow`" or dump/reload to fix it! |
41 |
> forum.phpbb_forum_prune |
42 |
> error : Table upgrade required. Please do "REPAIR TABLE |
43 |
> `phpbb_forum_prune`" or dump/reload to fix it! |
44 |
> forum.phpbb_forums |
45 |
> error : Table upgrade required. Please do "REPAIR TABLE |
46 |
> `phpbb_forums`" or dump/reload to fix it! |
47 |
> forum.phpbb_groups |
48 |
> error : Table upgrade required. Please do "REPAIR TABLE |
49 |
> `phpbb_groups`" or dump/reload to fix it! |
50 |
> forum.phpbb_posts |
51 |
> error : Table upgrade required. Please do "REPAIR TABLE |
52 |
> `phpbb_posts`" or dump/reload to fix it! |
53 |
> forum.phpbb_posts_text |
54 |
> error : Table upgrade required. Please do "REPAIR TABLE |
55 |
> `phpbb_posts_text`" or dump/reload to fix it! |
56 |
> forum.phpbb_privmsgs |
57 |
> error : Table upgrade required. Please do "REPAIR TABLE |
58 |
> `phpbb_privmsgs`" or dump/reload to fix it! |
59 |
> forum.phpbb_privmsgs_text |
60 |
> error : Table upgrade required. Please do "REPAIR TABLE |
61 |
> `phpbb_privmsgs_text`" or dump/reload to fix it! |
62 |
> forum.phpbb_ranks |
63 |
> error : Table upgrade required. Please do "REPAIR TABLE |
64 |
> `phpbb_ranks`" or dump/reload to fix it! |
65 |
> forum.phpbb_search_results |
66 |
> error : Table upgrade required. Please do "REPAIR TABLE |
67 |
> `phpbb_search_results`" or dump/reload to fix it! |
68 |
> forum.phpbb_search_wordlist |
69 |
> error : Table upgrade required. Please do "REPAIR TABLE |
70 |
> `phpbb_search_wordlist`" or dump/reload to fix it! |
71 |
> forum.phpbb_search_wordmatch |
72 |
> error : Table upgrade required. Please do "REPAIR TABLE |
73 |
> `phpbb_search_wordmatch`" or dump/reload to fix it! |
74 |
> forum.phpbb_sessions |
75 |
> error : Table upgrade required. Please do "REPAIR TABLE |
76 |
> `phpbb_sessions`" or dump/reload to fix it! |
77 |
> forum.phpbb_sessions_keys |
78 |
> error : Table upgrade required. Please do "REPAIR TABLE |
79 |
> `phpbb_sessions_keys`" or dump/reload to fix it! |
80 |
> forum.phpbb_smilies |
81 |
> error : Table upgrade required. Please do "REPAIR TABLE |
82 |
> `phpbb_smilies`" or dump/reload to fix it! |
83 |
> forum.phpbb_themes |
84 |
> error : Table upgrade required. Please do "REPAIR TABLE |
85 |
> `phpbb_themes`" or dump/reload to fix it! |
86 |
> forum.phpbb_themes_name |
87 |
> error : Table upgrade required. Please do "REPAIR TABLE |
88 |
> `phpbb_themes_name`" or dump/reload to fix it! |
89 |
> forum.phpbb_topics |
90 |
> error : Table upgrade required. Please do "REPAIR TABLE |
91 |
> `phpbb_topics`" or dump/reload to fix it! |
92 |
> forum.phpbb_topics_watch |
93 |
> error : Table upgrade required. Please do "REPAIR TABLE |
94 |
> `phpbb_topics_watch`" or dump/reload to fix it! |
95 |
> forum.phpbb_user_group |
96 |
> error : Table upgrade required. Please do "REPAIR TABLE |
97 |
> `phpbb_user_group`" or dump/reload to fix it! |
98 |
> forum.phpbb_users |
99 |
> error : Table upgrade required. Please do "REPAIR TABLE |
100 |
> `phpbb_users`" or dump/reload to fix it! |
101 |
> forum.phpbb_vote_desc |
102 |
> error : Table upgrade required. Please do "REPAIR TABLE |
103 |
> `phpbb_vote_desc`" or dump/reload to fix it! |
104 |
> forum.phpbb_vote_results |
105 |
> error : Table upgrade required. Please do "REPAIR TABLE |
106 |
> `phpbb_vote_results`" or dump/reload to fix it! |
107 |
> forum.phpbb_vote_voters |
108 |
> error : Table upgrade required. Please do "REPAIR TABLE |
109 |
> `phpbb_vote_voters`" or dump/reload to fix it! |
110 |
> forum.phpbb_words |
111 |
> error : Table upgrade required. Please do "REPAIR TABLE |
112 |
> `phpbb_words`" or dump/reload to fix it! |
113 |
> movies.also_available |
114 |
> error : Table upgrade required. Please do "REPAIR TABLE |
115 |
> `also_available`" or dump/reload to fix it! |
116 |
> movies.do_not_watch |
117 |
> error : Table upgrade required. Please do "REPAIR TABLE |
118 |
> `do_not_watch`" or dump/reload to fix it! |
119 |
> movies.movies_to_review |
120 |
> error : Table upgrade required. Please do "REPAIR TABLE |
121 |
> `movies_to_review`" or dump/reload to fix it! |
122 |
> movies.reviews |
123 |
> error : Table upgrade required. Please do "REPAIR TABLE `reviews`" or |
124 |
> dump/reload to fix it! |
125 |
> movies.to_do_list |
126 |
> error : Table upgrade required. Please do "REPAIR TABLE `to_do_list`" |
127 |
> or dump/reload to fix it! |
128 |
> myFantasy.actions |
129 |
> error : Table upgrade required. Please do "REPAIR TABLE `actions`" or |
130 |
> dump/reload to fix it! |
131 |
> myFantasy.allyAbilities |
132 |
> error : Table upgrade required. Please do "REPAIR TABLE |
133 |
> `allyAbilities`" or dump/reload to fix it! |
134 |
> myFantasy.characters |
135 |
> error : Table upgrade required. Please do "REPAIR TABLE `characters`" |
136 |
> or dump/reload to fix it! |
137 |
> myFantasy.class |
138 |
> error : Table upgrade required. Please do "REPAIR TABLE `class`" or |
139 |
> dump/reload to fix it! |
140 |
> myFantasy.enemy |
141 |
> error : Table upgrade required. Please do "REPAIR TABLE `enemy`" or |
142 |
> dump/reload to fix it! |
143 |
> myFantasy.enemyAbility |
144 |
> error : Table upgrade required. Please do "REPAIR TABLE |
145 |
> `enemyAbility`" or dump/reload to fix it! |
146 |
> myFantasy.magic |
147 |
> error : Table upgrade required. Please do "REPAIR TABLE `magic`" or |
148 |
> dump/reload to fix it! |
149 |
> myFantasy.party |
150 |
> error : Table upgrade required. Please do "REPAIR TABLE `party`" or |
151 |
> dump/reload to fix it! |
152 |
> mysql.columns_priv OK |
153 |
> mysql.db OK |
154 |
> mysql.event OK |
155 |
> mysql.func OK |
156 |
> mysql.general_log |
157 |
> Error : You can't use locks with log tables. |
158 |
> status : OK |
159 |
> mysql.help_category |
160 |
> error : Table upgrade required. Please do "REPAIR TABLE |
161 |
> `help_category`" or dump/reload to fix it! |
162 |
> mysql.help_keyword |
163 |
> error : Table upgrade required. Please do "REPAIR TABLE |
164 |
> `help_keyword`" or dump/reload to fix it! |
165 |
> mysql.help_relation |
166 |
> error : Table upgrade required. Please do "REPAIR TABLE |
167 |
> `help_relation`" or dump/reload to fix it! |
168 |
> mysql.help_topic |
169 |
> error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" |
170 |
> or dump/reload to fix it! |
171 |
> mysql.host OK |
172 |
> mysql.ndb_binlog_index OK |
173 |
> mysql.plugin OK |
174 |
> mysql.proc OK |
175 |
> mysql.procs_priv OK |
176 |
> mysql.servers OK |
177 |
> mysql.slow_log |
178 |
> Error : You can't use locks with log tables. |
179 |
> status : OK |
180 |
> mysql.tables_priv OK |
181 |
> mysql.time_zone |
182 |
> error : Table upgrade required. Please do "REPAIR TABLE `time_zone`" |
183 |
> or dump/reload to fix it! |
184 |
> mysql.time_zone_leap_second |
185 |
> error : Table upgrade required. Please do "REPAIR TABLE |
186 |
> `time_zone_leap_second`" or dump/reload to fix it! |
187 |
> mysql.time_zone_name |
188 |
> error : Table upgrade required. Please do "REPAIR TABLE |
189 |
> `time_zone_name`" or dump/reload to fix it! |
190 |
> mysql.time_zone_transition |
191 |
> error : Table upgrade required. Please do "REPAIR TABLE |
192 |
> `time_zone_transition`" or dump/reload to fix it! |
193 |
> mysql.time_zone_transition_type |
194 |
> error : Table upgrade required. Please do "REPAIR TABLE |
195 |
> `time_zone_transition_type`" or dump/reload to fix it! |
196 |
> mysql.user OK |
197 |
> mysql_cpp_data.images OK |
198 |
> mysql_cpp_data.stock |
199 |
> Error : Table 'mysql_cpp_data.stock' doesn't exist |
200 |
> status : Operation failed |
201 |
> mythconverg.archiveitems OK |
202 |
> mythconverg.callsignnetworkmap OK |
203 |
> mythconverg.capturecard OK |
204 |
> mythconverg.cardinput OK |
205 |
> mythconverg.channel OK |
206 |
> mythconverg.channelgroup OK |
207 |
> mythconverg.channelgroupnames OK |
208 |
> mythconverg.channelscan OK |
209 |
> mythconverg.channelscan_channel OK |
210 |
> mythconverg.channelscan_dtv_multiplex OK |
211 |
> mythconverg.codecparams OK |
212 |
> mythconverg.credits OK |
213 |
> mythconverg.customexample OK |
214 |
> mythconverg.diseqc_config OK |
215 |
> mysqlcheck: Got error: 1102: Incorrect database name |
216 |
> '#mysql50#mythconverg.bak' when selecting the database |
217 |
> mythconverg.diseqc_tree OK |
218 |
> mythconverg.displayprofilegroups OK |
219 |
> mythconverg.displayprofiles OK |
220 |
> mythconverg.dtv_multiplex OK |
221 |
> mythconverg.dtv_privatetypes OK |
222 |
> mythconverg.dvdbookmark OK |
223 |
> mythconverg.dvdinput OK |
224 |
> mythconverg.dvdtranscode OK |
225 |
> mythconverg.eit_cache OK |
226 |
> mythconverg.filemarkup OK |
227 |
> mythconverg.gamemetadata OK |
228 |
> mythconverg.gameplayers OK |
229 |
> mythconverg.housekeeping OK |
230 |
> mythconverg.inputgroup OK |
231 |
> mythconverg.inuseprograms OK |
232 |
> mythconverg.jobqueue OK |
233 |
> mythconverg.jumppoints OK |
234 |
> mythconverg.keybindings OK |
235 |
> mythconverg.keyword OK |
236 |
> mythconverg.music_albumart OK |
237 |
> mythconverg.music_albums OK |
238 |
> mythconverg.music_artists OK |
239 |
> mythconverg.music_directories OK |
240 |
> mythconverg.music_genres OK |
241 |
> mythconverg.music_playlists OK |
242 |
> mythconverg.music_smartplaylist_categories OK |
243 |
> mythconverg.music_smartplaylist_items OK |
244 |
> mythconverg.music_smartplaylists OK |
245 |
> mythconverg.music_songs OK |
246 |
> mythconverg.music_stats OK |
247 |
> mythconverg.mythlog OK |
248 |
> mythconverg.mythweb_sessions OK |
249 |
> mythconverg.netflix OK |
250 |
> mythconverg.networkiconmap OK |
251 |
> mythconverg.oldfind OK |
252 |
> mythconverg.oldprogram OK |
253 |
> mythconverg.oldrecorded OK |
254 |
> mythconverg.people OK |
255 |
> mythconverg.pidcache OK |
256 |
> mythconverg.playgroup OK |
257 |
> mythconverg.powerpriority OK |
258 |
> mythconverg.profilegroups OK |
259 |
> mythconverg.program OK |
260 |
> mythconverg.programgenres OK |
261 |
> mythconverg.programrating OK |
262 |
> mythconverg.recgrouppassword OK |
263 |
> mythconverg.record OK |
264 |
> mythconverg.record_tmp OK |
265 |
> mythconverg.recorded OK |
266 |
> mythconverg.recordedcredits OK |
267 |
> mythconverg.recordedfile OK |
268 |
> mythconverg.recordedmarkup OK |
269 |
> mythconverg.recordedprogram OK |
270 |
> mythconverg.recordedrating OK |
271 |
> mythconverg.recordedseek OK |
272 |
> mythconverg.recordingprofiles OK |
273 |
> mythconverg.recordmatch OK |
274 |
> mythconverg.romdb OK |
275 |
> mythconverg.schemalock OK |
276 |
> mythconverg.settings OK |
277 |
> mythconverg.storagegroup OK |
278 |
> mythconverg.tvchain OK |
279 |
> mythconverg.tvosdmenu OK |
280 |
> mythconverg.upnpmedia OK |
281 |
> mythconverg.videocast OK |
282 |
> mythconverg.videocategory OK |
283 |
> mythconverg.videocountry OK |
284 |
> mythconverg.videogenre OK |
285 |
> mythconverg.videometadata OK |
286 |
> mythconverg.videometadatacast OK |
287 |
> mythconverg.videometadatacountry OK |
288 |
> mythconverg.videometadatagenre OK |
289 |
> mythconverg.videosource OK |
290 |
> mythconverg.videotypes OKcamille ~ # |
291 |
> mysql_fix_privilege_tables |
292 |
> This script updates all the mysql privilege tables to be usable by |
293 |
> the current version of MySQL |
294 |
> |
295 |
> done |
296 |
|
297 |
So your mythtv-tables are ok afaics. you need to repair your php-bb tables at |
298 |
some time, but that's a different topic. |
299 |
From your other post I conclude, that connecting to the backend now works, but |
300 |
you don't get a program listing. I'll answer there, to keep things related |
301 |
together. |
302 |
|
303 |
Best, |
304 |
Michael |