search

gitbucket / gitbucket-gist-plugin

A GitBucket plug-in which provides code snippet repository like Gist
http://gitbucket.herokuapp.com/gist
Apache License 2.0
69 stars 25 forks source link

Column "X3.MODE" not found #28

Closed koooge closed 8 years ago

koooge commented 8 years ago

I’ve got the error when trying to upgrade gitbucket-gist-plugin to 4.2.0 from 4.0.0. Have proxy settings mess up?

org.h2.jdbc.JdbcSQLException: Column "X3.MODE" not found; SQL statement:
CREATE FORCE VIEW PUBLIC._24 AS
SELECT
    X3.UPDATED_DATE AS UPDATED_DATE,
    X3.DESCRIPTION AS DESCRIPTION,
    X3.ORIGIN_REPOSITORY_NAME AS ORIGIN_REPOSITORY_NAME,
    X3.ORIGIN_USER_NAME AS ORIGIN_USER_NAME,
    X3.MODE AS MODE,
    X3.TITLE AS TITLE,
    X3.REPOSITORY_NAME AS REPOSITORY_NAME,
    X3.USER_NAME AS USER_NAME,
    X3.REGISTERED_DATE AS REGISTERED_DATE
FROM PUBLIC.GIST X3
WHERE (X3.MODE = ?1)
    OR (X3.USER_NAME = ?2)
ORDER BY =X3.REGISTERED_DATE DESC
LIMIT 10 [42122-192]
  at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
  at org.h2.message.DbException.get(DbException.java:179)
  at org.h2.message.DbException.get(DbException.java:155)
  at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
  at org.h2.expression.Alias.optimize(Alias.java:51)
  at org.h2.command.dml.Select.prepare(Select.java:852)
  at org.h2.command.Parser.prepare(Parser.java:239)
  at org.h2.engine.Session.prepare(Session.java:525)
  at org.h2.engine.Session.prepare(Session.java:512)
  at org.h2.table.TableView.compileViewQuery(TableView.java:105)
  at org.h2.table.TableView.initColumnsAndTables(TableView.java:156)
  at org.h2.table.TableView.init(TableView.java:98)
  at org.h2.table.TableView.<init>(TableView.java:65)
  at org.h2.table.TableView.createTempView(TableView.java:534)
  at org.h2.command.Parser.readTableFilter(Parser.java:1192)
  at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1896)
  at org.h2.command.Parser.parseSelectSimple(Parser.java:2044)
  at org.h2.command.Parser.parseSelectSub(Parser.java:1890)
  at org.h2.command.Parser.parseSelectUnion(Parser.java:1711)
  at org.h2.command.Parser.parseSelect(Parser.java:1699)
  at org.h2.command.Parser.parsePrepared(Parser.java:445)
  at org.h2.command.Parser.parse(Parser.java:317)
  at org.h2.command.Parser.parse(Parser.java:289)
  at org.h2.command.Parser.prepareCommand(Parser.java:254)
  at org.h2.engine.Session.prepareLocal(Session.java:560)
  at org.h2.engine.Session.prepareCommand(Session.java:501)
  at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)
  at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
  at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:679)
  at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:323)
  at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
  at scala.slick.jdbc.JdbcBackend$SessionDef$class.prepareStatement(JdbcBackend.scala:152)
  at scala.slick.jdbc.JdbcBackend$BaseSession.prepareStatement(JdbcBackend.scala:389)
  at scala.slick.jdbc.StatementInvoker.results(StatementInvoker.scala:32)
  at scala.slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
  at scala.slick.jdbc.Invoker$class.foreach(Invoker.scala:64)
  at scala.slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
  at scala.slick.jdbc.Invoker$class.build(Invoker.scala:47)
  at scala.slick.jdbc.StatementInvoker.build(StatementInvoker.scala:16)
  at scala.slick.jdbc.Invoker$class.list(Invoker.scala:39)
  at scala.slick.jdbc.StatementInvoker.list(StatementInvoker.scala:16)
  at gitbucket.gist.service.GistService$class.getVisibleGists(GistService.scala:20)
  at gitbucket.gist.controller.GistController.getVisibleGists(GistController.scala:29)
  at gitbucket.gist.controller.GistControllerBase$$anonfun$2.apply(GistController.scala:52)
  at gitbucket.gist.controller.GistControllerBase$$anonfun$2.apply(GistController.scala:47)
  at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$liftAction(ScalatraBase.scala:285)
  at org.scalatra.ScalatraBase$$anonfun$invoke$1.apply(ScalatraBase.scala:279)
  at org.scalatra.ScalatraBase$$anonfun$invoke$1.apply(ScalatraBase.scala:279)
  at org.scalatra.ApiFormats$class.withRouteMultiParams(ApiFormats.scala:189)
  at gitbucket.core.controller.ControllerBase.withRouteMultiParams(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$class.invoke(ScalatraBase.scala:278)
  at gitbucket.core.controller.ControllerBase.org$scalatra$json$JsonSupport$$super$invoke(ControllerBase.scala:27)
  at org.scalatra.json.JsonSupport$$anonfun$invoke$1.apply(JsonSupport.scala:88)
  at org.scalatra.json.JsonSupport$$anonfun$invoke$1.apply(JsonSupport.scala:82)
  at org.scalatra.ApiFormats$class.withRouteMultiParams(ApiFormats.scala:189)
  at gitbucket.core.controller.ControllerBase.withRouteMultiParams(ControllerBase.scala:27)
  at org.scalatra.json.JsonSupport$class.invoke(JsonSupport.scala:82)
  at gitbucket.core.controller.ControllerBase.invoke(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1$$anonfun$apply$8.apply(ScalatraBase.scala:253)
  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1$$anonfun$apply$8.apply(ScalatraBase.scala:251)
  at scala.Option.flatMap(Option.scala:171)
  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1.apply(ScalatraBase.scala:251)
  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1.apply(ScalatraBase.scala:250)
  at scala.collection.immutable.Stream.flatMap(Stream.scala:493)
  at org.scalatra.ScalatraBase$class.runRoutes(ScalatraBase.scala:250)
  at gitbucket.core.controller.ControllerBase.runRoutes(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$class.runActions$1(ScalatraBase.scala:175)
  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply$mcV$sp(ScalatraBase.scala:187)
  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
  at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$cradleHalt(ScalatraBase.scala:205)
  at org.scalatra.ScalatraBase$class.executeRoutes(ScalatraBase.scala:187)
  at gitbucket.core.controller.ControllerBase.executeRoutes(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply$mcV$sp(ScalatraBase.scala:126)
  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.DynamicScope$class.withResponse(DynamicScope.scala:78)
  at gitbucket.core.controller.ControllerBase.withResponse(ControllerBase.scala:27)
  at org.scalatra.DynamicScope$$anonfun$withRequestResponse$1.apply(DynamicScope.scala:58)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
  at org.scalatra.DynamicScope$class.withRequestResponse(DynamicScope.scala:57)
  at gitbucket.core.controller.ControllerBase.withRequestResponse(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$class.handle(ScalatraBase.scala:125)
  at gitbucket.core.controller.ControllerBase.org$scalatra$servlet$ServletBase$$super$handle(ControllerBase.scala:27)
  at org.scalatra.servlet.ServletBase$class.handle(ServletBase.scala:53)
  at gitbucket.core.controller.ControllerBase.org$scalatra$FlashMapSupport$$super$handle(ControllerBase.scala:27)
  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply$mcV$sp(flashMap.scala:170)
  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
  at org.scalatra.FlashMapSupport$class.handle(flashMap.scala:145)
  at gitbucket.core.controller.ControllerBase.handle(ControllerBase.scala:27)
  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply$mcV$sp(ScalatraFilter.scala:37)
  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.ScalatraFilter$class.doFilter(ScalatraFilter.scala:36)
  at gitbucket.core.controller.ControllerBase.doFilter(ControllerBase.scala:68)
  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
  at org.scalatra.ScalatraFilter$$anonfun$1.apply$mcV$sp(ScalatraFilter.scala:74)
  at org.scalatra.ScalatraFilter$$anonfun$1.apply(ScalatraFilter.scala:74)
  at org.scalatra.ScalatraFilter$$anonfun$1.apply(ScalatraFilter.scala:74)
  at org.scalatra.ScalatraBase$$anonfun$2$$anonfun$apply$4.apply(ScalatraBase.scala:178)
  at scala.Option.getOrElse(Option.scala:121)
  at org.scalatra.ScalatraBase$$anonfun$2.apply(ScalatraBase.scala:178)
  at scala.Option.getOrElse(Option.scala:121)
  at org.scalatra.ScalatraBase$class.runActions$1(ScalatraBase.scala:177)
  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply$mcV$sp(ScalatraBase.scala:187)
  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
  at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$cradleHalt(ScalatraBase.scala:205)
  at org.scalatra.ScalatraBase$class.executeRoutes(ScalatraBase.scala:187)
  at gitbucket.core.controller.ControllerBase.executeRoutes(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply$mcV$sp(ScalatraBase.scala:126)
  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.DynamicScope$class.withResponse(DynamicScope.scala:78)
  at gitbucket.core.controller.ControllerBase.withResponse(ControllerBase.scala:27)
  at org.scalatra.DynamicScope$$anonfun$withRequestResponse$1.apply(DynamicScope.scala:58)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
  at org.scalatra.DynamicScope$class.withRequestResponse(DynamicScope.scala:57)
  at gitbucket.core.controller.ControllerBase.withRequestResponse(ControllerBase.scala:27)
  at org.scalatra.ScalatraBase$class.handle(ScalatraBase.scala:125)
  at gitbucket.core.controller.ControllerBase.org$scalatra$servlet$ServletBase$$super$handle(ControllerBase.scala:27)
  at org.scalatra.servlet.ServletBase$class.handle(ServletBase.scala:53)
  at gitbucket.core.controller.ControllerBase.org$scalatra$FlashMapSupport$$super$handle(ControllerBase.scala:27)
  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply$mcV$sp(flashMap.scala:170)
  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
  at org.scalatra.FlashMapSupport$class.handle(flashMap.scala:145)
  at gitbucket.core.controller.ControllerBase.handle(ControllerBase.scala:27)
  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply$mcV$sp(ScalatraFilter.scala:37)
  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
  at org.scalatra.ScalatraFilter$class.doFilter(ScalatraFilter.scala:36)
  at gitbucket.core.controller.ControllerBase.doFilter(ControllerBase.scala:68)
  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
  at gitbucket.core.servlet.TransactionFilter.gitbucket$core$servlet$TransactionFilter$$$anonfun$1(TransactionFilter.scala:37)
  at gitbucket.core.servlet.TransactionFilter.gitbucket$core$servlet$TransactionFilter$$$anonfun$1$adapted(TransactionFilter.scala:28)
  at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1$$anonfun$apply$1.apply(DatabaseComponent.scala:54)
  at scala.slick.jdbc.JdbcBackend$BaseSession.withTransaction(JdbcBackend.scala:426)
  at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
  at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
  at scala.slick.backend.DatabaseComponent$DatabaseDef$class.withSession(DatabaseComponent.scala:34)
  at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withSession(JdbcBackend.scala:46)
  at scala.slick.backend.DatabaseComponent$DatabaseDef$class.withTransaction(DatabaseComponent.scala:54)
  at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction(JdbcBackend.scala:46)
  at gitbucket.core.servlet.TransactionFilter.doFilter(TransactionFilter.scala:28)
  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1174)
  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1106)
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
  at org.eclipse.jetty.server.Server.handle(Server.java:524)
  at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)
  at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)
  at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
  at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
  at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
  at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
  at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
  at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
  at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
  at java.lang.Thread.run(Thread.java:745)
moonkev commented 8 years ago

I am also seeing this same error when upgrading from 4.0 to 4.2.0. I also upgraded Gitbucket from version 4.0 to 4.2.1 - although I haven't seen any issues there.

shiena commented 8 years ago

I found the steps to reproduce this bug.

  1. gitbucket3.13 + gist-2.11-3.13
    1. install gitbucket3.13 + install gist-2.11-3.13
    2. start gitbucket
    3. SELECT VERSION FROM PLUGIN WHERE MODULE_ID='gist' -> 3.12
  2. only gitbucket3.14
    1. stop gitbucket
    2. update gitbucket3.14 + delete gist-2.11-3.13 (gitbucket3.14 does not support any version of gist plugin)
    3. start gitbucket
    4. SELECT VERSION FROM PLUGIN WHERE MODULE_ID='gist' -> 3.12
  3. gitbucket4.0 + gist-2.11-4.0.0
    1. stop gitbucket
    2. update gitbucket4.0 + install gist-2.11-4.0.0
    3. start gitbucket
    4. SELECT VERSION FROM VERSIONS WHERE MODULE_ID='gist' -> 3.12
  4. gitbucket4.1 + gist-2.11-4.0.0
    1. stop gitbucket
    2. update gitbucket4.1 + gist-2.11-4.0.0
    3. start gitbucket
    4. SELECT VERSION FROM VERSIONS WHERE MODULE_ID='gist' -> 3.12
  5. gitbucket4.2.1 + gist-2.11-4.2.0
    1. stop gitbucket
    2. update gitbucket4.2.1 + gist-2.11-4.2.0
    3. start gitbucket
    4. SELECT VERSION FROM VERSIONS WHERE MODULE_ID='gist' -> 3.12

And solution

  1. UPDATE VERSIONS SET VERSION='2.0.0' WHERE MODULE_ID='gist';
  2. restart gitbucket
  3. can open snippets page
  4. SELECT VERSION FROM VERSIONS WHERE MODULE_ID='gist' -> 4.2.0
moonkev commented 8 years ago

Thanks a lot shiena. I can verify this fix has worked for me.

koooge commented 8 years ago

Thanks all! :D But does @shiena 's solution seem to hack? [Plugins] shows gist version 2.0.0.

shiena commented 8 years ago

@koooge [Plugins] page does not refer to database. it is referring to versions of each Plugin.scala. For example, in the case of gist https://github.com/gitbucket/gitbucket-gist-plugin/blob/4.2.0/src/main/scala/Plugin.scala#L21-L28

Currently, it will show the first version. But next release gitbucket should show the last version by following PR. https://github.com/gitbucket/gitbucket/pull/1236

takezoe commented 8 years ago

@shiena Thanks for your great support! I will add note about upgrade GitBucket 3.x to 4.x with plugins to GitBucket docs.

Also I would like to change [Plugins] page shows plugin versions in the database in the next (or future) release of GitBucket.

takezoe commented 8 years ago

Added to FAQ and README of this plugin.

tundratim commented 8 years ago

OK so I am having a profound stupid attack. When I see this:

UPDATE VERSIONS SET VERSION='2.0.0' WHERE MODULE_ID='gist';

Or this:

SELECT VERSION FROM VERSIONS WHERE MODULE_ID='gist' -> 4.2.0

What exactly am I being told to do? Update a line of source? Make a config change? Something else?

shiena commented 8 years ago

@tundratim Please see Connect to H2 database You can execute SQL in this H2 Console.

tundratim commented 8 years ago

D'oh, of course. I'll give this a try and see if that solves my issue.

Many thanks for the prompt responses.

koooge commented 8 years ago

mmm... I'm sorry When I tried to "Create" new snippet, it failed. 

java.util.NoSuchElementException: key not found: mode
    at scala.collection.MapLike$class.default(MapLike.scala:228)
    at org.scalatra.ScalatraParams.default(ScalatraParams.scala:5)
    at scala.collection.MapLike$class.apply(MapLike.scala:141)
    at org.scalatra.ScalatraParams.apply(ScalatraParams.scala:5)
    at org.scalatra.ScalatraBase$class.params(ScalatraBase.scala:818)
    at gitbucket.core.controller.ControllerBase.params(ControllerBase.scala:27)
    at gitbucket.gist.controller.GistControllerBase$$anonfun$8$$anonfun$apply$1.apply$mcV$sp(GistController.scala:98)
    at gitbucket.gist.controller.GistControllerBase$$anonfun$8$$anonfun$apply$1.apply(GistController.scala:90)
    at gitbucket.gist.controller.GistControllerBase$$anonfun$8$$anonfun$apply$1.apply(GistController.scala:90)
    at gitbucket.core.util.UsersAuthenticator$class.authenticate(Authenticator.scala:64)
    at gitbucket.core.util.UsersAuthenticator$class.usersOnly(Authenticator.scala:58)
    at gitbucket.gist.controller.GistController.usersOnly(GistController.scala:29)
    at gitbucket.gist.controller.GistControllerBase$$anonfun$8.apply(GistController.scala:89)
    at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$liftAction(ScalatraBase.scala:285)
    at org.scalatra.ScalatraBase$$anonfun$invoke$1.apply(ScalatraBase.scala:279)
    at org.scalatra.ScalatraBase$$anonfun$invoke$1.apply(ScalatraBase.scala:279)
    at org.scalatra.ApiFormats$class.withRouteMultiParams(ApiFormats.scala:189)
    at gitbucket.core.controller.ControllerBase.withRouteMultiParams(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$class.invoke(ScalatraBase.scala:278)
    at gitbucket.core.controller.ControllerBase.org$scalatra$json$JsonSupport$$super$invoke(ControllerBase.scala:27)
    at org.scalatra.json.JsonSupport$$anonfun$invoke$1.apply(JsonSupport.scala:88)
    at org.scalatra.json.JsonSupport$$anonfun$invoke$1.apply(JsonSupport.scala:82)
    at org.scalatra.ApiFormats$class.withRouteMultiParams(ApiFormats.scala:189)
    at gitbucket.core.controller.ControllerBase.withRouteMultiParams(ControllerBase.scala:27)
    at org.scalatra.json.JsonSupport$class.invoke(JsonSupport.scala:82)
    at gitbucket.core.controller.ControllerBase.invoke(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$$anonfun$runRoutes$1$$anonfun$apply$8.apply(ScalatraBase.scala:253)
    at org.scalatra.ScalatraBase$$anonfun$runRoutes$1$$anonfun$apply$8.apply(ScalatraBase.scala:251)
    at scala.Option.flatMap(Option.scala:171)
    at org.scalatra.ScalatraBase$$anonfun$runRoutes$1.apply(ScalatraBase.scala:251)
    at org.scalatra.ScalatraBase$$anonfun$runRoutes$1.apply(ScalatraBase.scala:250)
    at scala.collection.immutable.Stream.flatMap(Stream.scala:493)
    at org.scalatra.ScalatraBase$class.runRoutes(ScalatraBase.scala:250)
    at gitbucket.core.controller.ControllerBase.runRoutes(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$class.runActions$1(ScalatraBase.scala:175)
    at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply$mcV$sp(ScalatraBase.scala:187)
    at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
    at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
    at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$cradleHalt(ScalatraBase.scala:205)
    at org.scalatra.ScalatraBase$class.executeRoutes(ScalatraBase.scala:187)
    at gitbucket.core.controller.ControllerBase.executeRoutes(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$$anonfun$handle$1.apply$mcV$sp(ScalatraBase.scala:126)
    at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
    at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.DynamicScope$class.withResponse(DynamicScope.scala:78)
    at gitbucket.core.controller.ControllerBase.withResponse(ControllerBase.scala:27)
    at org.scalatra.DynamicScope$$anonfun$withRequestResponse$1.apply(DynamicScope.scala:58)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
    at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
    at org.scalatra.DynamicScope$class.withRequestResponse(DynamicScope.scala:57)
    at gitbucket.core.controller.ControllerBase.withRequestResponse(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$class.handle(ScalatraBase.scala:125)
    at gitbucket.core.controller.ControllerBase.org$scalatra$servlet$ServletBase$$super$handle(ControllerBase.scala:27)
    at org.scalatra.servlet.ServletBase$class.handle(ServletBase.scala:53)
    at gitbucket.core.controller.ControllerBase.org$scalatra$FlashMapSupport$$super$handle(ControllerBase.scala:27)
    at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply$mcV$sp(flashMap.scala:170)
    at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
    at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
    at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
    at org.scalatra.FlashMapSupport$class.handle(flashMap.scala:145)
    at gitbucket.core.controller.ControllerBase.handle(ControllerBase.scala:27)
    at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply$mcV$sp(ScalatraFilter.scala:37)
    at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
    at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.ScalatraFilter$class.doFilter(ScalatraFilter.scala:36)
    at gitbucket.core.controller.ControllerBase.doFilter(ControllerBase.scala:68)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
    at org.scalatra.ScalatraFilter$$anonfun$1.apply$mcV$sp(ScalatraFilter.scala:74)
    at org.scalatra.ScalatraFilter$$anonfun$1.apply(ScalatraFilter.scala:74)
    at org.scalatra.ScalatraFilter$$anonfun$1.apply(ScalatraFilter.scala:74)
    at org.scalatra.ScalatraBase$$anonfun$2$$anonfun$apply$4.apply(ScalatraBase.scala:178)
    at scala.Option.getOrElse(Option.scala:121)
    at org.scalatra.ScalatraBase$$anonfun$2.apply(ScalatraBase.scala:178)
    at scala.Option.getOrElse(Option.scala:121)
    at org.scalatra.ScalatraBase$class.runActions$1(ScalatraBase.scala:177)
    at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply$mcV$sp(ScalatraBase.scala:187)
    at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
    at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)
    at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$cradleHalt(ScalatraBase.scala:205)
    at org.scalatra.ScalatraBase$class.executeRoutes(ScalatraBase.scala:187)
    at gitbucket.core.controller.ControllerBase.executeRoutes(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$$anonfun$handle$1.apply$mcV$sp(ScalatraBase.scala:126)
    at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
    at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.DynamicScope$class.withResponse(DynamicScope.scala:78)
    at gitbucket.core.controller.ControllerBase.withResponse(ControllerBase.scala:27)
    at org.scalatra.DynamicScope$$anonfun$withRequestResponse$1.apply(DynamicScope.scala:58)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
    at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
    at org.scalatra.DynamicScope$class.withRequestResponse(DynamicScope.scala:57)
    at gitbucket.core.controller.ControllerBase.withRequestResponse(ControllerBase.scala:27)
    at org.scalatra.ScalatraBase$class.handle(ScalatraBase.scala:125)
    at gitbucket.core.controller.ControllerBase.org$scalatra$servlet$ServletBase$$super$handle(ControllerBase.scala:27)
    at org.scalatra.servlet.ServletBase$class.handle(ServletBase.scala:53)
    at gitbucket.core.controller.ControllerBase.org$scalatra$FlashMapSupport$$super$handle(ControllerBase.scala:27)
    at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply$mcV$sp(flashMap.scala:170)
    at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
    at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)
    at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)
    at org.scalatra.FlashMapSupport$class.handle(flashMap.scala:145)
    at gitbucket.core.controller.ControllerBase.handle(ControllerBase.scala:27)
    at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply$mcV$sp(ScalatraFilter.scala:37)
    at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
    at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)
    at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)
    at org.scalatra.ScalatraFilter$class.doFilter(ScalatraFilter.scala:36)
    at gitbucket.core.controller.ControllerBase.doFilter(ControllerBase.scala:68)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
    at gitbucket.core.servlet.TransactionFilter.gitbucket$core$servlet$TransactionFilter$$$anonfun$1(TransactionFilter.scala:37)
    at gitbucket.core.servlet.TransactionFilter.gitbucket$core$servlet$TransactionFilter$$$anonfun$1$adapted(TransactionFilter.scala:28)
    at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1$$anonfun$apply$1.apply(DatabaseComponent.scala:54)
    at scala.slick.jdbc.JdbcBackend$BaseSession.withTransaction(JdbcBackend.scala:426)
    at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
    at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
    at scala.slick.backend.DatabaseComponent$DatabaseDef$class.withSession(DatabaseComponent.scala:34)
    at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withSession(JdbcBackend.scala:46)
    at scala.slick.backend.DatabaseComponent$DatabaseDef$class.withTransaction(DatabaseComponent.scala:54)
    at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction(JdbcBackend.scala:46)
    at gitbucket.core.servlet.TransactionFilter.doFilter(TransactionFilter.scala:28)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1174)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1106)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
    at org.eclipse.jetty.server.Server.handle(Server.java:524)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
    at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
    at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
    at java.lang.Thread.run(Thread.java:745)
shiena commented 8 years ago

@koooge @takezoe [Public | Secret | Private] buttons are the radio input. Because these elements do not have a checked attribute, mode parameter is not sent. Therefore, it seems the server is returning an error.

tundratim commented 8 years ago

Attempting to execute suggested SQL returns:

Table "VERSIONS" not found;

shiena commented 8 years ago

Sorry, I was not enough to confirm with the https://github.com/gitbucket/gitbucket-gist-plugin/issues/28#issuecomment-233953146.

  1. Click "New Snippet" button
  2. Fill the description, file name and file contents
  3. Click "Create" button
  4. Failed

But when you add a step to click the mode button ...

  1. Click "New Snippet" button
  2. Fill the description, file name and file contents
  3. Click "Public" or "Secret" or "Private" button
  4. Click "Create" button
  5. Succeeded
takezoe commented 8 years ago

@tundratim Could you upload screenshot of your H2 console? I would like to see the tables tree of your database.

takezoe commented 8 years ago

@shiena It's a bug. Could you raise an another issue?

shiena commented 8 years ago

@takezoe OK. I was issued #29

takezoe commented 8 years ago

@shiena Thanks!!

koooge commented 8 years ago

@tundratim Could you close this?

tundratim commented 8 years ago

@kooge .... er, I did not open this issue, hence cannot close it.

koooge commented 8 years ago

okay, I close this issue.