[Koha-bugs] [Bug 11562] QA: the sysprefs.sql is not correctly sorted

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11562

M. Tompsett <mtompset at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #24409|0                           |1
        is obsolete|                            |

--- Comment #3 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 25392
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=25392&action=edit
[SIGNED OFF] Bug 11562: sysprefs.sql is not correctly sorted.

The QA tools does not manage to catch error sorting on the sysprefs.sql
file if it is already bad sorted.

This patch tidies up the sysprefs file.

TEST PLAN
---------
0) Back up your system preferences table.
1) check out master
2) Use your koha database, and then:
    DELETE FROM systempreferences;
    SOURCE ~/kohaclone/installer/data/mysql/sysprefs.sql
3) suspend your mysql client and type something similar to:
    mysql -u root -p -e 'USE kohadata;SELECT * from systempreferences ORDER BY
Variable;' > ~/master_sysprefs
4) apply the patch
5) foreground your mysql client, and then:
    DELETE FROM systempreferences;
    SOURCE ~/kohaclone/installer/data/mysql/sysprefs.sql
6) suspend your mysql client and type something similar to:
    mysql -u root -p -e 'USE kohadata;SELECT * from systempreferences ORDER BY
Variable;' > ~/11562_sysprefs
7) foreground your mysql client and quit
8) Take a diff, they should be identical
    diff ~/master_sysprefs ~/11562_sysprefs

NOTE: You can't use your own system preferences values, because
      upgrades and changed values would require a lot of time
      to compare the results.

Signed-off-by: Mark Tompsett <mtompset at hotmail.com>

-- 
You are receiving this mail because:
You are watching all bug changes.