Error Synchronization Ext Sonata Recording

Hi All,

If i try sync user on sonata recording it show error on apache log

Sonata recording version : 3.0.3-1

==> /var/log/httpd/error_log <==
[Mon Aug 08 16:47:35.772520 2022] [php7:error] [pid 6338] [client 101.214.11.11:64908] PHP Fatal error:  Uncaught Exception: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xE2\\x80\\x8Bsit...' for column `telerec`.`rec_extensions`.`name` at row 1 With Query: insert into `telerec`.`rec_extensions` (`ombu_extension_id`,`extension`,`ombu_extension_type`,`name`,`team_id`,`tenant_id`) values (?,?,?,?,?,?) in /usr/share/sonata/recordings/www/includes/db.php:0\nStack trace:\n#0 /usr/share/sonata/recordings/www/includes/db.php(0): includes\\db->__construct('insert into `te...', Array, Object(Closure))\n#1 /usr/share/sonata/recordings/www/includes/persistent.php(0): includes\\db::query(Object(includes\\insert_query), Array)\n#2 /usr/share/sonata/recordings/www/includes/persistent.php(0): modules\\extensions\\extensions_db->insert()\n#3 /usr/share/sonata/recordings/www/modules/synchronization/synchronization.php(0): modules\\extensions\\extensions_db->save()\n#4 /usr/share/sonata/recordings/www/includes/core.php(0): modules\\synchronization\\synchronization->put()\n#5 /usr/share/sonata/recordings/www/includes/core in /usr/share/sonata/recordings/www/includes/db.php on line 0, referer: https://detroipbx.com/recording/

Are you using non-English characters?

Hi Sir,

No i don’t sir, i use plain character.

Thanks

It seems that is detecting some invalid characters!!!

Hi Sir,

After update sql_mode=‘’ it working

[root@my.cnf.d]# vim /etc/my.cnf.d/vitalpbx.cnf

add
sql_mode=''

systemctl restart mariadb

Hi Sorry, you are correct sir. detecting some invalid characters!!!

Thanks