Hi Gayan, There are separate scripts for mysql 5.5 for bpmn. Have you tried with those scripts. You need to run following scripts located at <BPS_HOME>/dbscripts/bps/bpmn/create folder.
activiti.mysql55.create.engine.sql activiti.mysql55.create.history.sql We have not tested for mysql 5.7 AFAIU. Regards, Vinod On Tue, Jul 12, 2016 at 11:19 AM, Gayan Gunarathne <gay...@wso2.com> wrote: > Hi, > > Seems BPS 3.5.1 worked only with mysql 5.6. Got the following > incompatibility issues with mysql 5.5 and mysql 5.7. > But in the documentation we didn't mention anything about the mysql > version[1]. If we are support only mysql 5.6, shall we update the > documentation with the compatible mysql version? > > mysql 5.5 - Syntax incompatibility with BPMN_DB > > bps_rdbms | /usr/local/bin/docker-entrypoint.sh: running > /docker-entrypoint-initdb.d/bpsdb.sql > bps_rdbms | ERROR 1064 (42000) at line 2052: 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 '(3), > bps_rdbms | primary key (ID_) > bps_rdbms | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin' at > line 6 > bps_rdbms exited with code 1 > > > mysql 5.7 - Syntax incompatibility with WSO2_USER_DB > > bps_rdbms | /usr/local/bin/docker-entrypoint.sh: running > /docker-entrypoint-initdb.d/bpsdb.sql > bps_rdbms | ERROR 1067 (42000) at line 55: Invalid default value for > 'REG_CREATED_TIME' > bps_rdbms exited with code 1 > > [1]https://docs.wso2.com/display/BPS351/Setting+up+MySQL > > Thanks, > Gayan > > -- > > Gayan Gunarathne > Technical Lead, WSO2 Inc. (http://wso2.com) > Committer & PMC Member, Apache Stratos > email : gay...@wso2.com | mobile : +94 775030545 <%2B94%20766819985> > > > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Vinod Kavinda Software Engineer *WSO2 Inc. - lean . enterprise . middleware <http://www.wso2.com>.* Mobile : +94 (0) 712 415544 Blog : http://soatechflicks.blogspot.com/
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev