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

Reply via email to