EvolutionAPI
ERROR [unhandledRejection] [object] error: relation "messages" does not exist
Welcome!
- [x] Yes, I have searched for similar issues on GitHub and found none.
What did you do?
Reabrindo a issue https://github.com/EvolutionAPI/evolution-api/issues/1223 pois o problema ainda persiste na ultima versão.
What did you expect?
.
What did you observe instead of what you expected?
.
Screenshots/Videos
No response
Which version of the API are you using?
v2.2.3
What is your environment?
Windows
Other environment specifications
.
If applicable, paste the log output
No response
Additional Notes
No response
Same error happening here!
What did you expect? No response
What did you observe instead of what you expected? No response
Screenshots/Videos No response
Which version of the API are you using? v2.2.3
What is your environment? Ubuntu/Docker
Other environment specifications No response
If applicable, paste the log output
[Evolution API] v2.2.3 212 - Fri May 09 2025 17:30:08 ERROR [unhandledRejection] [object] Error: getaddrinfo ENOTFOUND host at /evolution/node_modules/pg-pool/index.js:45:11 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) { errno: -3007, code: 'ENOTFOUND', syscall: 'getaddrinfo', hostname: 'host' }
Additional Notes No response
Recebe este erro ao enviar um audio via whatsapp web. O Evolution API recebe os audios/documentos mas não consegue enviar para o chatwoot. Testei outras entradas do Chatwoot e ele recebe os anexos normalmente.
Os erros que encontro no evolition são:
[Evolution API] v2.3.0 211 - Sat Jul 05 2025 17:20:46 VERBOSE [ChatwootService] [string] Found conversation to: [email protected], conversation ID: 17 [Evolution API] v2.3.0 211 - Sat Jul 05 2025 17:20:46 ERROR [ChatwootImport] [string] Error on getExistingSourceIds: error: relation "messages" does not exist [Evolution API] [mercadomock] v2.3.0 211 - Sat Jul 05 2025 17:20:46 LOG [ChannelStartupService] [string] Update not read messages [email protected] [Evolution API] [mercadomock] v2.3.0 211 - Sat Jul 05 2025 17:20:46 LOG [ChannelStartupService] [object]
[Evolution API] v2.3.0 211 - Sat Jul 05 2025 17:20:48 ERROR [unhandledRejection] [object]
{
origin: Promise {
[Evolution API] v2.3.0 211 - Sat Jul 05 2025 17:20:48 ERROR [unhandledRejection] [object]
error: relation "messages" does not exist
at /evolution/node_modules/pg-pool/index.js:45:11
at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
length: 106,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '8',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1449',
routine: 'parserOpenTable'
}
Instalação via Coolify, usando tunnel da Clodflare
@DavidsonGomes, alguma atualização? o nome da tabela da Evolution é "Message" e o ChatwootImport está procurando "messages"
No meu caso o problema era no tunnel da Cloudflare. Consegui resolver criando um tunnel a parte para o chatwoot . Neste tunnel eu adicionei o seguinte comando no stack
command: tunnel --no-autoupdate --protocol http2 run --token ${token}
Desta forma consegui resolver este problema.
