Erro: PHPBB Got error 1 from storage engine [1030]

[DeLima]

URL do Fórum: http://www.dicasbcb.com/Forum/index.php

Boa noite. Ontem (e hoje) fui entrar no fórum e tudo o que aparece é uma página de erro com essa mensagem:

General Error
SQL ERROR [ mysql4 ]

Got error 1 from storage engine [1030]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Sou completamente leigo no assunto. Tinha outro colega que cuidava do fórum, mas agora estou sozinho e não sei o que fazer. Nem sei qual é a versão do meu phpBB!

Poderiam me ajudar?

Agradeço a força!

DeLima

[Chico Gois]

Voce precisa reparar as tabelas via phpmyadmin no cpanel do seu dominio

[DeLima]

Opa, valeu mesmo! :D

Sem querer abusar, você poderia me dar uns toques de como fazer isso? Ou indicar algum link? É que eu não manjo nada mesmo!

Grande abraço!

DeLima

[Bruno Dias]

tu tem acesso a administraçao do seu host? geralmente é cpanel, vc entra la , clica no icone phpmyadmin, escolhe o banco de dados do forum, e da um repair
+- isso

[DeLima]

Consegui acessar o phpmyadmin.

Dúvida: Agora basta, no campo SQL, digitar:

repair

e clicar no botão "Executar"?

[Chico Gois]

Voce deve selecionar todas as tabelas, e no menu escolher reparar e otimizar e depois executar conforme a imagem

[DeLima]

Nossa :o ! A coisa está feia! Tá dando erro em tudo! :?

Código: Selecionar todos

Table	 Op	 Msg_type	 Msg_text
dicasbcb_f3.f3_acl_groups	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_acl_options	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_acl_roles	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_acl_roles_data	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_acl_users	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_attachments	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_banlist	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_bbcodes	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_bookmarks	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_bots	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_config	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_confirm	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_disallow	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_drafts	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_extension_groups	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_extensions	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_forums	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_forums_access	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_forums_track	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_forums_watch	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_groups	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_icons	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_lang	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_log	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_moderator_cache	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_modules	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_poll_options	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_poll_votes	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_posts	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_privmsgs	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_privmsgs_folder	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_privmsgs_rules	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_privmsgs_to	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_profile_fields	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_profile_fields_data	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_profile_fields_lang	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_profile_lang	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_ranks	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_reports	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_reports_reasons	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_search_results	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_search_wordlist	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_search_wordmatch	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_sessions	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_sessions_keys	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_sitelist	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_smilies	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_styles	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_styles_imageset	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_styles_imageset_data	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_styles_template	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_styles_template_data	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_styles_theme	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_topics	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_topics_posted	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_topics_track	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_topics_watch	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_user_group	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_users	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_warnings	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_words	repair	error	Got error 1 from storage engine
dicasbcb_f3.f3_zebra	repair	error	Got error 1 from storage engine

Existe outra opção?

Será que perdi os dados?

....

[Chico Gois]

Veja este artigo do proprio phpBB, se bem que ele não fala Got error 1

e sim If you receive a 1016 or 1030 error with a code of "2", "9", "12", "13", "23", "24", "28", or "122",
http://www.phpbb.com/kb/article/fixing- ... rom-mysql/

[DeLima]

Li o tutorial e tentei as soluções apontadas, mas nada dá certo. Não sei mais o que fazer... :cry:

[_Vinny_]

DeLima, verifique com o suporte da sua hospedagem qual é a versão do MySQL.
Eu dei uma pesquisada na web e pude notar que este problema ocorre em banco de dados com muitos registros, você saberia nos informar o tamanho do seu banco de dados?

Tente passar todo o seu fórum, incluindo o banco de dados para um servidor local, faça testes. Tem MODs instaladas?