topic MYSql problem while upgrading to Alfresco 3.2 in Alfresco Archive

MYSql problem while upgrading to Alfresco 3.2

breandanose — Thu, 30 Jul 2009 19:58:26 GMT

Hello,Just wondering has anyone had problems like this before while upgrading from Alfresco 3stable Community to Alfresco 3.2 Community?Error: Can't create table 'alfresco.alf_content_data' (errno: 150)See exception details below:11:52:46,474 ERROR [domain.schema.SchemaBootstrap] Statement executio

Re: MYSql problem while upgrading to Alfresco 3.2

breandanose — Fri, 31 Jul 2009 15:02:56 GMT

Hello,

I got this resolved, For anybody having this problem in the future, the error message is a bit cryptic though. It was happening for me when upgrading MySQL. MySql 4.0 had a default Charset of "latin1" and Mysql 5.0 has a default Charset of "uft8". For Alfresco the "utf8" option should be selected if installing a new MySQL server but I was using an old one that had the default as "latin1". Anyway, to fix, I simply converted the Alfresco database to "utf8" using the MYSQL GUI tools Migration Toolkit. Hope this maybe helps someone.

Re: MYSql problem while upgrading to Alfresco 3.2

mikeh — Fri, 31 Jul 2009 15:07:05 GMT

Thanks for the follow-up. Glad you got it sorted out.

Mike