topic latest nightly build fails in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172283#M125505 <HTML><HEAD></HEAD><BODY><PRE class="language-none line-numbers"><CODE><BR />10:07:52,968 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:<BR />&nbsp;&nbsp; SQL:&nbsp; DELETE FROM alf_node_aspects na USING alf_node_aspects na JOIN t_dup_aspects t ON (t.node_id = na.node_id AND t.qname_id = na.qname_id)<BR />&nbsp;&nbsp; Error: 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 'na USING alf_node_aspects na JOIN t_dup_aspects t ON (t.node_id = na.node_id AND' at line 1<BR />&nbsp;&nbsp; File: d:\Tomcat\temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-47243.sql<BR />&nbsp;&nbsp; Line: 203<BR />10:07:52,984 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed<BR />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 'na USING alf_node_aspects na JOIN t_dup_aspects t ON (t.node_id = na.node_id AND' at line 1<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>&nbsp;&nbsp;&nbsp;</SPAN><BR /><BR /><SPAN>Its trying to do somthing to the database, but its not working right. Whats the na for? The sql script that executed before this had a similar error.</SPAN></BODY></HTML> Fri, 25 Apr 2008 14:10:38 GMT tonytony 2008-04-25T14:10:38Z latest nightly build fails https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172283#M125505 10:07:52,968 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:&nbsp;&nbsp; SQL:&nbsp; DELETE FROM alf_node_aspects na USING alf_node_aspects na JOIN t_dup_aspects t ON (t.node_id = na.node_id AND t.qname_id = na.qname_id)&nbsp;&nbsp; Error: You have an error in your SQL syntax; check the ma Fri, 25 Apr 2008 14:10:38 GMT https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172283#M125505 tonytony 2008-04-25T14:10:38Z Re: latest nightly build fails https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172284#M125506 <HTML><HEAD></HEAD><BODY><SPAN>I´ve just installed latest nightly build from 24-4-2008 in two different computers (one upgrading from 2.1 community and another from 2.9B) and everything seems OK.</SPAN><BR /><BR /><SPAN>- MySQL 5.X + Tomcat 5.x &amp; 6.X + Apache 2.2.6.</SPAN></BODY></HTML> Fri, 25 Apr 2008 18:31:10 GMT https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172284#M125506 mabayona 2008-04-25T18:31:10Z Re: latest nightly build fails https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172285#M125507 <HTML><HEAD></HEAD><BODY><SPAN>I agree, the update is OK.. however I am performing a fresh install and some of these update scripts are a little wacky. I resolved the issue (I hope) by ignoring this and a couple of other delete statements.</SPAN></BODY></HTML> Wed, 30 Apr 2008 14:04:25 GMT https://connect.hyland.com/t5/alfresco-archive/latest-nightly-build-fails/m-p/172285#M125507 tonytony 2008-04-30T14:04:25Z