Skip to Content Skip to Menu

Error on CB Activity Update

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
10 months 2 weeks ago #336475 by krileon
Replied by krileon on topic Error on CB Activity Update
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.

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

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
10 months 2 weeks ago #336476 by eciudad
Replied by eciudad on topic Error on CB Activity Update
Thank you. Made changes and update went fine.
The following user(s) said Thank You: krileon

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

  • activha
  • activha
  • OFFLINE
  • Posts: 2334
  • Thanks: 117
  • Karma: 13
10 months 1 week ago - 10 months 1 week ago #336477 by activha
Replied by activha on topic Error on CB Activity Update
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

Package
File: 000_plug_cbactivity_6.0.0+build.2024.01.09.00.36.03.2295519ee.zip
Log:
Code:
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 :-(

Thanks for letting me know what to do ?
Last edit: 10 months 1 week ago by activha.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
10 months 1 week ago #336480 by krileon
Replied by krileon on topic Error on CB Activity Update
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.

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

Moderators: beat, nant, krileon
Powered by Kunena Forum