[Mangos Zero] Cannot give ban on server

[feloy]

Hey guys,

I have an issue with giving bans.

I cannot ban anyone from the game.

All what can I do by ban command is to kick.

So I've tried to give ban mannualy in database.

All what I get looks like

Executing:

INSERT INTO `realmd`.`account_banned` (`id`, `bandate`, `unbandate`, `bannedby`, `banreason`, `active`) VALUES ('24', '0', '0', 'admin', 'admin', '1');

Operation failed: There was an error while applying the SQL script to the database.

ERROR 1452: 1452: Cannot add or update a child row: a foreign key constraint fails (`realmd`.`account_banned`, CONSTRAINT `account_banned_ibfk_1` FOREIGN KEY (`id`) REFERENCES `account` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

SQL Statement:

INSERT INTO `realmd`.`account_banned` (`id`, `bandate`, `unbandate`, `bannedby`, `banreason`, `active`) VALUES ('24', '0', '0', 'admin', 'admin', '1')

Looks like I have a problem with Foreign key, but dk how to fix this

And still cannot find the answer, why I cannot ban anyone, in the Internet.

Looking for fast help cause I'm in a litte mess right now

[Talendrys]

Indeed, you have a problem with your insert query.

Can you please give me your account_banned table structure ? Looks like you are not inserting properly your record.

[feloy]

There it is

[Talendrys]

Are you sure that 24 is an ID of an account in your account table ?

It's what the SQL query is complaining about.

[feloy]

Yes, im 100% sure.

Even when I'm trying to ban trough game, nothing happens.

[Talendrys]

And what if you enter it manually via MySQL Workbench ?

[feloy]

I'm getting error which I've posted in first post.