CodePhiliaX / Chat2DB

🔥🔥🔥AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
http://chat2db.ai
Apache License 2.0
14.97k stars 1.67k forks source link

Bug: OpenAI doesnt work even when chat2db:latest docker successfully run #1123

Open Slach opened 8 months ago

Slach commented 8 months ago

Chat2DB Version

3.1.19

Describe the bug

image

in docker

2024-01-22 08:09:34.512  INFO 1 --- [io-10824-exec-6] a.c.server.web.start.log.EasyLogSink    .69 : 4a1581adac814bb18d31313428aab606 | http : GET|/api/config/system_config/ai|61||*"su*ces*":t*ue,*err*rCo*e":*ull*"er*orM*ssa*e":*ull*"er*orD*tai*":n*ll,*sol*tio*Lin*":n*ll,*dat*":{*api*ey"*"sk*z0Z*3Nj*vO5*DmG*EZR*T3B*bkF*sZM*Rqx*NXq*qKS*teE*","*ecr*tKe*":"*,"a*iHo*t":*","*ttp*rox*Hos*":"*,"h*tpP*oxy*ort*:""*"ai*qlS*urc*":"*PEN*I",*str*am"*tru*,"m*del*:""*,"t*ace*d":*ull*

Apply also works image

2024-01-22 08:10:41.393  INFO 1 --- [io-10824-exec-7] a.c.server.web.start.log.EasyLogSink    .69 : 18a4762bc2c74642ab90039a5bd27c76 | http : POST|/api/config/system_config/ai|195|*"ap*Key*:"sXXXXX",*sec*etK*y":*","*piH*st"*"",*htt*Pro*yHo*t":*","*ttp*rox*Por*":"*,"a*Sql*our*e":*OPE*AI"*"st*eam*:tr*e,"*ode*":"*}|*"su*ces*":t*ue,*err*rCo*e":*ull*"er*orM*ssa*e":*ull*"er*orD*tai*":n*ll,*sol*tio*Lin*":n*ll,*tra*eId*:nu*l}

but when i successfully created ClickHouse datasource I can't get any text to sql, just nothing happens

image

2024-01-22 08:12:59.019  INFO 1 --- [io-10824-exec-2] a.c.s.w.s.c.c.Chat2dbWebMvcConfigurer   .141 : 4165791ae9ed47f6a52134d38bb43888 | 访问host:127.0.0.1:10824,connection:keep-alive,sec-ch-ua:"Not?A_Brand";v="8", "Chromium";v="108",accept:text/event-stream,uid:b4c51db9-3356-4596-ac67-58a8f41854bd,dbhub:null,sec-ch-ua-mobile:?0,user-agent:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) chat2db/3.1.19 Chrome/108.0.5359.215 Electron/22.3.27 Safari/537.36,sec-ch-ua-platform:"Windows",sec-fetch-site:cross-site,sec-fetch-mode:cors,sec-fetch-dest:empty,accept-encoding:gzip, deflate, br,accept-language:en-US,,http://127.0.0.1:10824/api/ai/chat需要登录
2024-01-22 08:12:59.022  INFO 1 --- [io-10824-exec-2] a.c.server.web.start.log.EasyLogSink    .69 : 4165791ae9ed47f6a52134d38bb43888 | http : GET|/api/ai/chat?message=show+top+commenters+in+2023+and+2024+from+github_events+table&promptType=NL_2_SQL&dataSourceId=2|4||null:[166]

What i'm doing wrong?

Slach commented 7 months ago

@miahemu could you share version number or commit which show us bug really fixed?

miahemu commented 7 months ago

@miahemu could you share version number or commit which show us bug really fixed?

Sorry, we have fixed the problem that custom AI cannot be used. You are talking about OpenAI. I made a mistake.