- Posts: 11
How To / General
Sync profiles to Joomla
- Kevin
- Topic Author
- Offline
- New Member
-
Less
More
1 year 4 months ago #1
by Kevin
Sync profiles to Joomla was created by Kevin
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.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7926
1 year 4 months ago #2
by Antonio Durán
Replied by Antonio Durán on topic Sync profiles to Joomla
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.
- Kevin
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
1 year 4 months ago #3
by Kevin
Replied by Kevin on topic Sync profiles to Joomla
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.