On Tue, Nov 7, 2017 at 2:20 PM, Damith Wickramasinghe <[email protected]> wrote:
> Hi all, > > I'm using mysql version 5.7.20. In order to populate userdb and regdb i > need to run mysql scripts and i have used the scripts in APIM analytics > pack(mysql.sql). When run below issue arises, > > ERROR 1067 (42000): Invalid default value for 'REG_CREATED_TIME' > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > ERROR 1067 (42000): Invalid default value for 'REG_LAST_UPDATED_TIME' > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist > ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist > > Searching the issue found out i need to run NOT mysql.sql but > mysql5.7.sql. So for wt version does the mysql.sql works ? versions other > than 5.7 ? IF so we need to mention this clearly in the > docs . I found the same issue has been occurred for a customer as well. I > followed [1]. > mysql,sql will work versions prior to the vedrsion 5.7. We can add small note in the page. Can you create a doc jira for that. > > [1] - https://docs.wso2.com/display/AM210/Minimum+High+Availabilit > y+Deployment+for+WSO2+APIM+Analytics > > Regards, > Damith. > > -- > Senior Software Engineer > WSO2 Inc.; http://wso2.com > <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> > lean.enterprise.middleware > > mobile: *+94728671315 <+94%2072%20867%201315>* > > -- Harsha Kumara Software Engineer, WSO2 Inc. Mobile: +94775505618 <+94%2077%20550%205618> Blog:harshcreationz.blogspot.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
