Jump to content

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


Recommended Posts

Posted

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';

  • 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