Hello
I want update field after one trigger. I used auto action filed and its worked exactly but when my value is "Persian language" (utf8 value) after save action my value changed to question mark (???).
this happen in query action too.
Is there any way for update field with utf8 value?
It shouldn't have any issues with valid UTF8 characters. Does storing a valid UTF8 character directly to a field in profile edit work fine? If it also bugs there then it could be a database collation issue.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Yes, in frontend when user changed his data from profile edit and in backend when admin changed data from CB user manager, value updated without any bugs.
Try using a query action as follows and see if it does the same.
Code:
UPDATE `#__comprofiler` SET `YOUR_FIELD_NAME_HERE` = 'YOUR_VALU_HERE' WHERE `id` = '[user_id]'
Replace YOUR_FIELD_NAME_HERE with the actual name of the field (e.g. cb_myfield) then add the value that you were using in your field action for YOUR_VALU_HERE. This is a direct database update query to the users CB row.
Please also ensure you're using the latest release of CB Auto Actions (5.1.3).
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.