SERP Hacker support forum - serposcope

Support forum for open-source softwares built by serphacker.com : serposcope the rank checker.

You are not logged in.

#1 2016-11-23 08:09:32

pierreb
Member
Registered: 2016-11-23
Posts: 4

Bug interface

Bonjour à tous,

Suite à la migration en version 2.6, je n'arrive plus à avoir, en page d'accueil, la liste des projets avec les récapitulatifs de chaque groupe.
Dans les logs, j'ai le message suivant :
[2016-11-23 08:56:01,220] [qtp1789550256-14] ERROR c.s.s.d.AbstractDB - SQLError
com.querydsl.core.QueryException: Caught SQLSyntaxErrorException for select `GOOGLE_TARGET_SUMMARY`.`GOOGLE_TARGET_ID`, `GOOGLE_TARGET_SUMMARY`.`GROUP_ID`, `GOOGLE_TARGET_SUMMARY`.`PREVIOUS_SCORE`, `GOOGLE_TARGET_SUMMARY`.`RUN_ID`, `GOOGLE_TARGET_SUMMARY`.`SCORE`, `GOOGLE_TARGET_SUMMARY`.`TOP_IMPROVEMENTS`, `GOOGLE_TARGET_SUMMARY`.`TOP_LOSTS`, `GOOGLE_TARGET_SUMMARY`.`TOP_RANKS`, `GOOGLE_TARGET_SUMMARY`.`TOTAL_OUT`, `GOOGLE_TARGET_SUMMARY`.`TOTAL_TOP_10`, `GOOGLE_TARGET_SUMMARY`.`TOTAL_TOP_100`, `GOOGLE_TARGET_SUMMARY`.`TOTAL_TOP_3`
from `GOOGLE_TARGET_SUMMARY` `GOOGLE_TARGET_SUMMARY`
where `GOOGLE_TARGET_SUMMARY`.`RUN_ID` = ?
    at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) ~[serposcope-2.4.0.jar:na]
    at com.querydsl.sql.Configuration.translate(Configuration.java:453) ~[serposcope-2.4.0.jar:na]
    at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:488) ~[serposcope-2.4.0.jar:na]
    at com.serphacker.serposcope.db.google.GoogleTargetSummaryDB.list(GoogleTargetSummaryDB.java:159) [serposcope-2.4.0.jar:na]
    at com.serphacker.serposcope.db.google.GoogleTargetSummaryDB.list(GoogleTargetSummaryDB.java:148) [serposcope-2.4.0.jar:na]
    at serposcope.controllers.google.GoogleGroupController.view(GoogleGroupController.java:93) [serposcope-2.4.0.jar:na]
    at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source) ~[na:na]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
    at ninja.params.ControllerMethodInvoker.invoke(ControllerMethodInvoker.java:57) [serposcope-2.4.0.jar:na]
    at ninja.FilterChainEnd.next(FilterChainEnd.java:49) [serposcope-2.4.0.jar:na]
    at serposcope.filters.GoogleGroupFilter.filter(GoogleGroupFilter.java:71) [serposcope-2.4.0.jar:na]
    at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope-2.4.0.jar:na]
    at serposcope.filters.CanReadFilter.filter(CanReadFilter.java:52) [serposcope-2.4.0.jar:na]
    at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope-2.4.0.jar:na]
    at serposcope.filters.AuthFilter.filter(AuthFilter.java:40) [serposcope-2.4.0.jar:na]
    at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope-2.4.0.jar:na]
    at serposcope.filters.BaseFilter.filter(BaseFilter.java:61) [serposcope-2.4.0.jar:na]
    at ninja.FilterChainImpl.next(FilterChainImpl.java:35) [serposcope-2.4.0.jar:na]
    at ninja.NinjaDefault.onRouteRequest(NinjaDefault.java:102) [serposcope-2.4.0.jar:na]
    at ninja.servlet.NinjaServletDispatcher.service(NinjaServletDispatcher.java:86) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:287) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:277) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:182) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:119) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.GuiceFilter$1.call(GuiceFilter.java:133) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.GuiceFilter$1.call(GuiceFilter.java:130) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.GuiceFilter$Context.call(GuiceFilter.java:203) [serposcope-2.4.0.jar:na]
    at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:130) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.Server.handle(Server.java:497) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) [serposcope-2.4.0.jar:na]
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) [serposcope-2.4.0.jar:na]
    at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'GOOGLE_TARGET_SUMMARY.PREVIOUS_SCORE' in 'field list'
    at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:278) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:333) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:99) ~[serposcope-2.4.0.jar:na]
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[serposcope-2.4.0.jar:na]
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[serposcope-2.4.0.jar:na]
    at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:432) ~[serposcope-2.4.0.jar:na]
    ... 42 common frames omitted
Caused by: org.mariadb.jdbc.internal.common.QueryException: Unknown column 'GOOGLE_TARGET_SUMMARY.PREVIOUS_SCORE' in 'field list'
    at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:969) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1021) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1003) ~[serposcope-2.4.0.jar:na]
    at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:271) ~[serposcope-2.4.0.jar:na]
    ... 47 common frames omitted

Apparement, il manque des tables !!!
En sachant que je suis sur une base MySQL.

Si quelqu'un à déjà eu ce genre de problème smile

Merci

Pierre.

Offline

Board footer