[zanata-users] Problem installing zanata 3.6.0 on wildfly 8.1.0 fresh

[Sean Flanigan]

On 2015-03-26 20:22, Widura Schwittek wrote:
> Dear community!
> 
>  
> 
> I tried out to installing zanata with the zanata installer 3.6.0 for
> wildfly 8.1.0 on Oracle JDK 1.8.0_60-ea-b07. I followed the instructions
> on readthedocs. But I get the following exception while liquibase is
> applying the sql migration scripts:
> 
>  
> 
> 08:42:36,389Z ERROR [liquibase] (MSC service thread 1-4)
> db/db.changelog.xml:
> db/changelogs/db.changelog-1.5.xml::8::aeng at redhat.com: Change Set
> db/changelogs/db.changelog-1.5.xml::8::aeng at redhat.com failed.  Error:
> Error executing SQL ALTER TABLE zanata.HGlossaryEntry MODIFY id BIGINT
> AUTO_INCREMENT: Cannot change column 'id': used in a foreign key
> constraint 'UKglossaryterm_glossary_entry_id' of table
> 'zanata.hglossaryterm':
> 
>  
> 
> For testing I tried again giving all rights to the mysql user but
> without any change. Do you have any idea how to fix this?
> 
>  
> 
> Many thanks in advance!
> 
> Widura


Hi Widura,

Going by that error message, it sounds like you might be using mysql 5.6
or later. That's not supported, sorry:
https://bugzilla.redhat.com/show_bug.cgi?id=1048293


Zanata is mainly tested against mysql 5.5, although it generally works
(without guarantee) on mysql back to 5.1, or on recent versions of
mariadb.  I would recommend you try one of those options.


Regards


-- 
Sean Flanigan

Principal Software Engineer
Localisation Tools Engineering
Red Hat

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 213 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/zanata-users/attachments/20150327/5c03d3fa/attachment.sig>