search

kalcaddle / kodbox

kodbox is a file manager for web. It is a newly designed product based on kodexplorer. It is also a web code editor, which allows you to develop websites directly within the web browser.You can run kodbox either online or locally,on Linux, Windows or Mac based platforms
https://kodcloud.com
2.18k stars 373 forks source link

docker安装失败，mysql连接有问题 #169

Closed hguoguo closed 1 year ago

hguoguo commented 1 year ago

docker启动命令如下： docker run -d -p 7080:80 --name=kodbox -v /home/huaguoguo/docker/kodbox/data:/var/www/html -e MYSQL_DATABASE=kodbox -e MYSQL_USER=root -e MYSQL_PASSWORD=123456 -e MYSQL_SERVER=192.168.0.105 -e MYSQL_PORT=3806 kodcloud/kodbox image

mysql版本为8.0.33，验证方式为mysql_native_password，已确认连接信息无误

zbingege commented 1 year ago

near "(": syntax error[ SQL语句 ] :(SELECT sourceID,targetID,size FROM io_source where parentID=0 and targetID=1 and targetType=1 limit 1) 系统错误， 我是这个问题不知道你解决了吗？

Otajonov commented 1 year ago

Hi there. I am also having same problem after last update just now 🤷‍♂️

hguoguo commented 1 year ago

near "(": syntax error[ SQL语句 ] :(SELECT sourceID,targetID,size FROM io_source where parentID=0 and targetID=1 and targetType=1 limit 1) 系统错误， 我是这个问题不知道你解决了吗？

docker logs没有发现这种日志，请问容器内部有详细的日志吗

hguoguo commented 1 year ago

可能是我误改了配置，恢复后重启容器，现在报错是：

image
Otajonov commented 1 year ago

@hguoguo Hi friend. I needed just to reinstall, now it is working. !! But all data will be lost. I think it is database structure conflict which new version is requiring new columns that not existed in your old user row.

hguoguo commented 1 year ago

没明白你的意思，我在数据库create schema kodbox collate utf8mb4_bin; 没有其他操作

kalcaddle commented 1 year ago

near "(": syntax error[ SQL语句 ] :(SELECT sourceID,targetID,size FROM io_source where parentID=0 and targetID=1 and targetType=1 limit 1) 系统错误， 我是这个问题不知道你解决了吗？

sqlite的一个兼容问题,已兼容处理. 下载最新版安装即可.

KodCloud-dev commented 1 year ago

@hguoguo 相同步骤无法复现问题，请清空挂载目录，docker run 运行时去掉所有环境变量试下