在 STS 中部署的 symphony,
报错:找不到 user 表。

[ERROR]-[2018-11-06 09:34:07]-[org.b3log.latke.repository.jdbc.JdbcRepository:490]: Query failed
java.sql.SQLSyntaxErrorException: Table 'b3log_symphony.symphony_user' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1025)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
    at org.b3log.latke.repository.jdbc.util.JdbcUtil.queryJson(JdbcUtil.java:159)
    at org.b3log.latke.repository.jdbc.util.JdbcUtil.queryJsonArray(JdbcUtil.java:130)
    at org.b3log.latke.repository.jdbc.JdbcRepository.get(JdbcRepository.java:486)
    at org.b3log.latke.repository.AbstractRepository.get(AbstractRepository.java:159)
    at org.b3log.latke.repository.Repository.getList(Repository.java:133)
    at org.b3log.symphony.repository.UserRepository.getAdmins(UserRepository.java:149)
    at org.b3log.symphony.repository.UserRepository_$$_jvst451_28._d10getAdmins(UserRepository_$$_jvst451_28.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.b3log.latke.ioc.JavassistMethodHandler.invoke(JavassistMethodHandler.java:126)
    at org.b3log.symphony.repository.UserRepository_$$_jvst451_28.getAdmins(UserRepository_$$_jvst451_28.java)
    at org.b3log.symphony.service.UserQueryService.getAdmins(UserQueryService.java:397)
    at org.b3log.symphony.service.UserQueryService_$$_jvst451_2b._d3getAdmins(UserQueryService_$$_jvst451_2b.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.b3log.latke.ioc.JavassistMethodHandler.invoke(JavassistMethodHandler.java:126)
    at org.b3log.symphony.service.UserQueryService_$$_jvst451_2b.getAdmins(UserQueryService_$$_jvst451_2b.java)
    at org.b3log.symphony.service.InitMgmtService.initSym(InitMgmtService.java:222)
    at org.b3log.symphony.service.InitMgmtService_$$_jvst451_40._d5initSym(InitMgmtService_$$_jvst451_40.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.b3log.latke.ioc.JavassistMethodHandler.invoke(JavassistMethodHandler.java:126)
    at org.b3log.symphony.service.InitMgmtService_$$_jvst451_40.initSym(InitMgmtService_$$_jvst451_40.java)
    at org.b3log.symphony.SymphonyServletListener.contextInitialized(SymphonyServletListener.java:89)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4643)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5109)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1429)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:944)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1429)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:944)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:261)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:350)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
[ERROR]-[2018-11-06 09:34:07]-[org.b3log.symphony.service.UserQueryService:399]: Gets admins failed
org.b3log.latke.repository.RepositoryException: java.sql.SQLSyntaxErrorException: Table 'b3log_symphony.symphony_user' doesn't exist
    at org.b3log.latke.repository.jdbc.JdbcRepository.get(JdbcRepository.java:492)
    at org.b3log.latke.repository.AbstractRepository.get(AbstractRepository.java:159)
    at org.b3log.latke.repository.Repository.getList(Repository.java:133)
    at org.b3log.symphony.repository.UserRepository.getAdmins(UserRepository.java:149)
    at org.b3log.symphony.repository.UserRepository_$$_jvst451_28._d10getAdmins(UserRepository_$$_jvst451_28.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.b3log.latke.ioc.JavassistMethodHandler.invoke(JavassistMethodHandler.java:126)
    at org.b3log.symphony.repository.UserRepository_$$_jvst451_28.getAdmins(UserRepository_$$_jvst451_28.java)
    at org.b3log.symphony.service.UserQueryService.getAdmins(UserQueryService.java:397)
    at org.b3log.symphony.service.UserQueryService_$$_jvst451_2b._d3getAdmins(UserQueryService_$$_jvst451_2b.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.b3log.latke.ioc.JavassistMethodHandler.invoke(JavassistMethodHandler.java:126)
    at org.b3log.symphony.service.UserQueryService_$$_jvst451_2b.getAdmins(UserQueryService_$$_jvst451_2b.java)
    at org.b3log.symphony.service.InitMgmtService.initSym(InitMgmtService.java:222)
    at org.b3log.symphony.service.InitMgmtService_$$_jvst451_40._d5initSym(InitMgmtService_$$_jvst451_40.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.b3log.latke.ioc.JavassistMethodHandler.invoke(JavassistMethodHandler.java:126)
    at org.b3log.symphony.service.InitMgmtService_$$_jvst451_40.initSym(InitMgmtService_$$_jvst451_40.java)
    at org.b3log.symphony.SymphonyServletListener.contextInitialized(SymphonyServletListener.java:89)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4643)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5109)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1429)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:944)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1429)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1419)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:944)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:261)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:350)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
Caused by: java.sql.SQLSyntaxErrorException: Table 'b3log_symphony.symphony_user' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1025)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
    at org.b3log.latke.repository.jdbc.util.JdbcUtil.queryJson(JdbcUtil.java:159)
    at org.b3log.latke.repository.jdbc.util.JdbcUtil.queryJsonArray(JdbcUtil.java:130)
    at org.b3log.latke.repository.jdbc.JdbcRepository.get(JdbcRepository.java:486)
    ... 57 more

  • Sym

    Sym 是一个用 Java 实现的现代化社区(论坛 / 社交网络 / 博客)平台,“下一代的社区系统,为未来而构建”。黑客派就是使用该系统搭建的 ❤️

    315 引用 • 3651 回帖 • 612 关注
  • Q&A

    提问之前请先看一下这篇文章 《提问的智慧》精读注解版,好的问题比好的答案更有价值。

    555 引用 • 3245 回帖 • 601 关注
感谢    关注    收藏    赞同    反对    举报    分享