AnsweredAssumed Answered

latest nightly build fails

Question asked by tonytony on Apr 25, 2008
Latest reply on Apr 30, 2008 by 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.

Outcomes