Author
|
Message
|
Senior Member
Join Date: Apr 2013
Location: /root
|
09-24-2014
, 16:58
[SOLVED] Fresly installed SourceBans mysql error
|
#1
|
Hi, I am trying to install sourcebans, so far so good but I get kind of this errors when trying do something (add admin, add/remove ban etc)
(Cannot add or update a child row: a foreign key constraint fails (`amr_sbans`.`sb_actions`, CONSTRAINT `action_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE))
Failed to insert the ID ban into the database: Cannot add or update a child row: a foreign key constraint fails (`amr_sbans`.`sb_bans`, CONSTRAINT `ban_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE SET NULL)
Database setting are OK,
Plugins works well,
Web panel works well,
How can I solve this error?
Edit:
Converting database from InnoDB to MyISAM solved the problem for me, thanks.
Last edited by Amroth; 09-24-2014 at 17:13.
|
|
|
|