{"action":"created","issue":{"url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin/issues/28","repository_url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin","labels_url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin/issues/28/comments","events_url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin/issues/28/events","html_url":"https://github.com/gitbucket/gitbucket-gist-plugin/issues/28","id":164977970,"number":28,"title":"Column \"X3.MODE\" not found","user":{"login":"koooge","id":7419215,"avatar_url":"https://avatars.githubusercontent.com/u/7419215?v=3","gravatar_id":"","url":"https://api.github.com/users/koooge","html_url":"https://github.com/koooge","followers_url":"https://api.github.com/users/koooge/followers","following_url":"https://api.github.com/users/koooge/following{/other_user}","gists_url":"https://api.github.com/users/koooge/gists{/gist_id}","starred_url":"https://api.github.com/users/koooge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/koooge/subscriptions","organizations_url":"https://api.github.com/users/koooge/orgs","repos_url":"https://api.github.com/users/koooge/repos","events_url":"https://api.github.com/users/koooge/events{/privacy}","received_events_url":"https://api.github.com/users/koooge/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-07-12T01:58:34Z","updated_at":"2016-07-16T06:47:13Z","closed_at":null,"body":"I’ve got the error when trying to upgrade gitbucket-gist-plugin to 4.2.0 from 4.0.0.\r\nHave proxy settings mess up?\r\n\r\n```\r\norg.h2.jdbc.JdbcSQLException: Column \"X3.MODE\" not found; SQL statement:\r\nCREATE FORCE VIEW PUBLIC._24 AS\r\nSELECT\r\n    X3.UPDATED_DATE AS UPDATED_DATE,\r\n    X3.DESCRIPTION AS DESCRIPTION,\r\n    X3.ORIGIN_REPOSITORY_NAME AS ORIGIN_REPOSITORY_NAME,\r\n    X3.ORIGIN_USER_NAME AS ORIGIN_USER_NAME,\r\n    X3.MODE AS MODE,\r\n    X3.TITLE AS TITLE,\r\n    X3.REPOSITORY_NAME AS REPOSITORY_NAME,\r\n    X3.USER_NAME AS USER_NAME,\r\n    X3.REGISTERED_DATE AS REGISTERED_DATE\r\nFROM PUBLIC.GIST X3\r\nWHERE (X3.MODE = ?1)\r\n    OR (X3.USER_NAME = ?2)\r\nORDER BY =X3.REGISTERED_DATE DESC\r\nLIMIT 10 [42122-192]\r\n  at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)\r\n  at org.h2.message.DbException.get(DbException.java:179)\r\n  at org.h2.message.DbException.get(DbException.java:155)\r\n  at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)\r\n  at org.h2.expression.Alias.optimize(Alias.java:51)\r\n  at org.h2.command.dml.Select.prepare(Select.java:852)\r\n  at org.h2.command.Parser.prepare(Parser.java:239)\r\n  at org.h2.engine.Session.prepare(Session.java:525)\r\n  at org.h2.engine.Session.prepare(Session.java:512)\r\n  at org.h2.table.TableView.compileViewQuery(TableView.java:105)\r\n  at org.h2.table.TableView.initColumnsAndTables(TableView.java:156)\r\n  at org.h2.table.TableView.init(TableView.java:98)\r\n  at org.h2.table.TableView.<init>(TableView.java:65)\r\n  at org.h2.table.TableView.createTempView(TableView.java:534)\r\n  at org.h2.command.Parser.readTableFilter(Parser.java:1192)\r\n  at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1896)\r\n  at org.h2.command.Parser.parseSelectSimple(Parser.java:2044)\r\n  at org.h2.command.Parser.parseSelectSub(Parser.java:1890)\r\n  at org.h2.command.Parser.parseSelectUnion(Parser.java:1711)\r\n  at org.h2.command.Parser.parseSelect(Parser.java:1699)\r\n  at org.h2.command.Parser.parsePrepared(Parser.java:445)\r\n  at org.h2.command.Parser.parse(Parser.java:317)\r\n  at org.h2.command.Parser.parse(Parser.java:289)\r\n  at org.h2.command.Parser.prepareCommand(Parser.java:254)\r\n  at org.h2.engine.Session.prepareLocal(Session.java:560)\r\n  at org.h2.engine.Session.prepareCommand(Session.java:501)\r\n  at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)\r\n  at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)\r\n  at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:679)\r\n  at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:323)\r\n  at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)\r\n  at scala.slick.jdbc.JdbcBackend$SessionDef$class.prepareStatement(JdbcBackend.scala:152)\r\n  at scala.slick.jdbc.JdbcBackend$BaseSession.prepareStatement(JdbcBackend.scala:389)\r\n  at scala.slick.jdbc.StatementInvoker.results(StatementInvoker.scala:32)\r\n  at scala.slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)\r\n  at scala.slick.jdbc.Invoker$class.foreach(Invoker.scala:64)\r\n  at scala.slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)\r\n  at scala.slick.jdbc.Invoker$class.build(Invoker.scala:47)\r\n  at scala.slick.jdbc.StatementInvoker.build(StatementInvoker.scala:16)\r\n  at scala.slick.jdbc.Invoker$class.list(Invoker.scala:39)\r\n  at scala.slick.jdbc.StatementInvoker.list(StatementInvoker.scala:16)\r\n  at gitbucket.gist.service.GistService$class.getVisibleGists(GistService.scala:20)\r\n  at gitbucket.gist.controller.GistController.getVisibleGists(GistController.scala:29)\r\n  at gitbucket.gist.controller.GistControllerBase$$anonfun$2.apply(GistController.scala:52)\r\n  at gitbucket.gist.controller.GistControllerBase$$anonfun$2.apply(GistController.scala:47)\r\n  at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$liftAction(ScalatraBase.scala:285)\r\n  at org.scalatra.ScalatraBase$$anonfun$invoke$1.apply(ScalatraBase.scala:279)\r\n  at org.scalatra.ScalatraBase$$anonfun$invoke$1.apply(ScalatraBase.scala:279)\r\n  at org.scalatra.ApiFormats$class.withRouteMultiParams(ApiFormats.scala:189)\r\n  at gitbucket.core.controller.ControllerBase.withRouteMultiParams(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$class.invoke(ScalatraBase.scala:278)\r\n  at gitbucket.core.controller.ControllerBase.org$scalatra$json$JsonSupport$$super$invoke(ControllerBase.scala:27)\r\n  at org.scalatra.json.JsonSupport$$anonfun$invoke$1.apply(JsonSupport.scala:88)\r\n  at org.scalatra.json.JsonSupport$$anonfun$invoke$1.apply(JsonSupport.scala:82)\r\n  at org.scalatra.ApiFormats$class.withRouteMultiParams(ApiFormats.scala:189)\r\n  at gitbucket.core.controller.ControllerBase.withRouteMultiParams(ControllerBase.scala:27)\r\n  at org.scalatra.json.JsonSupport$class.invoke(JsonSupport.scala:82)\r\n  at gitbucket.core.controller.ControllerBase.invoke(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1$$anonfun$apply$8.apply(ScalatraBase.scala:253)\r\n  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1$$anonfun$apply$8.apply(ScalatraBase.scala:251)\r\n  at scala.Option.flatMap(Option.scala:171)\r\n  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1.apply(ScalatraBase.scala:251)\r\n  at org.scalatra.ScalatraBase$$anonfun$runRoutes$1.apply(ScalatraBase.scala:250)\r\n  at scala.collection.immutable.Stream.flatMap(Stream.scala:493)\r\n  at org.scalatra.ScalatraBase$class.runRoutes(ScalatraBase.scala:250)\r\n  at gitbucket.core.controller.ControllerBase.runRoutes(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$class.runActions$1(ScalatraBase.scala:175)\r\n  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply$mcV$sp(ScalatraBase.scala:187)\r\n  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)\r\n  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)\r\n  at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$cradleHalt(ScalatraBase.scala:205)\r\n  at org.scalatra.ScalatraBase$class.executeRoutes(ScalatraBase.scala:187)\r\n  at gitbucket.core.controller.ControllerBase.executeRoutes(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply$mcV$sp(ScalatraBase.scala:126)\r\n  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)\r\n  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.DynamicScope$class.withResponse(DynamicScope.scala:78)\r\n  at gitbucket.core.controller.ControllerBase.withResponse(ControllerBase.scala:27)\r\n  at org.scalatra.DynamicScope$$anonfun$withRequestResponse$1.apply(DynamicScope.scala:58)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)\r\n  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)\r\n  at org.scalatra.DynamicScope$class.withRequestResponse(DynamicScope.scala:57)\r\n  at gitbucket.core.controller.ControllerBase.withRequestResponse(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$class.handle(ScalatraBase.scala:125)\r\n  at gitbucket.core.controller.ControllerBase.org$scalatra$servlet$ServletBase$$super$handle(ControllerBase.scala:27)\r\n  at org.scalatra.servlet.ServletBase$class.handle(ServletBase.scala:53)\r\n  at gitbucket.core.controller.ControllerBase.org$scalatra$FlashMapSupport$$super$handle(ControllerBase.scala:27)\r\n  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply$mcV$sp(flashMap.scala:170)\r\n  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)\r\n  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)\r\n  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)\r\n  at org.scalatra.FlashMapSupport$class.handle(flashMap.scala:145)\r\n  at gitbucket.core.controller.ControllerBase.handle(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply$mcV$sp(ScalatraFilter.scala:37)\r\n  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)\r\n  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.ScalatraFilter$class.doFilter(ScalatraFilter.scala:36)\r\n  at gitbucket.core.controller.ControllerBase.doFilter(ControllerBase.scala:68)\r\n  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)\r\n  at org.scalatra.ScalatraFilter$$anonfun$1.apply$mcV$sp(ScalatraFilter.scala:74)\r\n  at org.scalatra.ScalatraFilter$$anonfun$1.apply(ScalatraFilter.scala:74)\r\n  at org.scalatra.ScalatraFilter$$anonfun$1.apply(ScalatraFilter.scala:74)\r\n  at org.scalatra.ScalatraBase$$anonfun$2$$anonfun$apply$4.apply(ScalatraBase.scala:178)\r\n  at scala.Option.getOrElse(Option.scala:121)\r\n  at org.scalatra.ScalatraBase$$anonfun$2.apply(ScalatraBase.scala:178)\r\n  at scala.Option.getOrElse(Option.scala:121)\r\n  at org.scalatra.ScalatraBase$class.runActions$1(ScalatraBase.scala:177)\r\n  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply$mcV$sp(ScalatraBase.scala:187)\r\n  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)\r\n  at org.scalatra.ScalatraBase$$anonfun$executeRoutes$1.apply(ScalatraBase.scala:187)\r\n  at org.scalatra.ScalatraBase$class.org$scalatra$ScalatraBase$$cradleHalt(ScalatraBase.scala:205)\r\n  at org.scalatra.ScalatraBase$class.executeRoutes(ScalatraBase.scala:187)\r\n  at gitbucket.core.controller.ControllerBase.executeRoutes(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply$mcV$sp(ScalatraBase.scala:126)\r\n  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)\r\n  at org.scalatra.ScalatraBase$$anonfun$handle$1.apply(ScalatraBase.scala:126)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.DynamicScope$class.withResponse(DynamicScope.scala:78)\r\n  at gitbucket.core.controller.ControllerBase.withResponse(ControllerBase.scala:27)\r\n  at org.scalatra.DynamicScope$$anonfun$withRequestResponse$1.apply(DynamicScope.scala:58)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)\r\n  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)\r\n  at org.scalatra.DynamicScope$class.withRequestResponse(DynamicScope.scala:57)\r\n  at gitbucket.core.controller.ControllerBase.withRequestResponse(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraBase$class.handle(ScalatraBase.scala:125)\r\n  at gitbucket.core.controller.ControllerBase.org$scalatra$servlet$ServletBase$$super$handle(ControllerBase.scala:27)\r\n  at org.scalatra.servlet.ServletBase$class.handle(ServletBase.scala:53)\r\n  at gitbucket.core.controller.ControllerBase.org$scalatra$FlashMapSupport$$super$handle(ControllerBase.scala:27)\r\n  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply$mcV$sp(flashMap.scala:170)\r\n  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)\r\n  at org.scalatra.FlashMapSupport$$anonfun$handle$1.apply(flashMap.scala:145)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.DynamicScope$class.withRequest(DynamicScope.scala:69)\r\n  at gitbucket.core.controller.ControllerBase.withRequest(ControllerBase.scala:27)\r\n  at org.scalatra.FlashMapSupport$class.handle(flashMap.scala:145)\r\n  at gitbucket.core.controller.ControllerBase.handle(ControllerBase.scala:27)\r\n  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply$mcV$sp(ScalatraFilter.scala:37)\r\n  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)\r\n  at org.scalatra.ScalatraFilter$$anonfun$doFilter$1.apply(ScalatraFilter.scala:37)\r\n  at scala.util.DynamicVariable.withValue(DynamicVariable.scala:58)\r\n  at org.scalatra.ScalatraFilter$class.doFilter(ScalatraFilter.scala:36)\r\n  at gitbucket.core.controller.ControllerBase.doFilter(ControllerBase.scala:68)\r\n  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)\r\n  at gitbucket.core.servlet.TransactionFilter.gitbucket$core$servlet$TransactionFilter$$$anonfun$1(TransactionFilter.scala:37)\r\n  at gitbucket.core.servlet.TransactionFilter.gitbucket$core$servlet$TransactionFilter$$$anonfun$1$adapted(TransactionFilter.scala:28)\r\n  at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1$$anonfun$apply$1.apply(DatabaseComponent.scala:54)\r\n  at scala.slick.jdbc.JdbcBackend$BaseSession.withTransaction(JdbcBackend.scala:426)\r\n  at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)\r\n  at scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)\r\n  at scala.slick.backend.DatabaseComponent$DatabaseDef$class.withSession(DatabaseComponent.scala:34)\r\n  at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withSession(JdbcBackend.scala:46)\r\n  at scala.slick.backend.DatabaseComponent$DatabaseDef$class.withTransaction(DatabaseComponent.scala:54)\r\n  at scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction(JdbcBackend.scala:46)\r\n  at gitbucket.core.servlet.TransactionFilter.doFilter(TransactionFilter.scala:28)\r\n  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)\r\n  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)\r\n  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)\r\n  at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)\r\n  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)\r\n  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1174)\r\n  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)\r\n  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)\r\n  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1106)\r\n  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\r\n  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)\r\n  at org.eclipse.jetty.server.Server.handle(Server.java:524)\r\n  at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)\r\n  at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)\r\n  at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)\r\n  at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)\r\n  at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)\r\n  at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)\r\n  at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)\r\n  at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)\r\n  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)\r\n  at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)\r\n  at java.lang.Thread.run(Thread.java:745)\r\n```"},"comment":{"url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin/issues/comments/233114912","html_url":"https://github.com/gitbucket/gitbucket-gist-plugin/issues/28#issuecomment-233114912","issue_url":"https://api.github.com/repos/gitbucket/gitbucket-gist-plugin/issues/28","id":233114912,"user":{"login":"moonkev","id":6970074,"avatar_url":"https://avatars.githubusercontent.com/u/6970074?v=3","gravatar_id":"","url":"https://api.github.com/users/moonkev","html_url":"https://github.com/moonkev","followers_url":"https://api.github.com/users/moonkev/followers","following_url":"https://api.github.com/users/moonkev/following{/other_user}","gists_url":"https://api.github.com/users/moonkev/gists{/gist_id}","starred_url":"https://api.github.com/users/moonkev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moonkev/subscriptions","organizations_url":"https://api.github.com/users/moonkev/orgs","repos_url":"https://api.github.com/users/moonkev/repos","events_url":"https://api.github.com/users/moonkev/events{/privacy}","received_events_url":"https://api.github.com/users/moonkev/received_events","type":"User","site_admin":false},"created_at":"2016-07-16T06:47:13Z","updated_at":"2016-07-16T06:47:13Z","body":"Thanks a lot shiena.  I can verify this fix has worked for me."}}
{"actor":{"display_login":"moonkev"}}