462213 - make migrateV8 tolerant to downgrade-upgrade paths

Status: VERIFIED FIXED

(Firefox :: Bookmarks & History, defect)

Description

[Marco Bonardo [:mak]]

migrateV8 does not check if triggers exists before deleting them, so if you upgrade/downgrade you could be without triggers with a migration path that requires them.

adding an IF EXISTS will make the query safe to execute

Comment 1

[Marco Bonardo [:mak]]

actual migration path that makes this visible is:
3.1 fsync => 3.1 no-fync => 3.1 fsync

Comment 2

[Marco Bonardo [:mak]]

Attachment: patch

Comment 3

[Shawn Wilsher :sdwilsh]

Comment on attachment 345355 [details] [diff] [review]
patch

r=sdwilsh

Comment 4

[Marco Bonardo [:mak]]

http://hg.mozilla.org/mozilla-central/rev/a82f43fff223

Comment 6

[Gervase Markham [:gerv]]

Bug 451915 - move Firefox/Places bugs to Firefox/Bookmarks and History. Remove all bugspam from this move by filtering for the string "places-to-b-and-h".

In Thunderbird 3.0b, you do that as follows:
Tools | Message Filters
Make sure the correct account is selected. Click "New"
Conditions: Body   contains   places-to-b-and-h
Change the action to "Delete Message".
Select "Manually Run" from the dropdown at the top.
Click OK.

Select the filter in the list, make sure "Inbox" is selected at the bottom, and click "Run Now". This should delete all the bugspam. You can then delete the filter.

Gerv