648540858 / wvp-GB28181-pro

WEB VIDEO PLATFORM是一个基于GB28181-2016标准实现的网络视频平台,支持NAT穿透,支持海康、大华、宇视等品牌的IPC、NVR、DVR接入。支持国标级联,支持rtsp/rtmp等视频流转发到国标平台,支持rtsp/rtmp等推流转发到国标平台。
https://doc.wvp-pro.cn
MIT License
4.59k stars 1.38k forks source link

合并2.7.1分支后,SQL建表语句好像不匹配 #1471

Closed penghd closed 1 month ago

penghd commented 1 month ago

描述错误

SQL: INSERT INTO wvp_media_server (id,ip,hook_ip,sdp_ip,stream_ip,http_port,http_ssl_port,rtmp_port,rtmp_ssl_port,rtp_proxy_port,rtsp_port,flv_port,flv_ssl_port,ws_flv_port,ws_flv_ssl_port,rtsp_ssl_port,auto_config,secret,rtp_enable,rtp_port_range,send_rtp_port_range,record_assist_port,record_day,record_path,default_server,type,create_time,update_time,transcode_suffix,hook_alive_interval) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Cause: java.sql.SQLSyntaxErrorException: Unknown column 'type' in 'field list'

缺flv_port,ws_port,type等多个字段,手工按报错加上5个字段后启动成功 但前端页面登录又报:

SQL: insert into wvp_log ( name,type,uri,address,result,timing,username,create_time) values (?, ?, ?, ?, ?, ?, ?, ?)

Cause: java.sql.SQLException: Incorrect string value: '\xE7\x99\xBB\xE5\xBD\x95' for column 'name' at row 1

如何复现 重新git clone项目,使用code中“数据库”中的代码建表,启动报错

648540858 commented 1 month ago

已修复