topic SQLGrammarException Error on Alfresco Ent. 2.2 WAR in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sqlgrammarexception-error-on-alfresco-ent-2-2-war/m-p/179099#M132229 <HTML><HEAD></HEAD><BODY><SPAN>I had downloaded WAR file yesterday. There is one Tomcat instance, both Liferay and Alfresco must work together. Liferay working properly, there is no any problem. </SPAN><BR /><SPAN>I did extract WAR file into Tomcat /webapps/alfresco directory ( just WAR file, excep ZIP contents). </SPAN><BR /><SPAN>When I start the Tomcat, the following error message exception throwing. I can't find base SQL create files, so I can figure out myself. Thanks for your responce right now.</SPAN><BR /><BR /><SPAN>OS : Windows 2003 Standard</SPAN><BR /><SPAN>Java : JDK 1.6.0_10</SPAN><BR /><SPAN>Application Server : Tomcat 6.0</SPAN><BR /><BR /><SPAN>Apache Libs :</SPAN><BR /><SPAN> Directory of E:\Apache\Tomcat\lib</SPAN><BR /><BR /><SPAN>annotations-api.jar</SPAN><BR /><SPAN>catalina-ant.jar</SPAN><BR /><SPAN>catalina-ha.jar</SPAN><BR /><SPAN>catalina-tribes.jar</SPAN><BR /><SPAN>catalina.jar</SPAN><BR /><SPAN>el-api.jar</SPAN><BR /><SPAN>jasper-el.jar</SPAN><BR /><SPAN>jasper-jdt.jar</SPAN><BR /><SPAN>jasper.jar</SPAN><BR /><SPAN>jsp-api.jar</SPAN><BR /><SPAN>servlet-api.jar</SPAN><BR /><SPAN>tomcat-coyote.jar</SPAN><BR /><SPAN>tomcat-dbcp.jar</SPAN><BR /><SPAN>tomcat-i18n-es.jar</SPAN><BR /><SPAN>tomcat-i18n-fr.jar</SPAN><BR /><SPAN>tomcat-i18n-ja.jar</SPAN><BR /><BR /><BR /><SPAN> Directory of E:\Apache\Tomcat\lib\ext</SPAN><BR /><BR /><SPAN>activation.jar</SPAN><BR /><SPAN>ccpp.jar</SPAN><BR /><SPAN>container.jar</SPAN><BR /><SPAN>hsql.jar</SPAN><BR /><SPAN>jms.jar</SPAN><BR /><SPAN>jta.jar</SPAN><BR /><SPAN>jutf7.jar</SPAN><BR /><SPAN>mail.jar</SPAN><BR /><SPAN>mysql.jar</SPAN><BR /><SPAN>portal-kernel.jar</SPAN><BR /><SPAN>portal-service.jar</SPAN><BR /><SPAN>portlet-container.jar</SPAN><BR /><SPAN>portlet.jar</SPAN><BR /><SPAN>postgresql.jar</SPAN><BR /><SPAN>serializer.jar</SPAN><BR /><SPAN>support-tomcat.jar</SPAN><BR /><SPAN>xalan.jar</SPAN><BR /><SPAN>xercesImpl.jar</SPAN><BR /><SPAN>xml-apis.jar</SPAN><BR /><BR /><BR /><BR /><SPAN style="color:#800000;">ERROR MESSAGES :<BR />*********************************************************************************<BR /></SPAN><PRE class="language-none line-numbers"><CODE>12:51:30,679 INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script E:\Apache\Tomcat\temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-36157.sql (Copied from classpath:alfresco/dbscripts/create/2<BR />lect.MySQLInnoDBDialect/AlfrescoPostCreate-2.2-Extra.sql).<BR />12:51:30,695 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; CREATE INDEX fk_alf_na_qn ON alf_node_aspects (qname_id)<BR />12:51:30,851 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; ALTER TABLE alf_node_aspects ADD CONSTRAINT fk_alf_na_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id)<BR />12:51:31,023 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; CREATE INDEX fk_alf_np_qn ON alf_node_properties (qname_id)<BR />12:51:31,195 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; ALTER TABLE alf_node_properties ADD CONSTRAINT fk_alf_np_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id)<BR />12:51:31,382 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; CREATE INDEX fk_avm_na_qn ON avm_aspects_new (qname_id)<BR />12:51:31,539 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; ALTER TABLE avm_aspects_new ADD CONSTRAINT fk_avm_na_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id)<BR />12:51:31,711 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; CREATE INDEX fk_avm_np_qn ON avm_node_properties_new (qname_id)<BR />12:51:31,898 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; ALTER TABLE avm_node_properties_new ADD CONSTRAINT fk_avm_np_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id)<BR />12:51:32,054 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; CREATE INDEX idx_avm_hl_revpk ON avm_history_links (descendent, ancestor)<BR />12:51:32,226 DEBUG [domain.schema.SchemaBootstrap] Executing statement:&nbsp; CREATE INDEX idx_avm_vr_revuq ON avm_version_roots (avm_store_id, version_id)<BR />12:51:32,445 INFO&nbsp; [domain.schema.SchemaBootstrap] All executed statements written to file E:\Apache\Tomcat\temp\Alfresco\AlfrescoSchemaUpdate-All_Statements-36158.sql.<BR />12:51:32,523 ERROR [web.context.ContextLoader] Context initialization failed<BR />org.hibernate.exception.SQLGrammarException: could not load an entity: [org.alfresco.repo.avm.IssuerIDImpl#node]<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.Loader.loadEntity(Loader.java:1865)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2992)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.avm.hibernate.IssuerIDDAOHibernate.get(IssuerIDDAOHibernate.java:22)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.avm.Issuer$1.execute(Issuer.java:89)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:241)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:171)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.avm.Issuer.init(Issuer.java:84)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.avm.AvmBootstrap.onBootstrap(AvmBootstrap.java:92)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:516)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:578)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)<BR />Caused by: com.mysql.jdbc.exceptions.jdbc4.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 '?ssuer?d?m0_.issuer as is<BR />m0_.version as version33_0_, ?ssuer' at line 1<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.getInstance(Util.java:381)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.Loader.doQuery(Loader.java:662)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.loader.Loader.loadEntity(Loader.java:1851)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 51 more<BR />23.Eyl.2008 12:51:32 org.apache.catalina.core.StandardContext start<BR />SEVERE: Error listenerStart<BR />23.Eyl.2008 12:51:32 org.apache.catalina.core.StandardContext start<BR />SEVERE: Context [/alfresco] startup failed due to previous errors<BR />23.Eyl.2008 12:51:39 org.apache.catalina.core.StandardContext start<BR />SEVERE: Error listenerStart<BR />23.Eyl.2008 12:51:39 org.apache.catalina.core.StandardContext start<BR />SEVERE: Context [/share] startup failed due to previous errors<BR />23.Eyl.2008 12:51:53 org.apache.coyote.http11.Http11AprProtocol start<BR />INFO: Starting Coyote HTTP/1.1 on http-8080<BR />23.Eyl.2008 12:51:53 org.apache.coyote.ajp.AjpAprProtocol start<BR />INFO: Starting Coyote AJP/1.3 on ajp-8009<BR />23.Eyl.2008 12:51:53 org.apache.catalina.startup.Catalina start<BR />INFO: Server startup in 106473 ms<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 23 Sep 2008 10:17:51 GMT akeb0n0 2008-09-23T10:17:51Z SQLGrammarException Error on Alfresco Ent. 2.2 WAR https://connect.hyland.com/t5/alfresco-archive/sqlgrammarexception-error-on-alfresco-ent-2-2-war/m-p/179099#M132229 I had downloaded WAR file yesterday. There is one Tomcat instance, both Liferay and Alfresco must work together. Liferay working properly, there is no any problem. I did extract WAR file into Tomcat /webapps/alfresco directory ( just WAR file, excep ZIP contents). When I start the Tomcat, the follow Tue, 23 Sep 2008 10:17:51 GMT https://connect.hyland.com/t5/alfresco-archive/sqlgrammarexception-error-on-alfresco-ent-2-2-war/m-p/179099#M132229 akeb0n0 2008-09-23T10:17:51Z Re: SQLGrammarException Error on Alfresco Ent. 2.2 WAR https://connect.hyland.com/t5/alfresco-archive/sqlgrammarexception-error-on-alfresco-ent-2-2-war/m-p/179100#M132230 <HTML><HEAD></HEAD><BODY><SPAN>Just want add a small note. The operatings system default language is Turkish. I tried also English language, but didn't resolve the problem. I know the problem but I can't find sql files.</SPAN><BR /><BR /><SPAN>The error is wrong character mismatch, capitalization problem:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>"MySQL server version for the right syntax to use near '?ssuer?d?m0_.issuer as is<BR />m0_.version as version33_0_, ?ssuer' at line 1"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I think, should be below:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>'ISSUERIDM0_.ISSUER as is m0_.version as version33_0_, ISSUER' <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 23 Sep 2008 10:24:38 GMT https://connect.hyland.com/t5/alfresco-archive/sqlgrammarexception-error-on-alfresco-ent-2-2-war/m-p/179100#M132230 akeb0n0 2008-09-23T10:24:38Z