The UPGRADE file in the 3.1.6 Dist is bogus

[jhdarrah]

The instructions in the "UPGRADE" file in the 3.1.6 dist does not match the instructions found on the web for 3.1 documentation. the instruction numbering is off by one after the third step... I trashed my database because of this. Beware.

-- john

[jojo]

you shoul always read the UPGRADING and INSTALL from the distribution files

[jhdarrah]

The web instructions are correct, The "UPGRADING" file in the 3.1.6 distribution is incorrect.

In other words, I did read the file that came with the distribution.

-- john

[jojo]

as there were some changes in earlier versions of the 3.1. the one from the web is the wrong one...

[jhdarrah]

Looking back thru CVS on the UPGRADING file, for a patch level upgrade you always skip the "database changes" update, but in the 3.1.6 UPGRADING file, the following paragraph indicates that you execute item 8 in the list:

Within a single minor version you can skip patch level releases if you want to
upgrade. For instance you can upgrade directly from OTRS 3.1.1 to version
3.1.4. If you need to do such a "patch level upgrade", you should skip steps
9, 11 and 13-19

Note above that it indicates that item 8 is not skipped.

Item 8 is "Apply the database changes" and wants you to execute the following:

shell> cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs

This elicited many error messages.