Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package postfixadmin for openSUSE:Factory checked in at 2022-12-09 13:18:05 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/postfixadmin (Old) and /work/SRC/openSUSE:Factory/.postfixadmin.new.1835 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "postfixadmin" Fri Dec 9 13:18:05 2022 rev:38 rq:1041738 version:3.3.13 Changes: -------- --- /work/SRC/openSUSE:Factory/postfixadmin/postfixadmin.changes 2022-12-05 18:01:15.700601356 +0100 +++ /work/SRC/openSUSE:Factory/.postfixadmin.new.1835/postfixadmin.changes 2022-12-09 13:19:32.607563410 +0100 @@ -1,0 +2,6 @@ +Thu Dec 8 22:02:12 UTC 2022 - Christian Boltz <suse-b...@cboltz.de> + +- Update to PostfixAdmin 3.3.13 + - Fix two MySQL issues in upgrade.php + +------------------------------------------------------------------- Old: ---- postfixadmin-3.3.12.tar.gz New: ---- postfixadmin-3.3.13.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ postfixadmin.spec ++++++ --- /var/tmp/diff_new_pack.ccmC0s/_old 2022-12-09 13:19:33.011565556 +0100 +++ /var/tmp/diff_new_pack.ccmC0s/_new 2022-12-09 13:19:33.015565577 +0100 @@ -18,7 +18,7 @@ Name: postfixadmin -Version: 3.3.12 +Version: 3.3.13 Release: 0 URL: http://postfixadmin.sourceforge.net/ Source0: https://github.com/postfixadmin/postfixadmin/archive/%{name}-%{version}.tar.gz ++++++ postfixadmin-3.3.12.tar.gz -> postfixadmin-3.3.13.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postfixadmin-postfixadmin-3.3.12/CHANGELOG.TXT new/postfixadmin-postfixadmin-3.3.13/CHANGELOG.TXT --- old/postfixadmin-postfixadmin-3.3.12/CHANGELOG.TXT 2022-12-04 21:47:07.000000000 +0100 +++ new/postfixadmin-postfixadmin-3.3.13/CHANGELOG.TXT 2022-12-08 21:34:43.000000000 +0100 @@ -6,9 +6,16 @@ # # Further details on the project are available at https://github.com/postfixadmin/postfixadmin -Version 3.3.12 - TBC +Version 3.3.13 - 2022/12/08 +------------------------------------------------- + - MySQL collation fix for quota/quota2 tables ( see https://github.com/postfixadmin/postfixadmin/issues/690 ) + - Fix MySQL not liking "alter table drop constraint ..." which seems to be MariaDB only (see #561 and #687) (thank you @stefanomarty) + +Version 3.3.12 - 2022/12/04 ------------------------------------------------- - MySQL collation setting change, see https://github.com/postfixadmin/postfixadmin/issues/595 (and #327 and #552) + - Upgrade Smarty to 4.3.0 (see also #541) + - Improve PHP 8.1/8.2 compatability (see #632) Version 3.3.11 - 2022/03/02 ------------------------------------------------- diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/postfixadmin-postfixadmin-3.3.12/public/upgrade.php new/postfixadmin-postfixadmin-3.3.13/public/upgrade.php --- old/postfixadmin-postfixadmin-3.3.12/public/upgrade.php 2022-12-04 21:47:07.000000000 +0100 +++ new/postfixadmin-postfixadmin-3.3.13/public/upgrade.php 2022-12-08 21:34:43.000000000 +0100 @@ -164,8 +164,8 @@ foreach ($our_upgrade_functions as $function_name) { $bits = explode("_", $function_name); $function_number = $bits[1]; - if ($function_number > $current_version && $function_number > $target_version) { - $target_version = $function_number; + if (is_numeric($function_number)) { + $target_version = max($target_version, $function_number); } } @@ -1994,7 +1994,7 @@ db_query("ALTER TABLE $mailbox MODIFY maildir varchar(255) COLLATE latin1_general_ci NOT NULL"); db_query("ALTER TABLE $mailbox MODIFY local_part varchar(255) COLLATE latin1_general_ci NOT NULL"); db_query("ALTER TABLE $mailbox MODIFY domain varchar(255) COLLATE latin1_general_ci NOT NULL"); - db_query("ALTER TABLE $vacation_notification DROP CONSTRAINT vacation_notification_pkey"); + db_query("ALTER TABLE $vacation_notification DROP FOREIGN KEY vacation_notification_pkey"); db_query("ALTER TABLE $vacation MODIFY domain varchar(255) COLLATE latin1_general_ci NOT NULL"); db_query("ALTER TABLE $vacation MODIFY email varchar(255) COLLATE latin1_general_ci NOT NULL"); db_query("ALTER TABLE $alias_domain MODIFY alias_domain varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT ''"); @@ -2005,3 +2005,15 @@ db_query("ALTER TABLE $domain_admins MODIFY `domain` varchar(255) COLLATE latin1_general_ci NOT NULL"); } + +function upgrade_1847_mysql() { + # See https://github.com/postfixadmin/postfixadmin/issues/327 + # See https://github.com/postfixadmin/postfixadmin/issues/690 + # + # + + foreach (['quota','quota2'] as $table) { + $table = table_by_key($table); + db_query("ALTER TABLE $table MODIFY username varchar(255) COLLATE latin1_general_ci NOT NULL"); + } +}
