Error while saving player --- every relog tp to temple

[tuduras]

1.Hello, I have problem with saving player status. When I relog after few move in game , and log in then teleport me to temple with 8level and reset level. I used otx 2.16 based on 0.3.7. Can anyone helP :?


SOlv3d

 

[Stanos]

hmm?

CREATE TABLE `player_autoloot` (
  `player_id` INT(11) NOT NULL,
  `autoloot_list` TEXT DEFAULT NULL,
  PRIMARY KEY (`player_id`),
  CONSTRAINT `fk_player_autoloot_player`
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`)
    ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 

[Sorky]

you use outdaded schema, try to find working schema in your distro and run the scirpt

 

[Gesior.pl]

hmm?

CREATE TABLE `player_autoloot` (
  `player_id` INT(11) NOT NULL,
  `autoloot_list` TEXT DEFAULT NULL,
  PRIMARY KEY (`player_id`),
  CONSTRAINT `fk_player_autoloot_player`
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`)
    ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

@tuduras Your database does not have all required tables.
Run @Stanos SQL code in MySQL (phpmyadmin etc.). If it does not fix your 'autoloot' error, post src/iologindata.cpp from your OTS, so we can adjust structure of that table for your server.

 

[tuduras]

okay. I update my databasea . I added sql query autoloot and works. Now characater after relog are saved. Thanks mates