Skip to content

Instantly share code, notes, and snippets.

@kaihendry
Created August 5, 2019 09:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kaihendry/c889559d5afd660163d6367bd21348b7 to your computer and use it in GitHub Desktop.
Save kaihendry/c889559d5afd660163d6367bd21348b7 to your computer and use it in GitHub Desktop.
WARNING: We are about to convert your table storage format to UTF-8. This
allows Bugzilla to correctly store and sort international characters.
However, if you have any non-UTF-8 data in your database,
it ***WILL BE DELETED*** by this process. So, before
you continue with checksetup.pl, if you have any non-UTF-8
data (or even if you're not sure) you should press Ctrl-C now
to interrupt checksetup.pl, and run contrib/recode.pl to make all
the data in your database into UTF-8. You should also back up your
database before continuing. This will affect every single table
in the database, even non-Bugzilla tables.
If you ever used a version of Bugzilla before 2.22, we STRONGLY
recommend that you stop checksetup.pl NOW and run contrib/recode.pl.
Converting table storage format to utf8mb4 (collate utf8mb4_unicode_520_ci). This may take a while.
ut_local_dev_lambda_calls.notification_type needs to be converted to utf8mb4 (collate utf8mb4_unicode_520_ci)...
ut_local_dev_lambda_calls.json_payload needs to be converted to utf8mb4 (collate utf8mb4_unicode_520_ci)...
Converting the ut_local_dev_lambda_calls table to UTF-8...
DBD::mysql::db do failed: Cannot change column 'notification_type': used in a foreign key constraint 'notification_type_must_exist' [for Statement "ALTER TABLE ut_local_dev_lambda_calls MODIFY COLUMN notification_type varchar(255) CHARACTER SET binary NOT NULL, MODIFY COLUMN json_payload TEXT CHARACTER SET binary"] at Bugzilla/DB.pm line 52.
Bugzilla::DB::__ANON__(Bugzilla::DB::Mysql=HASH(0x562d2f1d4850), "ALTER TABLE ut_local_dev_lambda_calls MODIFY COLUMN notificat"...) called at Bugzilla/DB/Mysql.pm line 776
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x562d2f1d4850)) called at ./checksetup.pl line 123
DBD::mysql::db do failed: Cannot change column 'notification_type': used in a foreign key constraint 'notification_type_must_exist' [for Statement "ALTER TABLE ut_local_dev_lambda_calls MODIFY COLUMN notification_type varchar(255) CHARACTER SET binary NOT NULL, MODIFY COLUMN json_payload TEXT CHARACTER SET binary"] at Bugzilla/DB.pm line 52.
Bugzilla::DB::__ANON__(Bugzilla::DB::Mysql=HASH(0x56418b8a3860), "ALTER TABLE ut_local_dev_lambda_calls MODIFY COLUMN notificat"...) called at Bugzilla/DB/Mysql.pm line 776
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x56418b8a3860)) called at ./checksetup.pl line 123
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment