[MDL-34318] Blog associations are never removed from the database - Moodle Tracker

XML

Word

Printable

Affected Branches:
MOODLE_23_STABLE
Fixed Branches:
MOODLE_22_STABLE, MOODLE_23_STABLE
Pull from Repository:
git://github.com/abgreeve/moodle.git
Pull Master Branch:
wip-~~MDL-34318~~-master
Pull Master Diff URL:
https://github.com/abgreeve/moodle/compare/wip-MDL-34318-master
Testing Instructions:
Hide

Before testing
It would be ideal to have access to the database tables so that you can confirm that the entries have been deleted.

Testing Steps

Go to [Settings ► Site administration ► Appearance ► Blog] and 'Enable blog associations'

Go to a course or create on if you don't have one.

Add the Blog Menu block.

'Add an entry about this course' (Fill out the form details). Save changes.

Check the database (mdl_blog_association). You should have an entry in this table.

Delete the blog entry.

Re-check the database table. The entry should be deleted.
Show
Before testing It would be ideal to have access to the database tables so that you can confirm that the entries have been deleted. Testing Steps Go to [Settings ► Site administration ► Appearance ► Blog] and 'Enable blog associations' Go to a course or create on if you don't have one. Add the Blog Menu block. 'Add an entry about this course' (Fill out the form details). Save changes. Check the database (mdl_blog_association). You should have an entry in this table. Delete the blog entry. Re-check the database table. The entry should be deleted.

When a blog entry that is associated with a module or a course is removed, the blog association is not removed from the database.

Replication steps:

Create a new blog entry that is associated with a course or a module. (See http://docs.moodle.org/19/en/Blogs_2.0#Blog_associations on how to create associated blog entries.)
The entry will be saved in the database table [db prefix]_post, the association will be saved in the table [db prefix]_blog_association, note the last entry in the post table and the blog_association table, this is where your entry and it's association are saved.
Remove your newly created entry.
Take a new look at [db prefix]_post and [db prefix]_blog_association, the last entry in blog_association will remain, although the entry in the post table is removed.

Closed

Participants:: Adrian Greeve, Ankit Agarwal, Eloy Lafuente (stronk7), Erik Lundberg, Frédéric Massart, Michael de Raadt, Sam Hemelryk

Component watchers:: Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie