go-admin-team/go-admin

前后端正常启动,登录直接报错,无法扫描created_at,且没有更改任何代码

JeasonLaung opened this issue · 1 comments

** 报错信息 **

2023-06-11 23:22:56.867+0800 trace 7a45dfe9-1c78-4509-a727-703153ff4586 /Users/*****/Desktop/code/go-pro/go-admin/common/middleware/handler/login.go:17 sql: Scan error on column index 16, name "created_at": unsupported Scan, storing driver.Value type []uint8 into type *time.Time [1.214ms] [rows:1] SELECT * FROM `sys_user` WHERE (username = 'admin'  and status = '2') AND `sys_user`.`deleted_at` IS NULL ORDER BY `sys_user`.`user_id` LIMIT 1
2023-06-11 23:22:56.867+0800 handler/login.go:19 error 7a45dfe9-1c78-4509-a727-703153ff4586 get user error, sql: Scan error on column index 16, name "created_at": unsupported Scan, storing driver.Value type []uint8 into type *time.Time
2023-06-11 23:22:56.867+0800 warn 7a45dfe9-1c78-4509-a727-703153ff4586 admin login failed!

** 描述 **
前后端正常启动,登录直接报错,无法扫描created_at,且没有更改任何代码。希望修复,感谢大大

** 环境 **
mysql 8.0.30
redis 7.0.4
go 1.19
system macos

已解决,settings.yml添加paraseTime=True即可。

source: username:password@tcp(127.0.0.1:3306)/go-admin?charset=utf8mb4&parseTime=True