xuchengsheng / wx-dump-4j Goto Github PK

环境:
操作系统: Windows 10 专业版
微信: 3.9.11.15(目前最新)
JDK: 1.8.0_341

点击 微信数据同步 返回部分数据乱码,如下图

点击 微信管理->联系人管理 页面无显示，后端抛 SQLException 异常 ，如下图

异常文本如下
`org.springframework.jdbc.UncategorizedSQLException:

Error querying database. Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)

The error may exist in com/xcs/wx/mapper/ContactLabelMapper.java (best guess)

The error may involve com.xcs.wx.mapper.ContactLabelMapper.selectList

The error occurred while executing a query

SQL: SELECT LabelId,LabelName FROM ContactLabel

Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)

; uncategorized SQLException; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel); nested exception is org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:93)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
at com.sun.proxy.$Proxy73.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy78.selectList(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.list(IService.java:406)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl.queryContactLabelAsList(ContactLabelRepositoryImpl.java:42)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl$$FastClassBySpringCGLIB$$fcaccbe2.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl$$EnhancerBySpringCGLIB$$3eafde96.queryContactLabelAsList()
at com.xcs.wx.service.impl.ContactServiceImpl.queryContactLabel(ContactServiceImpl.java:63)
at com.xcs.wx.controller.ContactController.label(ContactController.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)
at org.sqlite.core.DB.newSQLException(DB.java:1012)
at org.sqlite.core.DB.newSQLException(DB.java:1024)
at org.sqlite.core.DB.throwex(DB.java:989)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:45)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:25)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:535)
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:908)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:116)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:531)
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:328)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:369)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:88)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:90)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:60)
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
at com.sun.proxy.$Proxy96.prepare(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:90)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
at com.sun.proxy.$Proxy95.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
... 66 more
org.springframework.jdbc.UncategorizedSQLException:

Error querying database. Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)

The error may exist in com/xcs/wx/mapper/ContactLabelMapper.java (best guess)

The error may involve com.xcs.wx.mapper.ContactLabelMapper.selectList

The error occurred while executing a query

SQL: SELECT LabelId,LabelName FROM ContactLabel

Cause: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)

; uncategorized SQLException; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel); nested exception is org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:93)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
at com.sun.proxy.$Proxy73.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy78.selectList(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.list(IService.java:406)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl.queryContactLabelAsList(ContactLabelRepositoryImpl.java:42)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl.queryContactLabelAsMap(ContactLabelRepositoryImpl.java:32)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl$$FastClassBySpringCGLIB$$fcaccbe2.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
at com.xcs.wx.repository.impl.ContactLabelRepositoryImpl$$EnhancerBySpringCGLIB$$3eafde96.queryContactLabelAsMap()
at com.xcs.wx.service.impl.ContactServiceImpl.lambda$queryContact$0(ContactServiceImpl.java:38)
at java.util.Optional.map(Optional.java:215)
at com.xcs.wx.service.impl.ContactServiceImpl.queryContact(ContactServiceImpl.java:37)
at com.xcs.wx.controller.ContactController.list(ContactController.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: ContactLabel)
at org.sqlite.core.DB.newSQLException(DB.java:1012)
at org.sqlite.core.DB.newSQLException(DB.java:1024)
at org.sqlite.core.DB.throwex(DB.java:989)
at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
at org.sqlite.core.DB.prepare(DB.java:257)
at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:45)
at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:25)
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:535)
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:908)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:116)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:531)
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:328)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:369)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:88)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:90)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:60)
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
at com.sun.proxy.$Proxy96.prepare(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:90)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
at com.sun.proxy.$Proxy95.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
... 69 more
2024-06-12 20:18:45.198 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-17,FTSContact.db} inited
2024-06-12 20:18:45.198 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-9} closing ...
2024-06-12 20:18:45.199 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-9} closed
2024-06-12 20:18:45.199 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [FTSContact.db] success,
2024-06-12 20:18:45.199 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [FTSContact.db] success
2024-06-12 20:18:45.449 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-18,HardLinkImage.db} inited
2024-06-12 20:18:45.449 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-10} closing ...
2024-06-12 20:18:45.450 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-10} closed
2024-06-12 20:18:45.450 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [HardLinkImage.db] success,
2024-06-12 20:18:45.450 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [HardLinkImage.db] success
2024-06-12 20:18:45.699 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-19,HardLinkVideo.db} inited
2024-06-12 20:18:45.699 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-11} closing ...
2024-06-12 20:18:45.700 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-11} closed
2024-06-12 20:18:45.700 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [HardLinkVideo.db] success,
2024-06-12 20:18:45.700 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [HardLinkVideo.db] success
2024-06-12 20:18:46.193 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-20,MicroMsg.db} inited
2024-06-12 20:18:46.193 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-12} closing ...
2024-06-12 20:18:46.195 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-12} closed
2024-06-12 20:18:46.195 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [MicroMsg.db] success,
2024-06-12 20:18:46.195 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [MicroMsg.db] success
2024-06-12 20:18:47.932 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-21,MSG0.db} inited
2024-06-12 20:18:47.933 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-13} closing ...
2024-06-12 20:18:47.935 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-13} closed
2024-06-12 20:18:47.935 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [MSG0.db] success,
2024-06-12 20:18:47.935 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [MSG0.db] success
2024-06-12 20:18:47.941 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-22,MSG.db} inited
2024-06-12 20:18:47.941 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-14} closing ...
2024-06-12 20:18:47.964 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-14} closed
2024-06-12 20:18:47.964 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [MSG.db] success,
2024-06-12 20:18:47.964 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [MSG.db] success
2024-06-12 20:18:49.727 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-23,MSG1.db} inited
2024-06-12 20:18:49.727 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-15} closing ...
2024-06-12 20:18:49.730 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-15} closed
2024-06-12 20:18:49.731 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [MSG1.db] success,
2024-06-12 20:18:49.731 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [MSG1.db] success
2024-06-12 20:18:50.005 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-24,Sns.db} inited
2024-06-12 20:18:50.006 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-16} closing ...
2024-06-12 20:18:50.008 INFO 35616 --- [io-8080-exec-10] com.alibaba.druid.pool.DruidDataSource : {dataSource-16} closed
2024-06-12 20:18:50.009 INFO 35616 --- [io-8080-exec-10] c.b.d.d.d.DefaultDataSourceDestroyer : dynamic-datasource close the datasource named [Sns.db] success,
2024-06-12 20:18:50.009 INFO 35616 --- [io-8080-exec-10] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource - add a datasource named [Sns.db] success
2024-06-12 20:18:50.011 INFO 35616 --- [io-8080-exec-10] c.x.w.repository.impl.MsgRepositoryImpl : Start querying data:[MSG0.db][1718193239000]
2024-06-12 20:18:50.014 INFO 35616 --- [io-8080-exec-10] c.x.w.repository.impl.MsgRepositoryImpl : End querying data:[MSG0.db][1718193239000]
2024-06-12 20:18:50.014 INFO 35616 --- [io-8080-exec-10] c.x.w.repository.impl.MsgRepositoryImpl : Start querying data:[MSG1.db][1718193239000]
2024-06-12 20:18:50.019 INFO 35616 --- [io-8080-exec-10] c.x.w.repository.impl.MsgRepositoryImpl : End querying data:[MSG1.db][1718193239000]

`

运行后，一直处于同步状态，这是什么情况

如图所示 搜索到安卓的物理地址为7FFD183AA040
但密码存储的内存地址为233DFAFA970
我看两者相差了有百亿个bit 实在不明白这里的2000是怎么找出来的

大佬，有使用说明吗？怎么用？

微信的聊天数据库MSG0.db是不会实时更新的，每次启动微信的时候都会在Multi目录下创建MSG0.db-shm, MSG0.db-wal。而实时的聊天内容，只会暂时存到这两个文件里面，当退出微信的时候才将这两个文件合并到MSG0.db。这样就做不到定时解密数据库了。

不知道码主有没有好方法解决这个问题

恢复撤回消息这个功能可以实现吗

Active code page: 65001
正在启动 wx-dump-admin ...
错误: 找不到或无法加载主类 com.xcs.wx.WxDumpApplication
Press any key to continue . . .

项目应该是以数据为做统计，那朋友圈的数据；
1、以仅三天可见为例，是微信只返回了3天的数据，还是会有之前的数据呢？
2、开始没限制，朋友圈数据有的，后续设置仅三天可见，看到的数据是那些呢？
3、一个账号一开始就设置的仅三天可见，新好友应该可以看到之前的数据吗？

期待您的解答，不胜感激。

找回历史好友感觉列表不全，时间久远的是无法获取到了吗？比如几年前的

可选择导出所有联系人或指定联系人的朋友圈。导出格式为html。

我觉得好好看，想要收藏一下，啊哈哈哈哈

谢谢xuchengsheng提供这么棒的工具，这是我见过最清爽，功能最强大的vx消息导出工具了！

目前在导出联系人的时候，标签信息显示为数字，导出后不明白数字对应哪个标签，能否修正一下呢？

搜了好几个设置3天可见的好友，还是看不到之前的朋友圈啊

大佬加油

比如每个群在选定日期内有多少条消息，如果能区分小程序或关键字就更好了。
还有就是在群管理能否增加一个自定义备注，导出可以按照这个备注进行过滤。
感谢大佬。

微信管理-会话管理： 点一个会话 还没等响应完成 就去点别的会话就显示错乱了
如下图，游戏群的聊天记录显示到源码群啦

会话和朋友圈内的视频相关文件都是已过期或已被清理，无法正常展示。

会有一部分乱码，汉字，字母，符号都有可能出现，只有xml标签中的文本有这种情况，标签是正常的

前端文件，npm i，一直没反应，不知道是啥情况

错误提示：Something went wrong.
Minified React error #31; visit https://reactjs.org/docs/error-decoder.html?invariant=31&args[]=object%20with%20keys%20%7Btext%7D for the full message or use the non-minified dev environment for full errors and additional helpful warnings.

如题，导出的群聊记录中只有聊天人id，没有群昵称，能否实现二者的匹配？

start.bat启动文件后，点击数据库同步的时候，显示系统异常

首先非常感谢xuchengsheng提供这么好的工具。不知道是我的使用问题还是其他原因，如果好友对方为公司企业微信号的话，会话管理看不到详细聊天内容，好友管理看不到会话，也无法导出聊天记录。

使用场景： 最近刚从公司离职，和公司hr聊天记录准备备份一下以防背刺，发现无法导出，进而发现对方使用的是公司企业微信号加我的好友。

根据教程，启动start.bat报错没有db文件，文件夹中确实没有。

如图，是因为群组的名称导致创建文件失败了吗。附上群组名称如下

感谢作者解答！

什么时候加上发送消息的功能?

最近正好聊天记录丢了，mac上还有一版备份。。

日志如下

Active code page: 65001
正在启动 wx-dump-admin ...
JDK Version: 17.0.11
Spring Boot Version: 2.7.15

## ## ## ######## ## ## ## ## ######## ##

## ## ## ## ## ## ## ## ### ### ## ## ## ##

## ## ## ## ## ## ## ## #### #### ## ## ## ##

## ## ### ####### ## ## ## ## ## ### ## ######## ####### ## ##

## ## ## ## ## ## ## ## ## ## ## ######### ##

## ## ## ## ## ## ## ## ## ## ## ## ##

### ## ## ######## ####### ## ## ## ##

2024-06-30 17:15:02.819 INFO 30664 --- [ main] com.xcs.wx.WxDumpApplication : Starting WxDumpApplication using Java 17.0.11 on Jking with PID 30664 (C:\Users\max\Downloads\wx-dump-4j-bin.tar_5\wx-dump-4j-bin\lib\wx-dump-admin-1.0-SNAPSHOT.jar started by max in C:\Users\max\Downloads\wx-dump-4j-bin.tar_5\wx-dump-4j-bin\bin)
2024-06-30 17:15:02.826 INFO 30664 --- [ main] com.xcs.wx.WxDumpApplication : No active profile set, falling back to 1 default profile: "default"
2024-06-30 17:15:04.335 INFO 30664 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2024-06-30 17:15:04.347 INFO 30664 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2024-06-30 17:15:04.347 INFO 30664 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.79]
2024-06-30 17:15:04.506 INFO 30664 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2024-06-30 17:15:04.506 INFO 30664 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1630 ms
2024-06-30 17:15:04.830 WARN 30664 --- [ main] c.b.d.d.DynamicRoutingDataSource : dynamic-datasource initial loaded [0] datasource,Please add your primary datasource or check your configuration
2024-06-30 17:15:05.610 WARN 30664 --- [ main] c.b.m.core.metadata.TableInfoHelper : Can not find table primary key in Class: "com.xcs.wx.domain.SqliteMaster".
2024-06-30 17:15:05.611 WARN 30664 --- [ main] c.b.m.core.injector.DefaultSqlInjector : class com.xcs.wx.domain.SqliteMaster ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2024-06-30 17:15:06.798 INFO 30664 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''
2024-06-30 17:15:06.812 INFO 30664 --- [ main] com.xcs.wx.WxDumpApplication : Started WxDumpApplication in 4.375 seconds (JVM running for 4.72)
DONE successfully in 4602ms
Time: Sun Jun 30 17:15:06 CST 2024
╔════════════════════════════════════════════════════╗
║ App listening at: ║
║ > Local: http://localhost:8080
║ > Network: http://100.64.0.2:8080
║ ║
║ Now you can open browser with the above addresses↑ ║
╚════════════════════════════════════════════════════╝
2024-06-30 17:15:11.248 INFO 30664 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2024-06-30 17:15:11.248 INFO 30664 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2024-06-30 17:15:11.249 INFO 30664 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms

页面可以读取到微信进程，但是无法解密
报文请求返回
data:{"success":false,"errorCode":-1,"errorMessage":"获�微信秘钥失败，请���试。","page":null,"total":null,"showType":2,"data":null}
后台有个异常不知道是不是和这个有关系
2024-07-03 12:55:13.288 INFO 122132 --- [io-8080-exec-10] o.apache.coyote.http11.Http11Processor : Error parsing HTTP request header
Note: further occurrences of HTTP request parsing errors will be logged at DEBUG level.

java.lang.IllegalArgumentException: Invalid character found in the request target [/api/database/getDatabase?wxId=tes+%3D+650+%0A[I][2024-07-03+%2B8.0+12:55:05.903][114268,+123108][mars::mmext][net_st ]. The valid characters are defined in RFC 7230 and RFC 3986
at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:482) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:263) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.79.jar:9.0.79]
at java.base/java.lang.Thread.run(Thread.java:834) ~[na:na]

如题，内容太多，不好定位。

可以增加统计群聊信息 比如一个月之内发言前10名 或者某个词汇出现前10名，退群监控等

解密后的数据能否重新加密，并且被程序识别、读取？

• 查询一段时间内未发言的群友
• 查询一段时间内以发言数为排序的群友

打开列表会话提示
[SQLITE_ERROR] SQL error or missing database (no such table: MSG)

微信版本 3.9.10.19

非常非常建议：朋友圈增加特定人或者特定时间查找功能！！！

无

很强大👍🏻，小小疑问确认下