Jump to content

[sql fix][7938] characters.account column type

Guest charlie2025

Recommended Posts

Format of column in realmd.account is bigint(20) , but in characters.account , but column account is the same value (number, identifier.. what you want) as id in account table and is "only" int(11). So if case, id in account.id will be bigger then character creation and pointing characters to account gets bugged.

Fix to set characters.account as bigint(20)

ALTER TABLE `characters`.`characters` MODIFY `account`
bigint(20) unsigned NOT NULL default '0' COMMENT 'Account Identifier';

or, if you thing that 4294967295 is enough, set account.id as int(11)

ALTER TABLE `realmd`.`account` MODIFY `id`
int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';

Link to comment
Share on other sites

  • 4 months later...
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use