Column "X3.MODE" not found

[koooge]

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]

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]

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]

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

[koooge]

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

[shiena]

@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.
gitbucket/gitbucket#1236

[takezoe]

@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]

Added to FAQ and README of this plugin.

[tundratim]

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]

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

[tundratim]

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

Many thanks for the prompt responses.

[koooge]

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]

@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]

Attempting to execute suggested SQL returns:

Table "VERSIONS" not found;

[shiena]

Sorry, I was not enough to confirm with the #28 (comment).

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