activiti mysql 报错_activiti节点代理人设置代理人、候选人报错nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLS...

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sys_user.id' in 'field list'

The error may exist in file [/Users/zilla/IdeaProjects/soft_dev_prac/len-sys/target/classes/mapper/SysUserMapper.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: select sys_user.id,sys_user.real_name,sys_user.username from sys_user sysuser inner join sys_role_user roleuser on sysuser.id = roleuser.user_id and roleuser.role_id = ? LIMIT ?

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sys_user.id' in 'field list'

; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sys_user.id' in 'field list'] with root cause