[Building Sakai] Table 'sakai26x.blogger_post' doesn't exist?
Steve Swinsburg
steve.swinsburg at gmail.com
Fri Oct 23 17:12:44 PDT 2009
Hi Will,
The tables are indeed created via autoDDL.
api-impl/src/java/uk/ac/lancs/e_science/sakaiproject/impl/blogger/
persistence/SakaiPersistenceManager.java
initRepository() is what you are after.
cheers,
Steve
On 24/10/2009, at 8:13 AM, will at serensoft.com wrote:
> Our blogger instance seems to be missing a table "blogger_post" --
> should we restart Sakai with auto.ddl=true to fix this? Or is it a
> deeper issue?
>
> We're not having much luck finding any "create table" in the source
> code for blogger_post, either...
>
> Here's the error:
>
>
> 2009-10-23 16:07:14,091 WARN http-80-Processor40
> org.sakaiproject.citation.impl.BaseConfigurationService - exists()
> failed find resource: org.sakaiproject.exception.IdUnusedException
> id=/group/citationsAdmin/config/config.xml
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.persistence.PersistenceException
> :
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
> 'sakai26x.blogger_post' doesn't exist
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.persistence.SakaiPersistenceManager.executeQuerySQL
> (SakaiPersistenceManager.java:522)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.persistence.SakaiPersistenceManager.existPost
> (SakaiPersistenceManager.java:385)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.persistence.SakaiPersistenceManager.storePost
> (SakaiPersistenceManager.java:71)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.manager.PostManager.storePost
> (PostManager.java:45)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.BloggerImpl.storePost
> (BloggerImpl.java:60)
> at
> uk.ac.lancs.e_science.sakai.tools.blogger.PostEditionAbstractController.doSave
> (PostEditionAbstractController.java:105)
> at
> uk.ac.lancs.e_science.sakai.tools.blogger.PostCreateController.doSave
> (PostCreateController.java:43)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:
> 126)
> at com.sun.faces.application.ActionListenerImpl.processAction
> (ActionListenerImpl.java:72)
> at javax.faces.component.UICommand.broadcast(UICommand.java:312)
> at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:
> 267)
> at javax.faces.component.UIViewRoot.processApplication
> (UIViewRoot.java:381)
> at com.sun.faces.lifecycle.InvokeApplicationPhase.execute
> (InvokeApplicationPhase.java:75)
> at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:
> 200)
> at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:
> 90)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:
> 565)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter
> (ExtensionsFilter.java:147)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at uk.ac.lancs.e_science.fileUpload.UploadFilter.doFilter
> (UploadFilter.java:116)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.catalina.core.ApplicationDispatcher.invoke
> (ApplicationDispatcher.java:679)
> at org.apache.catalina.core.ApplicationDispatcher.processRequest
> (ApplicationDispatcher.java:461)
> at org.apache.catalina.core.ApplicationDispatcher.doForward
> (ApplicationDispatcher.java:399)
> at org.apache.catalina.core.ApplicationDispatcher.forward
> (ApplicationDispatcher.java:301)
> at org.sakaiproject.jsf.util.HelperAwareJsfTool.dispatch
> (HelperAwareJsfTool.java:170)
> at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.catalina.core.ApplicationDispatcher.invoke
> (ApplicationDispatcher.java:679)
> at org.apache.catalina.core.ApplicationDispatcher.processRequest
> (ApplicationDispatcher.java:461)
> at org.apache.catalina.core.ApplicationDispatcher.doForward
> (ApplicationDispatcher.java:364)
> at org.apache.catalina.core.ApplicationDispatcher.forward
> (ApplicationDispatcher.java:301)
> at org.sakaiproject.tool.impl.ActiveToolComponent
> $MyActiveTool.forward(ActiveToolComponent.java:475)
> at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool
> (SkinnableCharonPortal.java:1216)
> at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool
> (ToolHandler.java:188)
> at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet
> (ToolHandler.java:93)
> at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost
> (ToolHandler.java:70)
> at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost
> (SkinnableCharonPortal.java:1059)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:
> 616)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213)
> at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:172)
> at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:117)
> at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:108)
> at org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:174)
> at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:875)
> at org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
> 665)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:528)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:81)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.java:689)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
> 'sakai26x.blogger_post' doesn't exist
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
> at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
> at org.apache.commons.dbcp.DelegatingStatement.executeQuery
> (DelegatingStatement.java:208)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.persistence.SakaiPersistenceManager.executeQuerySQL
> (SakaiPersistenceManager.java:519)
> ... 69 more
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.searcher.SearchException
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.searcher.SearchEngine.getAllPost
> (SearchEngine.java:54)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.manager.SearchManager.getPosts
> (SearchManager.java:51)
> at
> uk.ac.lancs.e_science.sakaiproject.impl.blogger.BloggerImpl.getPosts
> (BloggerImpl.java:91)
> at
> uk.ac.lancs.e_science.sakai.tools.blogger.PostListViewerController.loadAllPost
> (PostListViewerController.java:108)
> at
> uk.ac.lancs.e_science.sakai.tools.blogger.PostListViewerController.reloadPosts
> (PostListViewerController.java:101)
> at
> uk.ac.lancs.e_science.sakai.tools.blogger.PostEditionAbstractController.doSave
> (PostEditionAbstractController.java:122)
> at
> uk.ac.lancs.e_science.sakai.tools.blogger.PostCreateController.doSave
> (PostCreateController.java:43)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:
> 126)
> at com.sun.faces.application.ActionListenerImpl.processAction
> (ActionListenerImpl.java:72)
> at javax.faces.component.UICommand.broadcast(UICommand.java:312)
> at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:
> 267)
> at javax.faces.component.UIViewRoot.processApplication
> (UIViewRoot.java:381)
> at com.sun.faces.lifecycle.InvokeApplicationPhase.execute
> (InvokeApplicationPhase.java:75)
> at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:
> 200)
> at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:
> 90)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:
> 565)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter
> (ExtensionsFilter.java:147)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at uk.ac.lancs.e_science.fileUpload.UploadFilter.doFilter
> (UploadFilter.java:116)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.catalina.core.ApplicationDispatcher.invoke
> (ApplicationDispatcher.java:679)
> at org.apache.catalina.core.ApplicationDispatcher.processRequest
> (ApplicationDispatcher.java:461)
> at org.apache.catalina.core.ApplicationDispatcher.doForward
> (ApplicationDispatcher.java:399)
> at org.apache.catalina.core.ApplicationDispatcher.forward
> (ApplicationDispatcher.java:301)
> at org.sakaiproject.jsf.util.HelperAwareJsfTool.dispatch
> (HelperAwareJsfTool.java:170)
> at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.catalina.core.ApplicationDispatcher.invoke
> (ApplicationDispatcher.java:679)
> at org.apache.catalina.core.ApplicationDispatcher.processRequest
> (ApplicationDispatcher.java:461)
> at org.apache.catalina.core.ApplicationDispatcher.doForward
> (ApplicationDispatcher.java:364)
> at org.apache.catalina.core.ApplicationDispatcher.forward
> (ApplicationDispatcher.java:301)
> at org.sakaiproject.tool.impl.ActiveToolComponent
> $MyActiveTool.forward(ActiveToolComponent.java:475)
> at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool
> (SkinnableCharonPortal.java:1216)
> at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool
> (ToolHandler.java:188)
> at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet
> (ToolHandler.java:93)
> at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost
> (ToolHandler.java:70)
> at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost
> (SkinnableCharonPortal.java:1059)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:
> 616)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213)
> at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:172)
> at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:117)
> at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:108)
> at org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:174)
> at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:875)
> at org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
> 665)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:528)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:81)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.java:689)
> at java.lang.Thread.run(Thread.java:595)
>
>
> --
> will trillich
> "Tis the set of the sails / And not the gales / That tells the way we
> go." -- Ella Wheeler Wilcox
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
More information about the sakai-dev
mailing list