John Adams
10-28-2006, 04:40 PM
Not sure how this could suddenly come up, since I've been using the same PEQ distribution forever (and have other guilds created). Just tried to make a new guild, and it throws this error:
[10.28. - 21:15:47] [GUILDS__ACTIONS] Tester1: Creating guild Test1 with leader 101 with GM command. It was given id 3.
[10.28. - 21:15:47] [GUILDS__ERROR] Error Changing char 101 to guild 3 'REPLACE INTO guild_members (char_id,guild_id,rank) VALUES(101,3,2)': #1364: Field 'public_note' doesn't have a default value
Looking at the table "guild_members", field `public_note` is in fact set to NOT NULL, and no default value.
This is a fix:
ALTER TABLE `guild_members` CHANGE `public_note` `public_note` TEXT NULL
Edit: Sorry, let me add that this error shows up on any attempt to add a member to a guild via #guild command. Hadn't tested as a leader or officer yet.
[10.28. - 21:15:47] [GUILDS__ACTIONS] Tester1: Creating guild Test1 with leader 101 with GM command. It was given id 3.
[10.28. - 21:15:47] [GUILDS__ERROR] Error Changing char 101 to guild 3 'REPLACE INTO guild_members (char_id,guild_id,rank) VALUES(101,3,2)': #1364: Field 'public_note' doesn't have a default value
Looking at the table "guild_members", field `public_note` is in fact set to NOT NULL, and no default value.
This is a fix:
ALTER TABLE `guild_members` CHANGE `public_note` `public_note` TEXT NULL
Edit: Sorry, let me add that this error shows up on any attempt to add a member to a guild via #guild command. Hadn't tested as a leader or officer yet.