28 June 2011, 1:09

I have followed the instructions for uninstalling My Learning plug-in here:

https://wiki.mahara.org/index.php/Plugins/Artefact/My_Learning/Uninstalling

However, at steps 4 and 7 I get this error from phpMyAdmin:

#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`comvirtmahara`.`block_instance`, CONSTRAINT `blocinst_blo_fk` FOREIGN KEY (`blocktype`) REFERENCES `blocktype_installed` (`name`))

Any hint why I get this?

I am using MySql 5.1.53 and phpMyAdmin 3.3.10.

Thanks in advance.

28 June 2011, 5:21

You must first delete all instances in 'block_instance' table, which contain reference to MyLearning blocks...

HTH,
Gregor

28 June 2011, 11:54

Thanks Gregor, it worked. It was not easy to find the "mylearning" and "multipleinteligences" instances in 'block_instance' table, but I managed to delet them.

Uninstalling MyLearning plugin fixed a problem of "site unavailable" I had after the upgrade from v1.3.3 to 1.4  :)

[ By the way, I took the freedom to fix the step 7 from the wiki tutorial where the mhr_ prefix still was in the command, in order to provide uniformity with the previous SQL sentences (even if you warn at the begining to take care of that). ]

Roberto.