The mailing list for listmasters using Sympa

[dee heffem <address@concealed>]

Hello,
I have upgraded my sympa list from 6.1.17 to 6.2.24 and noticing some
errors in the syslog about the database. How can I fix this?

Thank you


Jul 18 08:46:29 lists dbus-daemon[1023]: [system] Reloaded configuration
Jul 18 08:46:32 lists task_manager[21883]: notice main::execute()
Running task /var/spool/sympa/task/1563457532..purge_user_table._global,
line 0 with vars )
Jul 18 08:46:32 lists task_manager[21883]: err main::#399 >
main::execute#808 > main::cmd_process#868 > main::purge_user_table#1542
> Sympa::Database::do_prepared_query#382 Unable to execute SQL statement
"UPDATE user_table SET last_active_date_user = ? WHERE
last_active_date_user IS NULL OR EXISTS ( SELECT 1 FROM admin_table
WHERE admin_table.user_admin = user_table.email_user ) OR EXISTS (
SELECT 1 FROM subscriber_table WHERE subscriber_table.user_subscriber =
user_table.email_user )": (HY000) Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Jul 18 08:46:32 lists task_manager[21883]: err main::#399 >
main::execute#808 > main::cmd_process#868 > main::purge_user_table#1560
Failed to check activity of users
Jul 18 08:46:32 lists task_manager[21883]: err main::#399 >
main::execute#817 Error while processing task, removing
/var/spool/sympa/task/1563457532..purge_user_table._global
Jul 18 08:46:46 lists systemd[1]: Started Session 595 of user root.