{"action":"opened","issue":{"url":"https://api.github.com/repos/ColFusion/ColfusionServer/issues/49","labels_url":"https://api.github.com/repos/ColFusion/ColfusionServer/issues/49/labels{/name}","comments_url":"https://api.github.com/repos/ColFusion/ColfusionServer/issues/49/comments","events_url":"https://api.github.com/repos/ColFusion/ColfusionServer/issues/49/events","html_url":"https://github.com/ColFusion/ColfusionServer/issues/49","id":107426550,"number":49,"title":"MetadataDbHandler - FAILED to creating edit log for","user":{"login":"EvgenyKarataev","id":442457,"avatar_url":"https://avatars.githubusercontent.com/u/442457?v=3","gravatar_id":"","url":"https://api.github.com/users/EvgenyKarataev","html_url":"https://github.com/EvgenyKarataev","followers_url":"https://api.github.com/users/EvgenyKarataev/followers","following_url":"https://api.github.com/users/EvgenyKarataev/following{/other_user}","gists_url":"https://api.github.com/users/EvgenyKarataev/gists{/gist_id}","starred_url":"https://api.github.com/users/EvgenyKarataev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EvgenyKarataev/subscriptions","organizations_url":"https://api.github.com/users/EvgenyKarataev/orgs","repos_url":"https://api.github.com/users/EvgenyKarataev/repos","events_url":"https://api.github.com/users/EvgenyKarataev/events{/privacy}","received_events_url":"https://api.github.com/users/EvgenyKarataev/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ColFusion/ColfusionServer/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/ColFusion/ColfusionServer/labels/ColfusionServerBLL","name":"ColfusionServerBLL","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/ColFusion/ColfusionServer/milestones/1","html_url":"https://github.com/ColFusion/ColfusionServer/milestones/StableDeployment","labels_url":"https://api.github.com/repos/ColFusion/ColfusionServer/milestones/1/labels","id":1294387,"number":1,"title":"StableDeployment","description":"","creator":{"login":"EvgenyKarataev","id":442457,"avatar_url":"https://avatars.githubusercontent.com/u/442457?v=3","gravatar_id":"","url":"https://api.github.com/users/EvgenyKarataev","html_url":"https://github.com/EvgenyKarataev","followers_url":"https://api.github.com/users/EvgenyKarataev/followers","following_url":"https://api.github.com/users/EvgenyKarataev/following{/other_user}","gists_url":"https://api.github.com/users/EvgenyKarataev/gists{/gist_id}","starred_url":"https://api.github.com/users/EvgenyKarataev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EvgenyKarataev/subscriptions","organizations_url":"https://api.github.com/users/EvgenyKarataev/orgs","repos_url":"https://api.github.com/users/EvgenyKarataev/repos","events_url":"https://api.github.com/users/EvgenyKarataev/events{/privacy}","received_events_url":"https://api.github.com/users/EvgenyKarataev/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":8,"state":"open","created_at":"2015-09-07T22:31:52Z","updated_at":"2015-09-21T00:18:28Z","due_on":"2015-09-20T04:00:00Z","closed_at":null},"comments":0,"created_at":"2015-09-21T00:18:28Z","updated_at":"2015-09-21T00:18:28Z","closed_at":null,"body":"Tried to click on edit link to open openrefine, but got the following stack trace with exception\r\n\r\n```\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'endChangeTime' cannot be null\r\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_45]\r\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_45]\r\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_45]\r\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0_45]\r\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764) ~[mysql-connector-java-5.1.29.jar:?]\r\n\tat edu.pitt.sis.exp.colfusion.dal.databaseHandlers.MetadataDbHandler.createEditLog(MetadataDbHandler.java:364) [classes/:?]\r\n\tat com.google.refine.commands.colfusion.CreateProjectFromColfusionStoryCommand.doGet(CreateProjectFromColfusionStoryCommand.java:73) [classes/:?]\r\n\tat com.google.refine.RefineServlet.service(RefineServlet.java:173) [classes/:?]\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [servlet-api-2.5.jar:2.5]\r\n\tat org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) [jetty-util-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132) [jetty-util-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.Server.handle(Server.java:326) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [jetty-6.1.22.jar:6.1.22]\r\n\tat org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) [jetty-6.1.22.jar:6.1.22]\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_45]\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_45]\r\n\tat java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]\r\n20:12:34.709 [pool-1-thread-14] INFO  edu.pitt.sis.exp.colfusion.dal.databaseHandlers.MetadataDbHandler - FAILED to creating edit log for sid 5, table Sheet1 and user 2\r\n20:12:34.735 [                  command] Exception caught (514ms)\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'endChangeTime' cannot be null\r\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\r\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:422)\r\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\r\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\r\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\r\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\r\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\r\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\r\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\r\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)\r\n\tat com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842)\r\n\tat com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764)\r\n\tat edu.pitt.sis.exp.colfusion.dal.databaseHandlers.MetadataDbHandler.createEditLog(MetadataDbHandler.java:364)\r\n\tat com.google.refine.commands.colfusion.CreateProjectFromColfusionStoryCommand.doGet(CreateProjectFromColfusionStoryCommand.java:73)\r\n\tat com.google.refine.RefineServlet.service(RefineServlet.java:173)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:820)\r\n\tat org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)\r\n\tat org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)\r\n\tat org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)\r\n\tat org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132)\r\n\tat org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)\r\n\tat org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)\r\n\tat org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)\r\n\tat org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)\r\n\tat org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)\r\n\tat org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)\r\n\tat org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)\r\n\tat org.mortbay.jetty.Server.handle(Server.java:326)\r\n\tat org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)\r\n\tat org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923)\r\n\tat org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)\r\n\tat org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)\r\n\tat org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)\r\n\tat org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\n```"}}