The mailing list for listmasters using Sympa

["Stefan Hornburg (Racke)" <address@concealed>]

On 7/18/19 4:00 PM, dee heffem wrote:
> 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.
> 

Hello,

did you apply any changes to the structure of the user_table?

Can you please post the current structure of your user_table, e.g.

mysqldump --no-data sympa user_table

Regards
         Racke

-- 
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

Attachment: signature.asc
Description: OpenPGP digital signature