go-admin-team / go-admin

基于Gin + Vue + Element UI & Arco Design & Ant Design 的前后端分离权限管理系统脚手架(包含了:多租户的支持,基础用户管理功能,jwt鉴权,代码生成器,RBAC资源控制,表单构建,定时任务等)3分钟构建自己的中后台项目;项目文档》:https://www.go-admin.pro V2 Demo: https://vue2.go-admin.dev V3 Demo: https://vue3.go-admin.dev Antd 订阅版:https://antd.go-admin.pro
https://www.go-admin.pro
MIT License
11.15k stars 2.32k forks source link

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

Closed JeasonLaung closed 1 year ago

JeasonLaung commented 1 year ago

报错信息

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

JeasonLaung commented 1 year ago

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

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