I have a stalemate - the programmer went on vacation, does not respond. A server administrator can not solve the problem.
Problem: ')
Can not delete records from a specific database table (MySQL, InnoDB) Neither through the admin site, nor via phpmyadmin, nor through the shell.
The admin has copied the entire database dump to his local computer, and also cannot delete certain records. He speaks about some connections of the tables, they say they can interfere. I do not know anything about this (since I’m not a programmer or an admin).
Have you encountered such a situation? Where to dig? Maybe lay out a dump, see?
PS: you need very sad PPS: thanks can be expressed not only in words :)
- UPDATE : as they say, thanks for the cons.
After 6 hours of discussion with Habrom and friends, I found the source of this problem in phpmyadmin:
The object_ table has a trigger.
DROP TRIGGER IF EXISTS `cottage`.`object_prop_clear` // CREATE TRIGGER `cottage`.`object_prop_clear` AFTER DELETE ON` cottage`.`object_` FOR EACH ROW BEGIN delete from object_prop where id = OLD.id; delete from object_foto where object_id = OLD.id; END //
This trigger had to be replaced in object_prop - “id” by “object_id”, because there is no id column in object_prop, but object_id is
Apparently, the field programmer renamed, and the trigger forgot to correct. Like this!