×
How To / General
Sync profiles to Joomla
3 months 7 hours ago
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?
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
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?
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
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.