Comment to 'Language Translation - Is this a mistake in Russian module ?'
  • Error
    Database query error
    Query:
    SELECT 0 `id`, 'സ്ഥിരസ്ഥിതി' `title` UNION (SELECT `l`.`id`, `l`.`title` FROM `bx_events_favorites_lists` `l` INNER JOIN `bx_events_favorites_track` `t` ON `t`.`list_id` = `l`.`id` WHERE `l`.`author_id` = :author GROUP BY `l`.`id`, `l`.`title` ORDER BY `l`.`date` DESC) LIMIT 0, 6
    
    
    Mysql error:
    Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'
    
    
    collation_connection:
    utf8mb4_unicode_ci
    
    Debug backtrace:
    ...
    ... < TRUNCATED BY ME> ...
    

    I can send you the debug trace if needed.

    BTW additional clue

    ## Getting error for this url
    /joined-events/administrator?owner=1
    
    
    ## No error for the following urls
    /events-calendar
    /events-joined
    /events-home
    ...
    other events url are all ok.
    
    • Wondering why there is a /joined-events/ and another /events-joined/. url .. ?

    • You need to review both mentioned tables:

      bx_events_favorites_lists` and  `bx_events_favorites_track
      

      and check the collation there. Both should have utf8mb4_unicode_ci variant. All tables of UNA should have this collation.