René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Erro na evolutionAPI com mysql","articleBody":"# Issue: Evolution API v2.3.6 MySQL Syntax Errors\n\nHello everyone, I’m looking for some technical support. I attempted to install **Evolution API v2.3.6** using **MySQL 8.0**, but I am encountering SQL syntax errors that appear to be internal conflicts between the API and the database engine.\n\n---\n\n### 🛠️ Environment \u0026 Steps Taken\nI set up the environment via **Docker Compose** using the official Evolution image, Redis, and MySQL (Percona 8.0). I configured the `.env` file following the official documentation, setting:\n\n* `DATABASE_PROVIDER=mysql`\n* `DATABASE_CONNECTION_URI` (pointing correctly to the MySQL container).\n\n---\n\n### ❌ The Bug\nWhile the API initializes, it crashes during basic operations (saving messages or querying the database) with two primary errors:\n\n#### 1. Syntax Error (PostgreSQL Query on MySQL)\n\u003e **Raw query failed. Code: 1064.** \u003e *Message:* `You have an error in your SQL syntax; check the manual... near '\"Message\" WHERE \"instanceId\" = ? AND \"key\"-\u003e\u003e'id' = '`\n\n* **Observation:** The error shows the API is attempting to use double quotes (`\"Message\"`) and the JSON operator (`-\u003e\u003e`), which are specific to **PostgreSQL**, despite the provider being explicitly set to MySQL.\n\n#### 2. Schema Error (Missing `lid` field)\n\u003e **Invalid `this.cache.delete()` invocation...** \u003e `Unknown argument lid. Did you mean id?`\n\n* **Observation:** It seems Prisma did not create the `lid` column in MySQL, or the caching logic is attempting to access a field that does not exist in the schema generated for this specific database type.\n\n---\n\n### 🔍 Debugging Procedures Already Performed\n* Wiped all Docker volumes and rebuilt from scratch.\n* Attempted to force variables: `DATABASE_TYPE=mysql` and `DATABASE_CONNECTION_CLIENT_NAME=mysql`.\n* Verified that the database is \"ready for connections\" before the API service starts.\n\n---\n\n### ❓ Questions\n1.  Has anyone successfully run **v2.3.6 stable** with MySQL?\n2.  Is there a specific configuration to prevent Prisma from injecting Postgres-specific syntax into raw queries when the provider is MySQL?","author":{"url":"https://github.com/diogoosz","@type":"Person","name":"diogoosz"},"datePublished":"2025-12-31T21:27:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2344/evolution-api/issues/2344"}