It's erroring when trying to store a unicode emoji. Please be sure your database collation is correctly set to utf8mb4_unicode_ci. All your tables and the columns in those tables should have that collation. This can be set from the Operations tab in phpmyadmin for all your tables and their columns. Without the correct collation the unicode characters won't store.
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.
Hi
It seems like I have the same kind of issue with :
System Information
Joomla: 5.0.1
Community Builder: 2.9.1
PHP: 8.2.14
Database: mysql 10.4.32-MariaDB-1:10.4.32+maria~deb10
CB Activity Migration (oprhaned_activity) Failed! Please Re-Install to Retry. Error: Column 'stream_id' cannot be null
It seems to come from the autoactions that I had and which are storing activities asset like for instance activha.group.55.event.26.activation.11827
The thing is that all stream_id referring to this kind of assets are set to zero and the installation fails.
So I'm stuck with no longer CB Activity 5 and failed installation of CB Activity 6
This is now fixed in latest CB Activity build release. Please try updating again. It will skip over orphaned activity and comments it can't migrate. You will need to assign streams to those posts in CB Activity > Activity using the batch tool. There's a search filter specifically for finding orphaned posts. This is happening basically because it can't find a stream that it thinks the post belongs to and is normal when dealing with custom activity.
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.
krileon
