latest nightly build fails

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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: 203
10:07:52,984 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
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
‍‍‍‍‍‍‍‍‍

   

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.