Memories Planet DB Download Error

🍱 Features & apps Memories
,
1

Hi,

I am having issues downloading the planet database when using Memories. When using the command occ memories:places-setup I get the following error:

Inserted 235500 / 635189 places (37.1%), Last: Al-Barka
 In ExceptionConverter.php line 119:                                                                                                                                                                
  An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\xA5\x95\xA2\xE9\x87...' for column  
   `nextcloud`.`oc_memories_planet`.`name` at row 1                                                                                                         
 In Exception.php line 30:
  SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\xA5\x95\xA2\xE9\x87...' for column `nextcloud`.`oc_memories_planet`.`name` at row     1
  In Statement.php line 101:
  SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\xA5\x95\xA2\xE9\x87...' for column `nextcloud`.`oc_memories_planet`.`name` at row  1

So I checked the troubleshooting page recommending to change the DB (MariaDB) to utf8mb4 characterset. Which I did:

MariaDB [nextcloud]> SHOW TABLE STATUS WHERE NAME LIKE 'oc_memories_planet';


+--------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
| Name               | Engine | Version | Row_format | Rows   | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation          | Checksum | Create_options | Comment | Max_index_length | Temporary |
+--------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
| oc_memories_planet | InnoDB |      10 | Dynamic    | 204423 |            110 |    22593536 |               0 |      2637824 |   7340032 |         182188 | 2023-12-02 10:28:03 | 2023-12-02 10:13:17 | NULL       | utf8mb4_unicode_ci |     NULL |                |         |                0 | N         |
+--------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+

I even checked the column

MariaDB [nextcloud]> SHOW FULL COLUMNS FROM oc_memories_planet;

+-------------+----------+--------------------+------+-----+---------+----------------+---------------------------------+---------+
| Field       | Type     | Collation          | Null | Key | Default | Extra          | Privileges                      | Comment |
+-------------+----------+--------------------+------+-----+---------+----------------+---------------------------------+---------+
| id          | int(11)  | NULL               | NO   | PRI | NULL    | auto_increment | select,insert,update,references |         |
| osm_id      | int(11)  | NULL               | NO   | MUL | NULL    |                | select,insert,update,references |         |
| name        | longtext | utf8mb4_unicode_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| admin_level | int(11)  | NULL               | NO   |     | NULL    |                | select,insert,update,references |         |
| other_names | longtext | utf8mb4_unicode_ci | YES  |     | NULL    |                | select,insert,update,references |         |
+-------------+----------+--------------------+------+-----+---------+----------------+---------------------------------+---------+

Does anyone know what went wrong?

I am using NC 27.1.4 and Memories 6.1.5

2