EvolutionAPI
Prisma não esta criando coluna no Banco
Welcome!
- [x] Yes, I have searched for similar issues on GitHub and found none.
What did you do?
Via Docker, ao tentar cadastrar uma instancia no Evolution recebo erro de coluna inexistente na tabela.
Coluna wavoipToken
What did you expect?
Execução via docker.
What did you observe instead of what you expected?
Erro por falta de coluna na criação de instancia.
Screenshots/Videos
Which version of the API are you using?
Versão: 2.2.3
What is your environment?
Windows
Other environment specifications
Windows 11, Docker Image atendai/evolution-api:latest
If applicable, paste the log output
2025-05-01 17:53:35.643 | Deploying migrations for mysql 2025-05-01 17:53:35.645 | Database URL: 2025-05-01 17:53:36.933 | 2025-05-01 17:53:36.933 | > [email protected] db:deploy 2025-05-01 17:53:36.933 | > node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma" 2025-05-01 17:53:36.933 | 2025-05-01 17:53:38.872 | Environment variables loaded from .env 2025-05-01 17:53:38.874 | Prisma schema loaded from prisma/mysql-schema.prisma 2025-05-01 17:53:38.896 | Datasource "db": MySQL database "evolution" at "mysql:3306" 2025-05-01 17:53:38.994 | 2025-05-01 17:53:38.994 | 9 migrations found in prisma/migrations 2025-05-01 17:53:38.994 | 2025-05-01 17:53:39.207 | Applying migration 20240809105427_init2025-05-01 17:54:01.207 | Applying migration20240813153900_add_unique_index_for_remoted_jid_and_instance_in_contacts2025-05-01 17:54:03.098 | Applying migration20240814173138_add_ignore_jids_chatwoot2025-05-01 17:54:04.939 | Applying migration20240814214314_integrations_unification2025-05-01 17:54:12.188 | Applying migration20240821203259_add_postgres_migrations2025-05-01 17:54:18.189 | Applying migration20240824162012_add_type_on_integration_sessions2025-05-01 17:54:20.340 | Applying migration20240825131301_change_to_evolution_bot2025-05-01 17:54:25.160 | Applying migration20241001172800_add_message_status2025-05-01 17:54:27.386 | Applying migration20241108101333_fix_message_status_as_string2025-05-01 17:54:32.744 | 2025-05-01 17:54:32.750 | The following migration(s) have been applied: 2025-05-01 17:54:32.750 | 2025-05-01 17:54:32.750 | migrations/ 2025-05-01 17:54:32.750 | └─ 20240809105427_init/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20240813153900_add_unique_index_for_remoted_jid_and_instance_in_contacts/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20240814173138_add_ignore_jids_chatwoot/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20240814214314_integrations_unification/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20240821203259_add_postgres_migrations/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20240824162012_add_type_on_integration_sessions/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20240825131301_change_to_evolution_bot/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20241001172800_add_message_status/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | └─ 20241108101333_fix_message_status_as_string/ 2025-05-01 17:54:32.750 | └─ migration.sql 2025-05-01 17:54:32.750 | 2025-05-01 17:54:32.750 | All migrations have been successfully applied. 2025-05-01 17:54:32.928 | npm notice 2025-05-01 17:54:32.928 | npm notice New major version of npm available! 10.8.2 -> 11.3.0 2025-05-01 17:54:32.928 | npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.3.0 2025-05-01 17:54:32.928 | npm notice To update run: npm install -g [email protected] 2025-05-01 17:54:32.928 | npm notice 2025-05-01 17:54:32.941 | Migration succeeded 2025-05-01 17:54:33.332 | 2025-05-01 17:54:33.332 | > [email protected] db:generate 2025-05-01 17:54:33.332 | > node runWithProvider.js "npx prisma generate --schema ./prisma/DATABASE_PROVIDER-schema.prisma" 2025-05-01 17:54:33.332 | 2025-05-01 17:54:34.655 | Environment variables loaded from .env 2025-05-01 17:54:34.659 | Prisma schema loaded from prisma/mysql-schema.prisma 2025-05-01 17:54:37.036 | 2025-05-01 17:54:37.037 | ✔ Generated Prisma Client (v6.3.0) to ./node_modules/@prisma/client in 1.56s 2025-05-01 17:54:37.037 | 2025-05-01 17:54:37.037 | Start by importing your Prisma Client (See: https://pris.ly/d/importing-client) 2025-05-01 17:54:37.037 | 2025-05-01 17:54:37.037 | Tip: Easily identify and fix slow SQL queries in your app. Optimize helps you enhance your visibility: https://pris.ly/--optimize 2025-05-01 17:54:37.037 | 2025-05-01 17:54:37.247 | Prisma generate succeeded 2025-05-01 17:54:37.625 | 2025-05-01 17:54:37.625 | > [email protected] start:prod 2025-05-01 17:54:37.625 | > node dist/main 2025-05-01 17:54:37.625 | 2025-05-01 17:54:39.796 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:39 VERBOSE [CacheEngine] [string] RedisCache initialized for groups 2025-05-01 17:54:39.825 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:39 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt 2025-05-01 17:54:40.133 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 VERBOSE [CacheEngine] [string] RedisCache initialized for instance 2025-05-01 17:54:40.133 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt 2025-05-01 17:54:40.133 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 VERBOSE [CacheEngine] [string] RedisCache initialized for baileys 2025-05-01 17:54:40.133 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt 2025-05-01 17:54:40.158 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 INFO [WA MODULE] [string] Module - ON 2025-05-01 17:54:40.419 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 VERBOSE [Redis] [string] redis connecting 2025-05-01 17:54:40.442 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 VERBOSE [Redis] [string] redis ready 2025-05-01 17:54:40.507 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 INFO [PrismaRepository] [string] Repository:Prisma - ON 2025-05-01 17:54:40.519 | [Evolution API] v2.2.3 213 - Thu May 01 2025 17:54:40 LOG [SERVER] [string] HTTP - ON: 8080 2025-05-01 17:55:37.788 | npm error path /evolution 2025-05-01 17:55:37.788 | npm error command failed 2025-05-01 17:55:37.788 | npm error signal SIGTERM 2025-05-01 17:55:37.789 | npm error command sh -c node dist/main 2025-05-01 17:55:37.792 | npm error A complete log of this run can be found in: /root/.npm/_logs/2025-05-01T20_54_37_463Z-debug-0.log 2025-05-01 17:55:54.801 | Deploying migrations for mysql 2025-05-01 17:55:54.801 | Database URL: 2025-05-01 17:55:55.290 | 2025-05-01 17:55:55.290 | > [email protected] db:deploy 2025-05-01 17:55:55.290 | > node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma" 2025-05-01 17:55:55.290 | 2025-05-01 17:55:57.444 | Environment variables loaded from .env 2025-05-01 17:55:57.445 | Prisma schema loaded from prisma/mysql-schema.prisma 2025-05-01 17:55:57.480 | Datasource "db": MySQL database "evolution" at "mysql:3306" 2025-05-01 17:55:57.582 | 2025-05-01 17:55:57.582 | 9 migrations found in prisma/migrations 2025-05-01 17:55:57.582 | 2025-05-01 17:55:57.633 | 2025-05-01 17:55:57.634 | No pending migrations to apply. 2025-05-01 17:55:57.695 | Migration succeeded 2025-05-01 17:55:57.958 | 2025-05-01 17:55:57.958 | > [email protected] db:generate 2025-05-01 17:55:57.958 | > node runWithProvider.js "npx prisma generate --schema ./prisma/DATABASE_PROVIDER-schema.prisma" 2025-05-01 17:55:57.958 | 2025-05-01 17:55:59.564 | Environment variables loaded from .env 2025-05-01 17:55:59.569 | Prisma schema loaded from prisma/mysql-schema.prisma 2025-05-01 17:56:01.180 | 2025-05-01 17:56:01.180 | ✔ Generated Prisma Client (v6.3.0) to ./node_modules/@prisma/client in 871ms 2025-05-01 17:56:01.180 | 2025-05-01 17:56:01.180 | Start by importing your Prisma Client (See: https://pris.ly/d/importing-client) 2025-05-01 17:56:01.180 | 2025-05-01 17:56:01.180 | Tip: Want to turn off tips and other hints? https://pris.ly/tip-4-nohints 2025-05-01 17:56:01.180 | 2025-05-01 17:56:01.251 | ┌─────────────────────────────────────────────────────────┐ 2025-05-01 17:56:01.251 | │ Update available 6.3.0 -> 6.7.0 │ 2025-05-01 17:56:01.251 | │ Run the following to update │ 2025-05-01 17:56:01.251 | │ npm i --save-dev prisma@latest │ 2025-05-01 17:56:01.251 | │ npm i @prisma/client@latest │ 2025-05-01 17:56:01.251 | └─────────────────────────────────────────────────────────┘ 2025-05-01 17:56:01.402 | Prisma generate succeeded 2025-05-01 17:56:01.703 | 2025-05-01 17:56:01.704 | > [email protected] start:prod 2025-05-01 17:56:01.704 | > node dist/main 2025-05-01 17:56:01.704 | 2025-05-01 17:56:03.821 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:03 VERBOSE [CacheEngine] [string] RedisCache initialized for groups 2025-05-01 17:56:03.848 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:03 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt 2025-05-01 17:56:04.095 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 VERBOSE [CacheEngine] [string] RedisCache initialized for instance 2025-05-01 17:56:04.095 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt 2025-05-01 17:56:04.095 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 VERBOSE [CacheEngine] [string] RedisCache initialized for baileys 2025-05-01 17:56:04.095 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt 2025-05-01 17:56:04.114 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 INFO [WA MODULE] [string] Module - ON 2025-05-01 17:56:04.346 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 VERBOSE [Redis] [string] redis connecting 2025-05-01 17:56:04.371 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 VERBOSE [Redis] [string] redis ready 2025-05-01 17:56:04.425 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 INFO [PrismaRepository] [string] Repository:Prisma - ON 2025-05-01 17:56:04.439 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:04 LOG [SERVER] [string] HTTP - ON: 8080 2025-05-01 17:56:14.088 | create instance { 2025-05-01 17:56:14.088 | instanceName: 'teste', 2025-05-01 17:56:14.088 | integration: 'WHATSAPP-BAILEYS', 2025-05-01 17:56:14.088 | token: 'CF010366B267-4BF3-9D87-A70C1F781987', 2025-05-01 17:56:14.088 | number: '5583998877556' 2025-05-01 17:56:14.088 | } 2025-05-01 17:56:14.174 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:14 ERROR [InstanceController] [string] 2025-05-01 17:56:14.174 | InvalidS.integrationSession.update()invocation in 2025-05-01 17:56:14.174 | /evolution/dist/main.js:161:10171 2025-05-01 17:56:14.174 | 2025-05-01 17:56:14.174 | 158));let g="";d.bold&&(g+=""),d.italic&&(g+="_"),d.underline&&(g+="~");let m=${g}${u}${g.split("").reverse().join("")};return d.url&&(m=d.children[0]?.text?[${m}] 2025-05-01 17:56:14.174 | 159 (${d.url}):${d.url}),m}async function l(d,u,g,m,h,y,w,S){for(let E of m){if(E.type==="text"){let b="";for(let C of E.content.richText){for(let N of C.children)b+=w(N);b+=2025-05-01 17:56:14.174 | 160}if(b=b.replace(/**/g,"").replace(/__/,"").replace(/~~/,"").replace(/\n$/,""),b=b.replace(/\n$/,""),b.includes("[list]")){let C={number:s.split("@")[0],title:"",description:"",buttonText:"",footerText:"",sections:[]},N=b.match(/[title]([\s\S]?)(?=[description])/),=b.match(/[description]([\s\S]?)(?=[buttonText])/),x=b.match(/[buttonText]([\s\S]?)(?=[footerText])/),L=b.match(/[footerText]([\s\S]*?)(?=[menu])/);N&&(C.title=N[1].trim()),&&(C.description=[1].trim()),x&&(C.buttonText=x[1].trim()),L&&(C.footerText=L[1].trim());let W=b.match(/[menu]([\s\S]?)[/menu]/)?.[1];if(W){let G=W.match(/[section]([\s\S]?)(?=[section]|[/section]|[/menu])/g);G&&G.forEach(K=>{let V=K.match(/title: (.?)(?:\n|$)/)?.[1]?.trim(),$=K.match(/[row]([\s\S]?)(?=[row]|[/row]|[/section]|[/menu])/g),X={title:V,rows:$?.map(Cn=>({title:Cn.match(/title: (.?)(?:\n|$)/)?.[1]?.trim(),description:Cn.match(/description: (.?)(?:\n|$)/)?.[1]?.trim(),rowId:Cn.match(/rowId: (.?)(?:\n|$)/)?.[1]?.trim()}))||[]};C.sections.push(X)})}await d.listMessage(C)}else if(b.includes("[buttons]")){let C={number:s.split("@")[0],thumbnailUrl:void 0,title:"",description:"",footer:"",buttons:[]},N=b.match(/[thumbnailUrl]([\s\S]?)(?=[title])/),=b.match(/[title]([\s\S]?)(?=[description])/),x=b.match(/[description]([\s\S]?)(?=[footer])/),L=b.match(/[footer]([\s\S]?)(?=[(?:reply|pix|copy|call|url))/);&&(C.title=[1].trim()),N&&(C.thumbnailUrl=N[1].trim()),x&&(C.description=x[1].trim()),L&&(C.footer=L[1].trim());let W={reply:/[reply]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,pix:/[pix]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,copy:/[copy]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,call:/[call]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,url:/[url]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g};for(let[G,K]of Object.entries(W)){let V;for(;(V=K.exec(b))!==null;){let $=V[1].trim(),X={type:G};switch(G){case"pix":X.currency=$.match(/currency: (.?)(?:\n|$)/)?.[1]?.trim(),X.name=$.match(/name: (.?)(?:\n|$)/)?.[1]?.trim(),X.keyType=$.match(/keyType: (.?)(?:\n|$)/)?.[1]?.trim(),X.key=$.match(/key: (.?)(?:\n|$)/)?.[1]?.trim();break;case"reply":X.displayText=$.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),X.id=$.match(/id: (.?)(?:\n|$)/)?.[1]?.trim();break;case"copy":X.displayText=$.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),X.copyCode=$.match(/copyCode: (.?)(?:\n|$)/)?.[1]?.trim();break;case"call":X.displayText=$.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),X.phoneNumber=$.match(/phone: (.?)(?:\n|$)/)?.[1]?.trim();break;case"url":X.displayText=$.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),X.url=$.match(/url: (.?)(?:\n|$)/)?.[1]?.trim();break}Object.keys(X).length>1&&C.buttons.push(X)}}await d.buttonMessage(C)}else await d.textMessage({number:s.split("@")[0],delay:g?.delayMessage||1e3,text:b},!1);H("/message/sendText")}E.type==="image"&&(await d.mediaMessage({number:s.split("@")[0],delay:g?.delayMessage||1e3,mediatype:"image",media:E.content.url},null,!1),H("/message/sendMedia")),E.type==="video"&&(await d.mediaMessage({number:s.split("@")[0],delay:g?.delayMessage||1e3,mediatype:"video",media:E.content.url},null,!1),H("/message/sendMedia")),E.type==="audio"&&(await d.audioWhatsapp({number:s.split("@")[0],delay:g?.delayMessage||1e3,encoding:!0,audio:E.content.url},!1),H("/message/sendWhatsAppAudio"));let I=a(y,E.id);I&&await new Promise(b=>setTimeout(b,I1e3))}if(console.log("input",h),h){if(h.type==="choice input"){let E="",I=h.items;for(let b of I)E+=\u25B6\uFE0F ${b.content} 2025-05-01 17:56:14.174 | → 161 ;if(E=E.replace(/\n$/,""),E.includes("[list]")){let b={number:s.split("@")[0],title:"",description:"",buttonText:"",footerText:"",sections:[]},C=E.match(/[title]([\s\S]?)(?=[description])/),N=E.match(/[description]([\s\S]?)(?=[buttonText])/),_=E.match(/[buttonText]([\s\S]?)(?=[footerText])/),x=E.match(/[footerText]([\s\S]?)(?=[menu])/);C&&(b.title=C[1].trim()),N&&(b.description=N[1].trim()),&&(b.buttonText=[1].trim()),x&&(b.footerText=x[1].trim());let L=E.match(/[menu]([\s\S]?)[/menu]/)?.[1];if(L){let W=L.match(/[section]([\s\S]?)(?=[section]|[/section]|[/menu])/g);W&&W.forEach(G=>{let K=G.match(/title: (.?)(?:\n|$)/)?.[1]?.trim(),V=G.match(/[row]([\s\S]?)(?=[row]|[/row]|[/section]|[/menu])/g),$={title:K,rows:V?.map(X=>({title:X.match(/title: (.?)(?:\n|$)/)?.[1]?.trim(),description:X.match(/description: (.?)(?:\n|$)/)?.[1]?.trim(),rowId:X.match(/rowId: (.?)(?:\n|$)/)?.[1]?.trim()}))||[]};b.sections.push($)})}await d.listMessage(b)}else if(E.includes("[buttons]")){let b={number:s.split("@")[0],thumbnailUrl:void 0,title:"",description:"",footer:"",buttons:[]},C=E.match(/[thumbnailUrl]([\s\S]?)(?=[title])/),N=E.match(/[title]([\s\S]?)(?=[description])/),=E.match(/[description]([\s\S]?)(?=[footer])/),x=E.match(/[footer]([\s\S]?)(?=[(?:reply|pix|copy|call|url))/);N&&(b.title=N[1].trim()),C&&(b.thumbnailUrl=C[1].trim()),&&(b.description=_[1].trim()),x&&(b.footer=x[1].trim());let L={reply:/[reply]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,pix:/[pix]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,copy:/[copy]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,call:/[call]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g,url:/[url]([\s\S]?)(?=[(?:reply|pix|copy|call|url)|$)/g};for(let[W,G]of Object.entries(L)){let K;for(;(K=G.exec(E))!==null;){let V=K[1].trim(),$={type:W};switch(W){case"pix":$.currency=V.match(/currency: (.?)(?:\n|$)/)?.[1]?.trim(),$.name=V.match(/name: (.?)(?:\n|$)/)?.[1]?.trim(),$.keyType=V.match(/keyType: (.?)(?:\n|$)/)?.[1]?.trim(),$.key=V.match(/key: (.?)(?:\n|$)/)?.[1]?.trim();break;case"reply":$.displayText=V.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),$.id=V.match(/id: (.?)(?:\n|$)/)?.[1]?.trim();break;case"copy":$.displayText=V.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),$.copyCode=V.match(/copyCode: (.?)(?:\n|$)/)?.[1]?.trim();break;case"call":$.displayText=V.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),$.phoneNumber=V.match(/phone: (.?)(?:\n|$)/)?.[1]?.trim();break;case"url":$.displayText=V.match(/displayText: (.?)(?:\n|$)/)?.[1]?.trim(),$.url=V.match(/url: (.*?)(?:\n|$)/)?.[1]?.trim();break}Object.keys($).length>1&&b.buttons.push($)}}await d.buttonMessage(b)}else await d.textMessage({number:s.split("@")[0],delay:g?.delayMessage||1e3,text:E},!1);H("/message/sendText")}await S.integrationSession.update(
2025-05-01 17:56:14.174 | The column wavoipToken does not exist in the current database.
2025-05-01 17:56:14.184 | [Evolution API] v2.2.3 212 - Thu May 01 2025 17:56:14 WARN [WAMonitoringService] [string] Instance "teste" - REMOVED
2025-05-01 18:06:11.847 | npm error path /evolution
2025-05-01 18:06:11.849 | npm error command failed
2025-05-01 18:06:11.849 | npm error signal SIGTERM
2025-05-01 18:06:11.851 | npm error command sh -c node dist/main
2025-05-01 18:06:11.862 | npm error A complete log of this run can be found in: /root/.npm/_logs/2025-05-01T20_56_01_570Z-debug-0.log
2025-05-01 18:06:12.705 | Deploying migrations for mysql
2025-05-01 18:06:12.705 | Database URL:
2025-05-01 18:06:13.111 |
2025-05-01 18:06:13.111 | > [email protected] db:deploy
2025-05-01 18:06:13.111 | > node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
2025-05-01 18:06:13.111 |
2025-05-01 18:06:14.580 | Environment variables loaded from .env
2025-05-01 18:06:14.582 | Prisma schema loaded from prisma/mysql-schema.prisma
2025-05-01 18:06:14.600 | Datasource "db": MySQL database "evolution" at "mysql:3306"
2025-05-01 18:06:14.693 |
2025-05-01 18:06:14.693 | 9 migrations found in prisma/migrations
2025-05-01 18:06:14.693 |
2025-05-01 18:06:14.730 |
2025-05-01 18:06:14.731 | No pending migrations to apply.
2025-05-01 18:06:14.796 | Migration succeeded
2025-05-01 18:06:15.084 |
2025-05-01 18:06:15.084 | > [email protected] db:generate
2025-05-01 18:06:15.084 | > node runWithProvider.js "npx prisma generate --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
2025-05-01 18:06:15.084 |
2025-05-01 18:06:16.268 | Environment variables loaded from .env
2025-05-01 18:06:16.273 | Prisma schema loaded from prisma/mysql-schema.prisma
2025-05-01 18:06:17.539 |
2025-05-01 18:06:17.539 | ✔ Generated Prisma Client (v6.3.0) to ./node_modules/@prisma/client in 547ms
2025-05-01 18:06:17.539 |
2025-05-01 18:06:17.539 | Start by importing your Prisma Client (See: https://pris.ly/d/importing-client)
2025-05-01 18:06:17.539 |
2025-05-01 18:06:17.539 | Help us improve the Prisma ORM for everyone. Share your feedback in a short 2-min survey: https://pris.ly/orm/survey/release-5-22
2025-05-01 18:06:17.539 |
2025-05-01 18:06:17.776 | Prisma generate succeeded
2025-05-01 18:06:18.020 |
2025-05-01 18:06:18.020 | > [email protected] start:prod
2025-05-01 18:06:18.020 | > node dist/main
2025-05-01 18:06:18.020 |
2025-05-01 18:06:19.621 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 VERBOSE [CacheEngine] [string] RedisCache initialized for groups
2025-05-01 18:06:19.640 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt
2025-05-01 18:06:19.827 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 VERBOSE [CacheEngine] [string] RedisCache initialized for instance
2025-05-01 18:06:19.827 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt
2025-05-01 18:06:19.827 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 VERBOSE [CacheEngine] [string] RedisCache initialized for baileys
2025-05-01 18:06:19.827 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt
2025-05-01 18:06:19.845 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:19 INFO [WA MODULE] [string] Module - ON
2025-05-01 18:06:20.027 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:20 VERBOSE [Redis] [string] redis connecting
2025-05-01 18:06:20.058 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:20 VERBOSE [Redis] [string] redis ready
2025-05-01 18:06:20.100 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:20 INFO [PrismaRepository] [string] Repository:Prisma - ON
2025-05-01 18:06:20.112 | [Evolution API] v2.2.3 212 - Thu May 01 2025 18:06:20 LOG [SERVER] [string] HTTP - ON: 8080
2025-05-01 18:06:35.474 | create instance {
2025-05-01 18:06:35.474 | instanceName: 'teste',
2025-05-01 18:06:35.474 | integration: 'WHATSAPP-BAILEYS',
2025-05-01 18:06:35.474 | token: 'AEBBF578B912-4A07-8218-4143A74ABD81',
2025-05-01 18:06:35.474 | number: '5583998877556'
2025-05-01 18:06:35.474 | }`
Additional Notes
Variaveis:
`# mysql MYSQL_ROOT_PASSWORD=teste123 MYSQL_DATABASE=evolution MYSQL_USER=admin MYSQL_PASSWORD=teste123
n8n
N8N_BASIC_AUTH_ACTIVE=true N8N_BASIC_AUTH_USER=n8n_admin N8N_BASIC_AUTH_PASSWORD=Q8r!4Tz6YmN3
DB_TYPE=mysqldb DB_MYSQLDB_HOST=mysql DB_MYSQLDB_PORT=3306 DB_MYSQLDB_DATABASE=${MYSQL_DATABASE} DB_MYSQLDB_USER=${MYSQL_USER} DB_MYSQLDB_PASSWORD=${MYSQL_PASSWORD}
evolution-api
AUTHENTICATION_TYPE = apikey AUTHENTICATION_API_KEY=FA17D8F88E3A5FFE842988759478C DATABASE_ENABLED=false DATABASE_PROVIDER=mysql DATABASE_CONNECTION_URI=mysql://${MYSQL_USER}:${MYSQL_PASSWORD}@mysql:3306/${MYSQL_DATABASE} DATABASE_CONNECTION_CLIENT_NAME=evolution_exchange DATABASE_SAVE_DATA_INSTANCE=true DATABASE_SAVE_DATA_NEW_MESSAGE=true DATABASE_SAVE_MESSAGE_UPDATE=true DATABASE_SAVE_DATA_CONTACTS=true DATABASE_SAVE_DATA_CHATS=true DATABASE_SAVE_DATA_LABELS=true DATABASE_SAVE_DATA_HISTORIC=true
Redis (evolution-api)
CACHE_REDIS_ENABLED=true CACHE_REDIS_URI=redis://redis:6379/6 CACHE_REDIS_PREFIX_KEY=evolution CACHE_REDIS_SAVE_INSTANCES=false
Cache local (evolution-api)
CACHE_LOCAL_ENABLED=false `
Eu tive problemas similares, passei horas a revirar o que fiz de errado, troquei para o postgres e o problema foi resolvido. Altere para o postgres e veja se resolve o problema.
@TilsonM17 gerei a tabela de acordo com o Prisma, o ponto é entender se isso esta com erro dentro da ultima versão disponivel ou se foi um erro pontual em minha instalação.
Boa tarde, o erro está na api mesmo. na hora de instalar as tabelas no mysql no final da migração dá este erro:
-- AlterTable
ALTER TABLE Chat ADD COLUMN unreadMessages INTEGER NOT NULL DEFAULT 0,
MODIFY createdAt TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
MODIFY updatedAt TIMESTAMP NULL;
Mensagem do MySQL: Documentação #1060 - Nome da coluna 'unreadMessages' duplicado
