Skip to Content Skip to Menu

CB Activity Migration Failed

  • Ppetrik
  • Ppetrik
  • OFFLINE
  • Posts: 58
  • Thanks: 8
  • Karma: 0
10 months 1 week ago #336566 by Ppetrik
CB Activity Migration Failed was created by Ppetrik
Dear Support,
An error occurred during installation. Can you advise how to solve this issue?
Reinstalling didn't help.

Thank you

System Information
Joomla: 5.0.2
Community Builder: 2.9.1
PHP: 8.2.12
Database: mysql 10.11.5-MariaDB

Package
File: 000_plug_cbactivity_6.0.0+build.2024.01.10.18.22.20.05eef264f
Log:
Code:
CB Activity Migration (oprhaned_activity) Failed! Please Re-Install to Retry. Error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation 'like'

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 #336568 by krileon
Replied by krileon on topic CB Activity Migration Failed
You've mixed database collations. Try running CB > Tools > Check Community Builder Database to see if it can fix the collations for you then re-try install.

If it can't fix the collations for you use a tool like phpMyAdmin and under the Operations tab fix your database collations for all tables and their columns to utf8mb4_unicode_ci.

Migration is fail safe so no worries it will resume where it left off.

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.

  • Ppetrik
  • Ppetrik
  • OFFLINE
  • Posts: 58
  • Thanks: 8
  • Karma: 0
10 months 1 week ago #336607 by Ppetrik
Replied by Ppetrik on topic CB Activity Migration Failed
Resolved. The problem was caused by the installation of the jSitemap extension - utf8mb3_general_ci.
Thank you.
The following user(s) said Thank You: krileon

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

Moderators: beat, nant, krileon
Powered by Kunena Forum