latest nightly build fails

[tonytony]

10:07:52,968 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:   SQL:  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)   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   File: d:\Tomcat\temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-47243.sql   Line: 20310:07:52,984 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failedcom.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‍‍‍‍‍‍‍‍‍

   

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.

[mabayona]

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.

- MySQL 5.X + Tomcat 5.x & 6.X + Apache 2.2.6.

[tonytony]

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.