vijuga added a discussion

When transferring data from the Dolphin to UNU program, the program stops and does not load more profiles


Comments
  • Query:
    SELECT COUNT(*) FROM `bx_albums_files` WHERE `profile_id` = ? AND `file_name` = ? AND `added` = ? LIMIT 1

    Mysql error:
    Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '='

    Location:
    The error was found in getOne function in the file /home/vijugaco/public_html/modules/boonex/dolphin_migration/classes/BxDolMPhotoAlbums.php at line 158.

    collation_connection:
    utf8mb4_unicode_ci

    • Hello,

      Can you please describe how did you install Una script?

      By default, UNA database's should has utf8mb4_unicode_ci collation. 

      You need to change charset from latin1_swedish_ci to utf8mb4_unicode_ci in all tables, otherwise you will have problems with special symbols in UNA and with migration tool also.

      • just installed over Softaculous. 


        We are honestly not some developers, so today we are all about it all day


        • Hello!

          Provie me please with your access info via PM, I will database.