Duplicate foreign key in hook_vanish table #382


  • New
  • Defect
Open
Assigned to _ForgeUser7781625
  • _ForgeUser10410362 created this issue Apr 26, 2016

    What steps will reproduce the problem?
    1. Enable hook_vanishnopacket
    2. Restart server

    What is the expected output? What do you see instead?
    Create table stats_hook_vanish

    What version of the product are you using?
    latest

    Do you have an error log of what happened? (Portal: check cache/error.txt)
    CREATE TABLE IF NOT EXISTS `statistics`.`stats_hook_vanish` (
      `player_id` INT NOT NULL ,
      `is_vanished` TINYINT(1) NOT NULL DEFAULT 0 ,
      PRIMARY KEY (`player_id`) ,
      CONSTRAINT `stats_fk_player_id20`
        FOREIGN KEY (`player_id` )
        REFERENCES `statistics`.`stats_players` (`player_id` )
        ON DELETE CASCADE
        ON UPDATE NO ACTION);

    /* Ошибка SQL (1005): Can't create table 'statistics.stats_hook_vanish' (errno: 121)

    Duplicate key on write or update */

    Please provide any additional information below. (Plugin/Portal Version, Server Version, PHP Version. MySQL Version)

    Solution:
    Change foreign key name to 'stats_fk_player_id22' or nextone...
    'stats_fk_player_id20' conflicts with stats_player_locations table

  • _ForgeUser10410362 added the tags New Defect Apr 26, 2016

To post a comment, please login or register a new account.