Upgrading Znuny from 7.0 to 7.1.3 issues

[hotkimchee]

Having issues with the migration.

Code: Select all

 Executing tasks ...

    Step 1 of 20: Check required Perl version ...
    Step 2 of 20: Check required Perl modules ...
    Step 3 of 20: Check if database has been backed up ...
    Step 4 of 20: Check required database version ...
    Step 5 of 20: Check database default storage engine ...
    Step 6 of 20: Upgrade database structure ...

       - Increase size of columns of database table standard_template
       - Create missing primary keys for database tables.

    Step 7 of 20: Migrate database to utf8mb4 ...
Variable 'default_storage_engine' is 'InnoDB'.
Variable 'innodb_file_per_table' is 'ON'.
Character set of the database changed successfully to utf8mb4.
    Step 8 of 20: Check database charset ...
    The setting character_set_client is: utf8mb4.
    Error: The setting character_set_database needs to be 'utf8'.

I went into the mysql to change it utf8, but still get the same error. I'm not sure what is happening because it says changing the character to set to utf8mb4, but then errors out that it's been changed. I would appreciate your help with this. Thank you.

[hkais]

Hi hotkimchee,

looks like an missed upgrade from 5->6, which was fixed there.

plz google for "How to fix Znuny error character_set_database" and you will find an article which explains what to do

I think it is obvious, but anyway. Ensure you have a backup...

[Johannes]

Having issues with the migration.

Code: Select all

 Executing tasks ...

    Step 1 of 20: Check required Perl version ...
    Step 2 of 20: Check required Perl modules ...
    Step 3 of 20: Check if database has been backed up ...
    Step 4 of 20: Check required database version ...
    Step 5 of 20: Check database default storage engine ...
    Step 6 of 20: Upgrade database structure ...

       - Increase size of columns of database table standard_template
       - Create missing primary keys for database tables.

    Step 7 of 20: Migrate database to utf8mb4 ...
Variable 'default_storage_engine' is 'InnoDB'.
Variable 'innodb_file_per_table' is 'ON'.
Character set of the database changed successfully to utf8mb4.
    Step 8 of 20: Check database charset ...
    The setting character_set_client is: utf8mb4.
    Error: The setting character_set_database needs to be 'utf8'.

I went into the mysql to change it utf8, but still get the same error. I'm not sure what is happening because it says changing the character to set to utf8mb4, but then errors out that it's been changed. I would appreciate your help with this. Thank you.

Hi,

just alter your DB to the correct set.

Code: Select all

ALTER DATABASE znuny CHARACTER SET utf8 COLLATE utf8_general_ci;

OR

Code: Select all

ALTER DATABASE znuny CHARACTER SET utf8 COLLATE utf8_general_ci;

depending on your install.

Regards
Johannes

[beingbaban]

Hi Johannes,

After altering database it worked for us but do we also need to change character set in mariadb config file

Pls refer screencap.