dmgeurts commented 4 years ago

Likely similar to the ona MySQL 8* issue.

Installing database updates:
 ERROR => SQL statements failed:
Incorrect integer value: '' for column 'id' at row 1

 Unable to automatically process SQL statements
      Please try again, or add the following SQL statements manually:

insert into users (id, username, password, level) values ('', 'sys_build', '638c0b71a1677183e7840ae6b5b646a2', 0 ) on duplicate key update username='sys_build';

insert into sys_config (name, value, description, field_validation_rule, failed_rule_text, editable, deleteable) values ('build_dns_type', 'bind', 'DNS build type', '', '', 1, 1) on duplicate key update value='bind';

schoos76 commented 4 years ago

18 should fix this issue, just a small fix.

mattpascoe commented 4 years ago

Yep, I merged your PR.. ultimately I want to get rid of this silly 'sys_build' user anyway. It was an attempt at user isolation that really didn't pan out like I wanted.. It's just not a priority to go remove that user at this point. Thanks for the fix!

opennetadmin / build_bind

MySQL 8 issue on plugin activation #16

18 should fix this issue, just a small fix.