Erro Sql

Área de assuntos gerais do phpBB.
Instalação, administração e utilização do phpBB.

Erro Sql

Mensagempor Ovelheiro » 18/jul/2011, 21:27

Boas,
Enquanto acedia ao meu forum apareceu-me este erro:
SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'Nome da base de dados' (4) [2003]

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

E depois:
SQL ERROR [ mysql4 ]

Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [2013]

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

O que pode ser ?
Editado pela última vez por Ovelheiro em 18/jul/2011, 21:30, num total de 1 vez.
Avatar do Utilizador
Ovelheiro
phpBB PT Especialista
phpBB PT Especialista
 
Mensagens: 328
Registado: 22/jan/2010, 15:53
Nacionalidade: Portugal

Re: Erro Sql

Mensagempor Pavlov » 18/jul/2011, 21:29

Há muito que esse problema existe, ou é recente?
Pode ser do Servidor. Aguarda uns minutos.
Avatar do Utilizador
Pavlov
Fundador
Fundador
 
Mensagens: 7579
Mensagens: 22
Registado: 10/jan/2009, 13:57
Nacionalidade: Portugal

Re: Erro Sql

Mensagempor Ovelheiro » 18/jul/2011, 21:31

Já passou, nunca me tinha surgido :S
Avatar do Utilizador
Ovelheiro
phpBB PT Especialista
phpBB PT Especialista
 
Mensagens: 328
Registado: 22/jan/2010, 15:53
Nacionalidade: Portugal

Re: Erro Sql

Mensagempor Pavlov » 18/jul/2011, 21:51

Ovelheiro Escreveu:Já passou, nunca me tinha surgido :S


Por cá há o triste hábito de fazer manutenção não anunciada aos servidores...
Não digo que tenha sido o caso.
Avatar do Utilizador
Pavlov
Fundador
Fundador
 
Mensagens: 7579
Mensagens: 22
Registado: 10/jan/2009, 13:57
Nacionalidade: Portugal

Re: Erro Sql

Mensagempor Ovelheiro » 19/jul/2011, 10:59

Pavlov Escreveu:
Ovelheiro Escreveu:Já passou, nunca me tinha surgido :S


Por cá há o triste hábito de fazer manutenção não anunciada aos servidores...
Não digo que tenha sido o caso.

Isso é muito mau. Achei estranho porque nunca me tinha acontecido.
Avatar do Utilizador
Ovelheiro
phpBB PT Especialista
phpBB PT Especialista
 
Mensagens: 328
Registado: 22/jan/2010, 15:53
Nacionalidade: Portugal

Re: Erro Sql

Mensagempor danshinigami » 19/jul/2011, 16:27

Ola gente

eu estou tendo um problema com o servidor apache, alguem sabe pq o sql nao esta mais respondendo eu estou usando o easyPHP aparece essa mensagem, nao é a primeira vez que acontece da outra vez euformatei meu computador e consegui mais agora gostaria de resolver esse problema com mysql

[ img ]

quando eu tendo ir no forum lo localhost aparece essa mensagem
Código: Selecionar todos
General Error
SQL ERROR [ mysqli ]

Nenhuma conex�o p�de ser feita porque a m�quina de destino as recusou ativamente. [2002]

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


obrigado
Avatar do Utilizador
danshinigami
phpBB Portugal Novato
phpBB Portugal Novato
 
Mensagens: 31
Registado: 06/jul/2011, 18:54
Localização: Natal
Nacionalidade: Brasil

Re: Erro Sql

Mensagempor Vinny » 19/jul/2011, 17:28

SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'Nome da base de dados' (4) [2003]

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

A conexão com o banco de dados falhou, por isso o erro, tenha certeza que forneceu os dados corretos na instalação do phpBB ou pode defini-los no arquivo config.php

SQL ERROR [ mysql4 ]

Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [2013]

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

Falha no servidor de hospedagem, o conexão com o banco de dados não foi estabelecida corretamente então foi encerrada.
Avatar do Utilizador
Vinny
Quadro de Honra
Quadro de Honra
 
Mensagens: 4979
Mensagens: 11
Registado: 31/jul/2009, 17:40
Localização: Macapá-Amapá
Nacionalidade: Brasil

Re: Erro Sql

Mensagempor Vinny » 19/jul/2011, 17:31

Note que o Apache esta com o sinal verde, então não tem problema com o Apache, mas sim o problema com o MySQL, que esta com sinal vermelho.

Basta você reiniciar o serviço MySQL para ele funcionar novamente.
Avatar do Utilizador
Vinny
Quadro de Honra
Quadro de Honra
 
Mensagens: 4979
Mensagens: 11
Registado: 31/jul/2009, 17:40
Localização: Macapá-Amapá
Nacionalidade: Brasil

Re: Erro Sql

Mensagempor danshinigami » 19/jul/2011, 18:26

viche eu fiz isso ele nao funciona, o log de erro que me aparece é esse, vou tentar fazer ele
funcionar ou usar outro servidor apache

Código: Selecionar todos
110718 16:33:07 [Note] Plugin 'FEDERATED' is disabled.
110718 16:33:07 InnoDB: The InnoDB memory heap is disabled
110718 16:33:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110718 16:33:07 InnoDB: Compressed tables use zlib 1.2.3
110718 16:33:08 InnoDB: Initializing buffer pool, size = 128.0M
110718 16:33:08 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
110718 16:33:08  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110718 16:33:09  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110718 16:33:09  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110718 16:33:11  InnoDB: Waiting for the background threads to start
110718 16:33:12 InnoDB: 1.1.5 started; log sequence number 0
110718 16:33:13 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
110718 16:33:13 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
110718 16:33:13 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
110718 16:33:13 [Note] Event Scheduler: Loaded 0 events
110718 16:33:13 [Note] D:\ARQUIV~1\EASYPH~1.0\MySql\bin\mysqld.exe: ready for connections.
Version: '5.5.10-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110718 17:00:30 [ERROR] Cannot find or open table 163422/phpbb_menu_buttons from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:00:30 [ERROR] Cannot find or open table 163422/phpbb_menu_colors from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:00:30 [ERROR] Cannot find or open table 163422/phpbb_mods from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:00:31 [ERROR] Cannot find or open table 163422/phpbb_thanks from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:05:36 [ERROR] Cannot find or open table 163422/phpbb_mods from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:06:46 [ERROR] Cannot find or open table 163422/phpbb_mods from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:06:46 [ERROR] Cannot find or open table 163422/phpbb_mods from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:53:45 [ERROR] Cannot find or open table 163422/phpbb_menu_buttons from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:53:45 [ERROR] Cannot find or open table 163422/phpbb_menu_colors from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:53:45 [ERROR] Cannot find or open table 163422/phpbb_mods from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 17:53:45 [ERROR] Cannot find or open table 163422/phpbb_thanks from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

110718 22:00:20 [Note] D:\ARQUIV~1\EASYPH~1.0\MySql\bin\mysqld.exe: Normal shutdown

110718 22:00:21 [Note] Event Scheduler: Purging the queue. 0 events
110718 22:00:24  InnoDB: Starting shutdown...
110718 22:00:37  InnoDB: Shutdown completed; log sequence number 1595675
110718 22:00:38 [Note] D:\ARQUIV~1\EASYPH~1.0\MySql\bin\mysqld.exe: Shutdown complete

110719  0:33:21 [Note] Plugin 'FEDERATED' is disabled.
110719  0:33:21 InnoDB: The InnoDB memory heap is disabled
110719  0:33:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  0:33:21 InnoDB: Compressed tables use zlib 1.2.3
110719  0:33:21 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  0:39:27 [Note] Plugin 'FEDERATED' is disabled.
110719  0:39:27 InnoDB: The InnoDB memory heap is disabled
110719  0:39:27 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  0:39:27 InnoDB: Compressed tables use zlib 1.2.3
110719  0:39:27 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  0:39:33 [Note] Plugin 'FEDERATED' is disabled.
110719  0:39:33 InnoDB: The InnoDB memory heap is disabled
110719  0:39:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  0:39:33 InnoDB: Compressed tables use zlib 1.2.3
110719  0:39:33 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  1:50:15 [Note] Plugin 'FEDERATED' is disabled.
110719  1:50:15 InnoDB: The InnoDB memory heap is disabled
110719  1:50:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  1:50:15 InnoDB: Compressed tables use zlib 1.2.3
110719  1:50:15 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  1:50:40 [Note] Plugin 'FEDERATED' is disabled.
110719  1:50:40 InnoDB: The InnoDB memory heap is disabled
110719  1:50:40 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  1:50:40 InnoDB: Compressed tables use zlib 1.2.3
110719  1:50:40 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  1:50:46 [Note] Plugin 'FEDERATED' is disabled.
110719  1:50:46 InnoDB: The InnoDB memory heap is disabled
110719  1:50:46 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  1:50:46 InnoDB: Compressed tables use zlib 1.2.3
110719  1:50:46 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  1:50:52 [Note] Plugin 'FEDERATED' is disabled.
110719  1:50:52 InnoDB: The InnoDB memory heap is disabled
110719  1:50:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  1:50:52 InnoDB: Compressed tables use zlib 1.2.3
110719  1:50:52 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  1:50:58 [Note] Plugin 'FEDERATED' is disabled.
110719  1:50:58 InnoDB: The InnoDB memory heap is disabled
110719  1:50:58 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  1:50:58 InnoDB: Compressed tables use zlib 1.2.3
110719  1:50:58 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719  1:51:03 [Note] Plugin 'FEDERATED' is disabled.
110719  1:51:03 InnoDB: The InnoDB memory heap is disabled
110719  1:51:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719  1:51:03 InnoDB: Compressed tables use zlib 1.2.3
110719  1:51:03 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 13:20:13 [Note] Plugin 'FEDERATED' is disabled.
110719 13:20:13 InnoDB: The InnoDB memory heap is disabled
110719 13:20:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 13:20:13 InnoDB: Compressed tables use zlib 1.2.3
110719 13:20:13 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 13:20:41 [Note] Plugin 'FEDERATED' is disabled.
110719 13:20:41 InnoDB: The InnoDB memory heap is disabled
110719 13:20:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 13:20:41 InnoDB: Compressed tables use zlib 1.2.3
110719 13:20:41 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 13:21:02 [Note] Plugin 'FEDERATED' is disabled.
110719 13:21:02 InnoDB: The InnoDB memory heap is disabled
110719 13:21:02 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 13:21:02 InnoDB: Compressed tables use zlib 1.2.3
110719 13:21:02 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 13:22:20 [Note] Plugin 'FEDERATED' is disabled.
110719 13:22:20 InnoDB: The InnoDB memory heap is disabled
110719 13:22:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 13:22:20 InnoDB: Compressed tables use zlib 1.2.3
110719 13:22:20 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 13:31:40 [Note] Plugin 'FEDERATED' is disabled.
110719 13:31:40 InnoDB: The InnoDB memory heap is disabled
110719 13:31:40 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 13:31:40 InnoDB: Compressed tables use zlib 1.2.3
110719 13:31:40 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 15:24:30 [Note] Plugin 'FEDERATED' is disabled.
110719 15:24:30 InnoDB: The InnoDB memory heap is disabled
110719 15:24:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 15:24:30 InnoDB: Compressed tables use zlib 1.2.3
110719 15:24:30 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 15:24:45 [Note] Plugin 'FEDERATED' is disabled.
110719 15:24:45 InnoDB: The InnoDB memory heap is disabled
110719 15:24:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 15:24:45 InnoDB: Compressed tables use zlib 1.2.3
110719 15:24:45 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 15:26:15 [Note] Plugin 'FEDERATED' is disabled.
110719 15:26:15 InnoDB: The InnoDB memory heap is disabled
110719 15:26:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 15:26:15 InnoDB: Compressed tables use zlib 1.2.3
110719 15:26:15 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
110719 15:26:25 [Note] Plugin 'FEDERATED' is disabled.
110719 15:26:25 InnoDB: The InnoDB memory heap is disabled
110719 15:26:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 15:26:25 InnoDB: Compressed tables use zlib 1.2.3
110719 15:26:25 InnoDB: Initializing buffer pool, size =
runtime error R6002
- floating point support not loaded
Avatar do Utilizador
danshinigami
phpBB Portugal Novato
phpBB Portugal Novato
 
Mensagens: 31
Registado: 06/jul/2011, 18:54
Localização: Natal
Nacionalidade: Brasil

Re: Erro Sql

Mensagempor Vinny » 21/jul/2011, 23:37

Algum programa esta dando conflito com o MySQL.

Se for mudar de software, não esqueça de transferir os arquivos e os banco de dados usados. Além de easyPHP tem programas como XAMPP, WAMP, ou instalar os componentes separadamente.
Avatar do Utilizador
Vinny
Quadro de Honra
Quadro de Honra
 
Mensagens: 4979
Mensagens: 11
Registado: 31/jul/2009, 17:40
Localização: Macapá-Amapá
Nacionalidade: Brasil

Próximo

Voltar para Suporte Geral

Quem está ligado:

Utilizadores a ver este Fórum: Nenhum utilizador registado e 8 visitantes