This repository was archived by the owner on May 20, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 74
Issues: jacklightChen/ManageBooks
Author
Label
Projects
Milestones
Assignee
Sort
Issues list
message: "\r\n### Error updating database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: call library.new_book(?, ?, ?, ?, ?, ?, ?, ?, ?)\r\n### Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\n; uncategorized SQLException; SQL state [HY000]; error code [1449]; The user specified as a definer ('root'@'%') does not exist; nested exception is java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist"
#6
opened Jun 18, 2021 by
1024zzq
{"status":false,"total":0,"data":null,"message":"\r\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\r\n### The error may exist in file [D:\\Project\\ManageBooks\\target\\classes\\Mapper\\user.xml]\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: select manager_id as user_id, pass_wd, mname as user_name from manager where mname=? and pass_wd=?;\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist"}
#5
opened Nov 15, 2020 by
zhangxiann
ProTip!
Adding no:label will show everything without a label.