1 |
On 10/26/11 17:53, Michael Schreckenbauer wrote: |
2 |
> Am Mittwoch, 26. Oktober 2011, 17:42:14 schrieb Michael Sullivan: |
3 |
>> On 10/26/11 17:32, Michael Schreckenbauer wrote: |
4 |
>>> So you did run mysql_upgrade and same as before? Some words about what |
5 |
>>> you did and some relevant output of the command (if any) wouldn't hurt |
6 |
>>> ;) Have you tried mysql_fix_privilege_tables? After that, you would |
7 |
>>> need to run the steps mentioned in the wiki again (I think), giving the |
8 |
>>> password you entered in myth-setup to the UPDATE command. |
9 |
>>> |
10 |
>>> Best, |
11 |
>>> Michael |
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 |
>> Running 'mysqlcheck' with connection arguments: '--port=3306' |
23 |
>> '--socket=/var/run/mysqld/mysqld.sock' |
24 |
>> forum.phpbb_auth_access |
25 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
26 |
>> `phpbb_auth_access`" or dump/reload to fix it! |
27 |
>> forum.phpbb_banlist |
28 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
29 |
>> `phpbb_banlist`" or dump/reload to fix it! |
30 |
>> forum.phpbb_categories |
31 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
32 |
>> `phpbb_categories`" or dump/reload to fix it! |
33 |
>> forum.phpbb_config |
34 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
35 |
>> `phpbb_config`" or dump/reload to fix it! |
36 |
>> forum.phpbb_confirm |
37 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
38 |
>> `phpbb_confirm`" or dump/reload to fix it! |
39 |
>> forum.phpbb_disallow |
40 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
41 |
>> `phpbb_disallow`" or dump/reload to fix it! |
42 |
>> forum.phpbb_forum_prune |
43 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
44 |
>> `phpbb_forum_prune`" or dump/reload to fix it! |
45 |
>> forum.phpbb_forums |
46 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
47 |
>> `phpbb_forums`" or dump/reload to fix it! |
48 |
>> forum.phpbb_groups |
49 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
50 |
>> `phpbb_groups`" or dump/reload to fix it! |
51 |
>> forum.phpbb_posts |
52 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
53 |
>> `phpbb_posts`" or dump/reload to fix it! |
54 |
>> forum.phpbb_posts_text |
55 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
56 |
>> `phpbb_posts_text`" or dump/reload to fix it! |
57 |
>> forum.phpbb_privmsgs |
58 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
59 |
>> `phpbb_privmsgs`" or dump/reload to fix it! |
60 |
>> forum.phpbb_privmsgs_text |
61 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
62 |
>> `phpbb_privmsgs_text`" or dump/reload to fix it! |
63 |
>> forum.phpbb_ranks |
64 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
65 |
>> `phpbb_ranks`" or dump/reload to fix it! |
66 |
>> forum.phpbb_search_results |
67 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
68 |
>> `phpbb_search_results`" or dump/reload to fix it! |
69 |
>> forum.phpbb_search_wordlist |
70 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
71 |
>> `phpbb_search_wordlist`" or dump/reload to fix it! |
72 |
>> forum.phpbb_search_wordmatch |
73 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
74 |
>> `phpbb_search_wordmatch`" or dump/reload to fix it! |
75 |
>> forum.phpbb_sessions |
76 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
77 |
>> `phpbb_sessions`" or dump/reload to fix it! |
78 |
>> forum.phpbb_sessions_keys |
79 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
80 |
>> `phpbb_sessions_keys`" or dump/reload to fix it! |
81 |
>> forum.phpbb_smilies |
82 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
83 |
>> `phpbb_smilies`" or dump/reload to fix it! |
84 |
>> forum.phpbb_themes |
85 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
86 |
>> `phpbb_themes`" or dump/reload to fix it! |
87 |
>> forum.phpbb_themes_name |
88 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
89 |
>> `phpbb_themes_name`" or dump/reload to fix it! |
90 |
>> forum.phpbb_topics |
91 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
92 |
>> `phpbb_topics`" or dump/reload to fix it! |
93 |
>> forum.phpbb_topics_watch |
94 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
95 |
>> `phpbb_topics_watch`" or dump/reload to fix it! |
96 |
>> forum.phpbb_user_group |
97 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
98 |
>> `phpbb_user_group`" or dump/reload to fix it! |
99 |
>> forum.phpbb_users |
100 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
101 |
>> `phpbb_users`" or dump/reload to fix it! |
102 |
>> forum.phpbb_vote_desc |
103 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
104 |
>> `phpbb_vote_desc`" or dump/reload to fix it! |
105 |
>> forum.phpbb_vote_results |
106 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
107 |
>> `phpbb_vote_results`" or dump/reload to fix it! |
108 |
>> forum.phpbb_vote_voters |
109 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
110 |
>> `phpbb_vote_voters`" or dump/reload to fix it! |
111 |
>> forum.phpbb_words |
112 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
113 |
>> `phpbb_words`" or dump/reload to fix it! |
114 |
>> movies.also_available |
115 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
116 |
>> `also_available`" or dump/reload to fix it! |
117 |
>> movies.do_not_watch |
118 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
119 |
>> `do_not_watch`" or dump/reload to fix it! |
120 |
>> movies.movies_to_review |
121 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
122 |
>> `movies_to_review`" or dump/reload to fix it! |
123 |
>> movies.reviews |
124 |
>> error : Table upgrade required. Please do "REPAIR TABLE `reviews`" or |
125 |
>> dump/reload to fix it! |
126 |
>> movies.to_do_list |
127 |
>> error : Table upgrade required. Please do "REPAIR TABLE `to_do_list`" |
128 |
>> or dump/reload to fix it! |
129 |
>> myFantasy.actions |
130 |
>> error : Table upgrade required. Please do "REPAIR TABLE `actions`" or |
131 |
>> dump/reload to fix it! |
132 |
>> myFantasy.allyAbilities |
133 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
134 |
>> `allyAbilities`" or dump/reload to fix it! |
135 |
>> myFantasy.characters |
136 |
>> error : Table upgrade required. Please do "REPAIR TABLE `characters`" |
137 |
>> or dump/reload to fix it! |
138 |
>> myFantasy.class |
139 |
>> error : Table upgrade required. Please do "REPAIR TABLE `class`" or |
140 |
>> dump/reload to fix it! |
141 |
>> myFantasy.enemy |
142 |
>> error : Table upgrade required. Please do "REPAIR TABLE `enemy`" or |
143 |
>> dump/reload to fix it! |
144 |
>> myFantasy.enemyAbility |
145 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
146 |
>> `enemyAbility`" or dump/reload to fix it! |
147 |
>> myFantasy.magic |
148 |
>> error : Table upgrade required. Please do "REPAIR TABLE `magic`" or |
149 |
>> dump/reload to fix it! |
150 |
>> myFantasy.party |
151 |
>> error : Table upgrade required. Please do "REPAIR TABLE `party`" or |
152 |
>> dump/reload to fix it! |
153 |
>> mysql.columns_priv OK |
154 |
>> mysql.db OK |
155 |
>> mysql.event OK |
156 |
>> mysql.func OK |
157 |
>> mysql.general_log |
158 |
>> Error : You can't use locks with log tables. |
159 |
>> status : OK |
160 |
>> mysql.help_category |
161 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
162 |
>> `help_category`" or dump/reload to fix it! |
163 |
>> mysql.help_keyword |
164 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
165 |
>> `help_keyword`" or dump/reload to fix it! |
166 |
>> mysql.help_relation |
167 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
168 |
>> `help_relation`" or dump/reload to fix it! |
169 |
>> mysql.help_topic |
170 |
>> error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" |
171 |
>> or dump/reload to fix it! |
172 |
>> mysql.host OK |
173 |
>> mysql.ndb_binlog_index OK |
174 |
>> mysql.plugin OK |
175 |
>> mysql.proc OK |
176 |
>> mysql.procs_priv OK |
177 |
>> mysql.servers OK |
178 |
>> mysql.slow_log |
179 |
>> Error : You can't use locks with log tables. |
180 |
>> status : OK |
181 |
>> mysql.tables_priv OK |
182 |
>> mysql.time_zone |
183 |
>> error : Table upgrade required. Please do "REPAIR TABLE `time_zone`" |
184 |
>> or dump/reload to fix it! |
185 |
>> mysql.time_zone_leap_second |
186 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
187 |
>> `time_zone_leap_second`" or dump/reload to fix it! |
188 |
>> mysql.time_zone_name |
189 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
190 |
>> `time_zone_name`" or dump/reload to fix it! |
191 |
>> mysql.time_zone_transition |
192 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
193 |
>> `time_zone_transition`" or dump/reload to fix it! |
194 |
>> mysql.time_zone_transition_type |
195 |
>> error : Table upgrade required. Please do "REPAIR TABLE |
196 |
>> `time_zone_transition_type`" or dump/reload to fix it! |
197 |
>> mysql.user OK |
198 |
>> mysql_cpp_data.images OK |
199 |
>> mysql_cpp_data.stock |
200 |
>> Error : Table 'mysql_cpp_data.stock' doesn't exist |
201 |
>> status : Operation failed |
202 |
>> mythconverg.archiveitems OK |
203 |
>> mythconverg.callsignnetworkmap OK |
204 |
>> mythconverg.capturecard OK |
205 |
>> mythconverg.cardinput OK |
206 |
>> mythconverg.channel OK |
207 |
>> mythconverg.channelgroup OK |
208 |
>> mythconverg.channelgroupnames OK |
209 |
>> mythconverg.channelscan OK |
210 |
>> mythconverg.channelscan_channel OK |
211 |
>> mythconverg.channelscan_dtv_multiplex OK |
212 |
>> mythconverg.codecparams OK |
213 |
>> mythconverg.credits OK |
214 |
>> mythconverg.customexample OK |
215 |
>> mythconverg.diseqc_config OK |
216 |
>> mysqlcheck: Got error: 1102: Incorrect database name |
217 |
>> '#mysql50#mythconverg.bak' when selecting the database |
218 |
>> mythconverg.diseqc_tree OK |
219 |
>> mythconverg.displayprofilegroups OK |
220 |
>> mythconverg.displayprofiles OK |
221 |
>> mythconverg.dtv_multiplex OK |
222 |
>> mythconverg.dtv_privatetypes OK |
223 |
>> mythconverg.dvdbookmark OK |
224 |
>> mythconverg.dvdinput OK |
225 |
>> mythconverg.dvdtranscode OK |
226 |
>> mythconverg.eit_cache OK |
227 |
>> mythconverg.filemarkup OK |
228 |
>> mythconverg.gamemetadata OK |
229 |
>> mythconverg.gameplayers OK |
230 |
>> mythconverg.housekeeping OK |
231 |
>> mythconverg.inputgroup OK |
232 |
>> mythconverg.inuseprograms OK |
233 |
>> mythconverg.jobqueue OK |
234 |
>> mythconverg.jumppoints OK |
235 |
>> mythconverg.keybindings OK |
236 |
>> mythconverg.keyword OK |
237 |
>> mythconverg.music_albumart OK |
238 |
>> mythconverg.music_albums OK |
239 |
>> mythconverg.music_artists OK |
240 |
>> mythconverg.music_directories OK |
241 |
>> mythconverg.music_genres OK |
242 |
>> mythconverg.music_playlists OK |
243 |
>> mythconverg.music_smartplaylist_categories OK |
244 |
>> mythconverg.music_smartplaylist_items OK |
245 |
>> mythconverg.music_smartplaylists OK |
246 |
>> mythconverg.music_songs OK |
247 |
>> mythconverg.music_stats OK |
248 |
>> mythconverg.mythlog OK |
249 |
>> mythconverg.mythweb_sessions OK |
250 |
>> mythconverg.netflix OK |
251 |
>> mythconverg.networkiconmap OK |
252 |
>> mythconverg.oldfind OK |
253 |
>> mythconverg.oldprogram OK |
254 |
>> mythconverg.oldrecorded OK |
255 |
>> mythconverg.people OK |
256 |
>> mythconverg.pidcache OK |
257 |
>> mythconverg.playgroup OK |
258 |
>> mythconverg.powerpriority OK |
259 |
>> mythconverg.profilegroups OK |
260 |
>> mythconverg.program OK |
261 |
>> mythconverg.programgenres OK |
262 |
>> mythconverg.programrating OK |
263 |
>> mythconverg.recgrouppassword OK |
264 |
>> mythconverg.record OK |
265 |
>> mythconverg.record_tmp OK |
266 |
>> mythconverg.recorded OK |
267 |
>> mythconverg.recordedcredits OK |
268 |
>> mythconverg.recordedfile OK |
269 |
>> mythconverg.recordedmarkup OK |
270 |
>> mythconverg.recordedprogram OK |
271 |
>> mythconverg.recordedrating OK |
272 |
>> mythconverg.recordedseek OK |
273 |
>> mythconverg.recordingprofiles OK |
274 |
>> mythconverg.recordmatch OK |
275 |
>> mythconverg.romdb OK |
276 |
>> mythconverg.schemalock OK |
277 |
>> mythconverg.settings OK |
278 |
>> mythconverg.storagegroup OK |
279 |
>> mythconverg.tvchain OK |
280 |
>> mythconverg.tvosdmenu OK |
281 |
>> mythconverg.upnpmedia OK |
282 |
>> mythconverg.videocast OK |
283 |
>> mythconverg.videocategory OK |
284 |
>> mythconverg.videocountry OK |
285 |
>> mythconverg.videogenre OK |
286 |
>> mythconverg.videometadata OK |
287 |
>> mythconverg.videometadatacast OK |
288 |
>> mythconverg.videometadatacountry OK |
289 |
>> mythconverg.videometadatagenre OK |
290 |
>> mythconverg.videosource OK |
291 |
>> mythconverg.videotypes OKcamille ~ # |
292 |
>> mysql_fix_privilege_tables |
293 |
>> This script updates all the mysql privilege tables to be usable by |
294 |
>> the current version of MySQL |
295 |
>> |
296 |
>> done |
297 |
> |
298 |
> So your mythtv-tables are ok afaics. you need to repair your php-bb tables at |
299 |
> some time, but that's a different topic. |
300 |
> From your other post I conclude, that connecting to the backend now works, but |
301 |
> you don't get a program listing. I'll answer there, to keep things related |
302 |
> together. |
303 |
> |
304 |
> Best, |
305 |
> Michael |
306 |
> |
307 |
> |
308 |
|
309 |
I spent some time repairing tables. Does this look better? |
310 |
|
311 |
camille ~ # mysql_upgrade -p |
312 |
Enter password: |
313 |
Looking for 'mysql' as: mysql |
314 |
Looking for 'mysqlcheck' as: mysqlcheck |
315 |
Running 'mysqlcheck' with connection arguments: '--port=3306' |
316 |
'--socket=/var/run/mysqld/mysqld.sock' |
317 |
Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA |
318 |
DIRECTORY NAME |
319 |
Error: Incorrect database name '#mysql50#mythconverg.bak' |
320 |
Running 'mysqlcheck' with connection arguments: '--port=3306' |
321 |
'--socket=/var/run/mysqld/mysqld.sock' |
322 |
myFantasy.actions OK |
323 |
myFantasy.allyAbilities OK |
324 |
myFantasy.characters OK |
325 |
myFantasy.class OK |
326 |
myFantasy.enemy OK |
327 |
myFantasy.enemyAbility OK |
328 |
myFantasy.magic OK |
329 |
myFantasy.party OK |
330 |
mysql.columns_priv OK |
331 |
mysql.db OK |
332 |
mysql.event OK |
333 |
mysql.func OK |
334 |
mysql.general_log |
335 |
Error : You can't use locks with log tables. |
336 |
status : OK |
337 |
mysql.help_category OK |
338 |
mysql.help_keyword OK |
339 |
mysql.help_relation OK |
340 |
mysql.help_topic OK |
341 |
mysql.host OK |
342 |
mysql.ndb_binlog_index OK |
343 |
mysql.plugin OK |
344 |
mysql.proc OK |
345 |
mysql.procs_priv OK |
346 |
mysql.servers OK |
347 |
mysql.slow_log |
348 |
Error : You can't use locks with log tables. |
349 |
status : OK |
350 |
mysql.tables_priv OK |
351 |
mysql.time_zone OK |
352 |
mysql.time_zone_leap_second OK |
353 |
mysql.time_zone_name OK |
354 |
mysql.time_zone_transition OK |
355 |
mysql.time_zone_transition_type OK |
356 |
mysql.user OK |
357 |
mysql_cpp_data.images OK |
358 |
mysql_cpp_data.stock |
359 |
Error : Table 'mysql_cpp_data.stock' doesn't exist |
360 |
status : Operation failed |
361 |
mythconverg.archiveitems OK |
362 |
mythconverg.callsignnetworkmap OK |
363 |
mythconverg.capturecard OK |
364 |
mythconverg.cardinput OK |
365 |
mythconverg.channel OK |
366 |
mythconverg.channelgroup OK |
367 |
mythconverg.channelgroupnames OK |
368 |
mythconverg.channelscan OK |
369 |
mythconverg.channelscan_channel OK |
370 |
mythconverg.channelscan_dtv_multiplex OK |
371 |
mythconverg.codecparams OK |
372 |
mythconverg.credits OK |
373 |
mythconverg.customexample OK |
374 |
mythconverg.diseqc_config OK |
375 |
mythconverg.diseqc_tree OK |
376 |
mythconverg.displayprofilegroups OK |
377 |
mythconverg.displayprofiles OK |
378 |
mythconverg.dtv_multiplex OK |
379 |
mythconverg.dtv_privatetypes OK |
380 |
mythconverg.dvdbookmark OK |
381 |
mythconverg.dvdinput OK |
382 |
mythconverg.dvdtranscode OK |
383 |
mythconverg.eit_cache OK |
384 |
mythconverg.filemarkup OK |
385 |
mythconverg.gamemetadata OK |
386 |
mythconverg.gameplayers OK |
387 |
mythconverg.housekeeping OK |
388 |
mythconverg.inputgroup OK |
389 |
mythconverg.inuseprograms OK |
390 |
mythconverg.jobqueue OK |
391 |
mythconverg.jumppoints OK |
392 |
mythconverg.keybindings OK |
393 |
mythconverg.keyword OK |
394 |
mythconverg.music_albumart OK |
395 |
mythconverg.music_albums OK |
396 |
mythconverg.music_artists OK |
397 |
mythconverg.music_directories OK |
398 |
mythconverg.music_genres OK |
399 |
mythconverg.music_playlists OK |
400 |
mythconverg.music_smartplaylist_categories OK |
401 |
mythconverg.music_smartplaylist_items OK |
402 |
mysqlcheck: Got error: 1102: Incorrect database name |
403 |
'#mysql50#mythconverg.bak' when selecting the database |
404 |
mythconverg.music_smartplaylists OK |
405 |
mythconverg.music_songs OK |
406 |
mythconverg.music_stats OK |
407 |
mythconverg.mythlog OK |
408 |
mythconverg.mythweb_sessions OK |
409 |
mythconverg.netflix OK |
410 |
mythconverg.networkiconmap OK |
411 |
mythconverg.oldfind OK |
412 |
mythconverg.oldprogram OK |
413 |
mythconverg.oldrecorded OK |
414 |
mythconverg.people OK |
415 |
mythconverg.pidcache OK |
416 |
mythconverg.playgroup OK |
417 |
mythconverg.powerpriority OK |
418 |
mythconverg.profilegroups OK |
419 |
mythconverg.program OK |
420 |
mythconverg.programgenres OK |
421 |
mythconverg.programrating OK |
422 |
mythconverg.recgrouppassword OK |
423 |
mythconverg.record OK |
424 |
mythconverg.record_tmp OK |
425 |
mythconverg.recorded OK |
426 |
mythconverg.recordedcredits OK |
427 |
mythconverg.recordedfile OK |
428 |
mythconverg.recordedmarkup OK |
429 |
mythconverg.recordedprogram OK |
430 |
mythconverg.recordedrating OK |
431 |
mythconverg.recordedseek OK |
432 |
mythconverg.recordingprofiles OK |
433 |
mythconverg.recordmatch OK |
434 |
mythconverg.romdb OK |
435 |
mythconverg.schemalock OK |
436 |
mythconverg.settings OK |
437 |
mythconverg.storagegroup OK |
438 |
mythconverg.tvchain OK |
439 |
mythconverg.tvosdmenu OK |
440 |
mythconverg.upnpmedia OK |
441 |
mythconverg.videocast OK |
442 |
mythconverg.videocategory OK |
443 |
mythconverg.videocountry OK |
444 |
mythconverg.videogenre OK |
445 |
mythconverg.videometadata OK |
446 |
mythconverg.videometadatacast OK |
447 |
mythconverg.videometadatacountry OK |
448 |
mythconverg.videometadatagenre OK |
449 |
mythconverg.videosource OK |
450 |
mythconverg.videotypes OK |
451 |
FATAL ERROR: Upgrade failed |