Ruoyi-cloud Integrated mybatis-plus Error: Unknown column ‘search_value‘ in ‘field list‘

Project scenario:
ruoyi cloud converts mybatis into mybatis plus, executes the querywrapper method, and always reminds of the error. Cause: java.sql.sqlsyntax errorexception: unknown column ‘search_ Value ‘in’ field list ‘
but the corresponding entity class did not find this field. After some efforts, the answer was found in an article, and finally the problem was solved!


Problem Description:

problem screenshot: 


Cause analysis:

because the database does not have this field, ruoyi cloud integrates baseentity, which contains this error field</ font>


Solution:

add annotation @tablefield (exist = false) to the corresponding entity class

Read More: