tomsun28 commented on PR #1801: URL: https://github.com/apache/hertzbeat/pull/1801#issuecomment-2071954852
> The mysql 5.7 version is not able to execute these sql's and I think upgrading these is best for the user not to operate, can we find a better way? hi these sql are for h2 database, mysql version we can use navicat console or others to edit table column name here. ``` ALTER TABLE HZB_PARAM CHANGE COLUMN `value` param_value VARCHAR(255); ALTER TABLE HZB_TAG CHANGE COLUMN `value` tag_value VARCHAR(255); ALTER TABLE HZB_STATUS_PAGE_HISTORY CHANGE COLUMN `unknown` unknowing VARCHAR(255); ``` For the suggest upgrading, is the Export Import Method. Deploy an new empty system and them import the monitors. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
