vijuga
 added a discussion 

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


  • 306
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

    0 0 0 0 0 0
    • 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.

      0 0 0 0 0 0
      • just installed over Softaculous. 


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


        0 0 0 0 0 0
        • Hello!

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

          0 0 0 0 0 0
          Not logged in users can't 'Comments Post'.
          Info

          UNA - Social Media Software Framework

          Close