Code:
[09.17. - 12:39:18] [GUILDS__ERROR] Error Changing char 1 to guild 1 'REPLACE INTO guild_members (char_id,guild_id,rank) VALUES(1,1,0)': #1364: Field 'public_note' doesn't have a default value
I believe this is the problem. manually setting a character into the guild, with a value in public_note sets that character into the guild.