com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store' doesn't exist

alfresco.com | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    'alfresco.alf_store' doesn't exist and other errors | Alfresco Forums

    alfresco.com | 7 months ago
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store' doesn't exist
  2. 0

    RE: Connecting with MySQL - Forums | Liferay

    liferay.com | 2 years ago
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1 [See nested exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1]
  3. 0

    Upgrade Liferay 6.1.0 GA1 to Liferay 6.1.1 GA2 - Foren | Liferay

    liferay.com | 1 year ago
    com.liferay.portal.kernel.events.ActionException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'state_' in 'field list'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RE: SQLGrammarException MySQLSyntaxErrorException - Forums | Liferay

    liferay.com | 1 year ago
    com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    RE: Connecting with MySQL - Forums | Liferay

    liferay.com | 1 year ago
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1 [See nested exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1]

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

      Table 'alfresco.alf_store' doesn't exist

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      PreparedStatement.executeQuery
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
      3. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
      4. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
      6. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
      7. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
      7 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeQuery
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      1 frame
    4. Hibernate
      QueryLoader.list
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:662)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      5. org.hibernate.loader.Loader.doList(Loader.java:2145)
      6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
      7. org.hibernate.loader.Loader.list(Loader.java:2024)
      8. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
      8 frames
    5. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.list
      1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
      1 frame
    6. Hibernate
      QueryImpl.list
      1. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
      2. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
      3. org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      3 frames
    7. org.alfresco.repo
      HibernateNodeDaoServiceImpl$3.doInHibernate
      1. org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$3.doInHibernate(HibernateNodeDaoServiceImpl.java:261)
      1 frame
    8. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
      2. org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)
      2 frames
    9. org.alfresco.repo
      HibernateNodeDaoServiceImpl.getStores
      1. org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getStores(HibernateNodeDaoServiceImpl.java:264)
      1 frame
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    11. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
      3 frames
    12. org.alfresco.repo
      TransactionalDaoInterceptor.invoke
      1. org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)
      1 frame
    13. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
      2 frames
    14. Unknown
      $Proxy1.getStores
      1. $Proxy1.getStores(Unknown Source)
      1 frame
    15. org.alfresco.repo
      DbNodeServiceImpl.getStores
      1. org.alfresco.repo.node.db.DbNodeServiceImpl.getStores(DbNodeServiceImpl.java:162)
      1 frame
    16. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    17. org.alfresco.repo
      StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke
      1. org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)
      1 frame
    18. Unknown
      $Proxy2.getStores
      1. $Proxy2.getStores(Unknown Source)
      1 frame
    19. org.alfresco.repo
      IndexRecoveryJob.execute
      1. org.alfresco.repo.node.index.FullIndexRecoveryComponent$2.doWork(FullIndexRecoveryComponent.java:283)
      2. org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)
      3. org.alfresco.repo.transaction.TransactionUtil.executeInNonPropagatingUserTransaction(TransactionUtil.java:108)
      4. org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindex(FullIndexRecoveryComponent.java:309)
      5. org.alfresco.repo.node.index.IndexRecoveryJob.execute(IndexRecoveryJob.java:31)
      5 frames
    20. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:191)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
      2 frames