AnsweredAssumed Answered

Unable to add content/space. Please Help

Question asked by smschiu on Oct 22, 2012
With Alfresc 3.2r2, I restored alf_data from production site with "index.recovery.mode=VALIDATE". it seems that it is running.  I have error code when I am trying to add a PDF file.
15:06:42,958 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.ChildAssocImpl]; uncategorized SQLException for SQL [insert into alf_child_assoc (version, parent_node_id, type_qname_id, child_node_name_crc, child_node_name, child_node_id, qname_ns_id, qname_localname, is_primary, assoc_index) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1364]; Field 'qname_crc' doesn't have a default value; nested exception is java.sql.SQLException: Field 'qname_crc' doesn't have a default value
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.ChildAssocImpl]; uncategorized SQLException for SQL [insert into alf_child_assoc (version, parent_node_id, type_qname_id, child_node_name_crc, child_node_name, child_node_id, qname_ns_id, qname_localname, is_primary, assoc_index) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1364]; Field 'qname_crc' doesn't have a default value; nested exception is java.sql.SQLException: Field 'qname_crc' doesn't have a default value

Does anyone have any idea? How to fix it?

Thanks in advance

Outcomes