× How To / General

Sync profiles to Joomla

3 months 7 hours ago
Kevin
Posts: 11
More
Topic Author
Sync profiles to Joomla #1
I am using they Joomla Fields plugin with several mapped fields between moodle and joomla and when i try to do a sync it fails on a record throwing the error:

Incorrect string value: '\xFCder W...' for column `db`.`joom_fields_values`.`value` at row 1

i have narrowed it down that i don't believe it likes an umlaut character that exists in the moodle user profile when trying to add it to the joomla db. I can manually update the field in Joomla without an issue. looking for any recommendations as to why this occurring and what i can do to make it work?

Please Log in or Create an account to join the conversation.

2 months 4 weeks ago
Antonio Durán
Posts: 7815
More
Sync profiles to Joomla #2
I have tested this locally but could not replicate the issue.

I set a field to this value: "ä, ö, and ü."
I saved the user in Joomla and Moodle and it synced correctly to the other side.
I also used "sync profiles" options in Joomdle->Users without an issue.

Maybe you are doing something different?

Please Log in or Create an account to join the conversation.

2 months 3 weeks ago
Kevin
Posts: 11
More
Topic Author
Sync profiles to Joomla #3
yea its strange, i can manually use the characters in either platform, the characters work fine when i sync joomla->moodle with the fields plugin but when i try to reverse it and have the character in a moodle -> joomla sync its gets the dreaded 1366 db error. I've tried ruling out all the db encoding issues but making sure all databases/tables/columns are using the utf8mb4 charset. I'll keep digging, i may be missing something in the db configuration.

Please Log in or Create an account to join the conversation.