[BUG] cannot get instance's chat by POST /chat/findChats/instance_name

[nandobfer]

📋 Bug Description

when trying to get an instance's chats, by making a POST request to /chat/findChats/instance_name it returns a status 500 error:

[1] {
[1]   status: 500,
[1]   error: 'Internal Server Error',
[1]   response: {
[1]     message: '\n' +
[1]       'Invalid `prisma.$queryRaw()` invocation:\n' +
[1]       '\n' +
[1]       '\n' +
[1]       'Raw query failed. Code: `N/A`. Message: `N/A`'
[1]   }
[1] }

🔄 Steps to Reproduce

make a POST request to /chat/findChats/instance_name

✅ Expected Behavior

a list of chats to be returned

❌ Actual Behavior

it returns a status 500 error:

[1] {
[1]   status: 500,
[1]   error: 'Internal Server Error',
[1]   response: {
[1]     message: '\n' +
[1]       'Invalid `prisma.$queryRaw()` invocation:\n' +
[1]       '\n' +
[1]       '\n' +
[1]       'Raw query failed. Code: `N/A`. Message: `N/A`'
[1]   }
[1] }

🌍 Environment

• OS: Ubuntu 22.04
• Node.js version: v24.4.0
• Evolution API version: 2.2.3
• Database: MySQL 8.0.42
• Connection type: Baileys
• Docker: atendai/evolution-api
  CONFIG_SESSION_PHONE_VERSION=2.3000.1025110696

📋 Logs

📝 Additional Context

No response

[Tom225533]

Hi ! I would like to work on this. Can you assign me ?