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

alfresco.com | 4 months ago
  1. 0

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

    alfresco.com | 4 months ago
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_store' doesn't exist
  2. 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]
  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 | 12 months 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