You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
2024/05/06 02:39:25 D:/workspace/golang/src/gin-vue-admin/server/initialize/gorm.go:34 Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') COMMENT '',`img` varchar(191) COMMENT '',`meiju` enum('t1','t2','t3','t4') COM' at line 1
[0.503ms] [rows:0] CREATE TABLE `material` (`id` bigint unsigned AUTO_INCREMENT,`created_at` datetime(3) NULL,`updated_at` datetime(3) NULL,`deleted_at` datetime(3) NULL,`status` boolean COMMENT '物料的启用状态',`test` enum() COMMENT '',`img` varchar(191) COMMENT '',`meiju` enum('t1','t2','t3','t4') COMMENT '',`created_by` bigint unsigned COMMENT '创建者',`updated_by` bigint unsigned COMMENT '更新者',`deleted_by` bigint unsigned COMMENT '删除者',PRIMARY KEY (`id`),INDEX `idx_material_deleted_at` (`deleted_at`))
[github.com/flipped-aurora/gin-vue-admin/server]2024/05/06 - 02:39:25.850 error D:/workspace/golang/src/gin-vue-admin/server/initialize/gorm.go:59 register table failed {"error": "Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') COMMENT '',`img` varchar(191) COMMENT '',`meiju` enum('t1','t2','t3','t4') COM' at line 1"}
gin-vue-admin 版本
2.6.3
Node 版本
v20.11.1
Golang 版本
go 1.22
是否依旧存在
可以
bug描述
1.自动化代码新增字段时,选择枚举,不写任何值
注意看 enum() ,这里导致的报错,解决方法在括号里面一对单引号即可 enum('')
修改建议
可增加判断是否为空,增加单引号,亦或改为必填,不能为空
The text was updated successfully, but these errors were encountered: