<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On 09 Nov 2005, at 13:24, Gerhard Killesreiter wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">On Wed, 9 Nov 2005, Kieran Lal wrote:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV> <BR><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Hi, as part of the Drupal administration user experience survey we</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">are improving the upgrade instructions for Drupal.<SPAN class="Apple-converted-space"> </SPAN>This was listed</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">as the 5th most difficult administration task.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">During interviews with administrators we learned that people want to</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">know if they need to upgrade their database or just apply new files</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">as in the recent security releases.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I have created a page: Do I need upgrade my database? http://</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">drupal.org/node/37017</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I was told that the changelog ( <A href="http://drupal.org/CHANGELOG.txt">http://drupal.org/CHANGELOG.txt</A> )</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">contained this information.<SPAN class="Apple-converted-space"> </SPAN>But it is not obvious to me.<SPAN class="Apple-converted-space"> </SPAN>How do I</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">create an official list of which releases require a DB update?</DIV> <BR></BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Rule of thumb:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Major releases have a db upgrade, minor ones don't.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">The latter was not true for the 4.6.1 release, I think. It was the first</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">to break the rule, IIRC.</DIV></BLOCKQUOTE><BR></DIV><DIV>Speaking of such, I think there may be a lurking problem with the 4.6.x (where x>0) to 4.7 upgrade.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>IIRC, the mechanism for determining what updates need to be applied is a string >= comparison on the date of the update.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>The last update for 4.6.0 was "2005-03-21" (I think). Since then, there have been a number of updates in the 4.6.x trunk and a different sequence of updates in the 4.7 trunk. I think this creates the risk that some of the 4.7 upgrades (i.e. those with dates <= the 4.6.x upgrades) will get skipped.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Has anyone verified that the 4.6.x -> 4.7 upgrade does in fact get all of the 4.7 schema updates? I can't; I just don't have time to spend on Drupal until well after the 4.7 release.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>-Eric</DIV><DIV><BR class="khtml-block-placeholder"></DIV><FONT class="Apple-style-span" color="#0000DD"></FONT></BODY></HTML>