xuchengsheng / wx-dump-4j Goto Github PK
View Code? Open in Web Editor NEW一款基于Java开发的微信数据分析工具。
Home Page: https://wx.xxccss.com
License: MIT License
一款基于Java开发的微信数据分析工具。
Home Page: https://wx.xxccss.com
License: MIT License
环境:
操作系统: Windows 10 专业版
微信: 3.9.11.15(目前最新)
JDK: 1.8.0_341
点击 微信管理->联系人管理 页面无显示,后端抛 SQLException 异常 ,如下图
异常文本如下
`org.springframework.jdbc.UncategorizedSQLException:
; 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:
; 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]
`
大佬,有使用说明吗?怎么用?
微信的聊天数据库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天可见的好友,还是看不到之前的朋友圈啊
大佬加油
比如每个群在选定日期内有多少条消息,如果能区分小程序或关键字就更好了。
还有就是在群管理能否增加一个自定义备注,导出可以按照这个备注进行过滤。
感谢大佬。
前端文件,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,没有群昵称,能否实现二者的匹配?
首先非常感谢xuchengsheng提供这么好的工具。不知道是我的使用问题还是其他原因,如果好友对方为公司企业微信号的话,会话管理看不到详细聊天内容,好友管理看不到会话,也无法导出聊天记录。
使用场景: 最近刚从公司离职,和公司hr聊天记录准备备份一下以防背刺,发现无法导出,进而发现对方使用的是公司企业微信号加我的好友。
什么时候加上发送消息的功能?
最近正好聊天记录丢了,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
非常非常建议:朋友圈增加特定人或者特定时间查找功能!!!
无
很强大👍🏻,小小疑问确认下
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.