Просмотр кода страницы Livestreetcms - SQL Error: Cannot add or update a child row: a foreign key constraint fails

=== Livestreetcms - SQL Error: Cannot add or update a child row: a foreign key constraint fails ===


Ошибка вида:
 SQL Error: Cannot add or update a child row: a foreign key constraint fails (`ether2_cm`.`prefix_forum_topic_view`, CONSTRAINT `prefix_forum_topic_view_fk` FOREIGN KEY (`topic_id`) REFERENCES `prefix_topic` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE) at /home/ether2/public_html/cm.xyz/engine/classes/MapperORM.class.php line 35
 Array ( [code] => 1452 [message] => Cannot add or update a child row: a foreign key constraint fails (`ether2_cm`.`prefix_forum_topic_view`, CONSTRAINT `prefix_forum_topic_view_fk` FOREIGN KEY (`topic_id`) REFERENCES `prefix_topic` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE) [query] => INSERT INTO prefix_forum_topic_view SET `topic_id`='3', `topic_views`='16' [context] => /home/ether2/public_html/cm.xyz/engine/classes/MapperORM.class.php line 35 ) 



Решение - фиксим через sql запросы:<br />

'''CPanel --> phpmyadmin --> Нажимаете слева на базу --> Нажимаете на вкладку "SQL" и вводите команды по одной.'''

 ALTER TABLE `prefix_forum_topic_view`
 DROP FOREIGN KEY `prefix_forum_topic_view_fk`;    <br />
 ALTER TABLE `prefix_forum_topic_view`
 ADD CONSTRAINT `prefix_forum_topic_view_fk` FOREIGN KEY (`topic_id`) REFERENCES `prefix_forum_topic` (`topic_id`) ON DELETE  CASCADE ON UPDATE CASCADE;