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:

• [Solved] Mybatis Error: attempting to get column ‘XX’ from result set
• [Solved] JavaErrors_mybatis collection column Pass Value Error
• [Solved] Error:maven-resources-production:ruoyi-ywjs: java.lang.NegativeArraySizeException
• [Solved] Mybatis.generator error: Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2
• [Solved] Mybatis Error: Could not find resource mybatis-conf.xml
• [Solved] Tk-Mybatis Error: tk.mybatis.mapper.MapperException:
• [Solved] mybatis plus Insert Error: mybatis plus Error setting null for parameter #1 with JdbcType OTHER
• Mybatis Error: All elements are null [How to Solve]
• Spring integrated HBase error [How to Solve]
• Mybatis single parameter pass in exception (How to Fix)
• [Solved] spring boot integrated PageHelper Error
• Springboot startup error: Field elasticsearchRestTemplate in cn.lili.modules.material.serviceImpl.QrMaterialServiceImpl required a bean of type
• Mybatis plus paging Plugin and Auto-fill
• [How to Solve]Repeated column in mapping for entity,should be mapped with insert=“false“ update=“false“
• [Solved] SpringBoot Project Startup Error: Field userMapper in com.demo.controller.MemberController required a bean of type ‘c
• [Solved] Scala error: type mismatch; found : java.util.List[?0] required: java.util.List[B]
• Spring Cloud Hoxton.SR9 gateway and reactor-netty 0.9.0.RELEASE is Incompatible [How to Solve]
• Mybatis query error: Exception in thread “main” org.apache.ibatis.exceptions.PersistenceException…
• Spring cloud remote connect Nacos error [How to Solve]
• mybatis-plus Common Error and Their Solution