Skip to Content Skip to Menu

Error on install of CB Activity

  • AlanJones
  • AlanJones
  • OFFLINE
  • Posts: 509
  • Thanks: 42
  • Karma: 2
9 years 5 months ago #264885 by AlanJones
Error on install of CB Activity was created by AlanJones
I have read through this thread: www.joomlapolis.com/forum/153-professional-member-support/229580-solved-cb-activity-3-rc1?limitstart=0
And confirmed that the user table is IBD. I'm still getting the error - when I run the CB Plugins Database tools I get errors with cb_activity - and the same error when I try fix: 1071 Specified key was too long; max key length is 1000 bytes SQL=ALTER TABLE `joa_comprofiler_plugin_activity` ADD KEY `type_item_date` (`type`, `item`, `date`)

Can you help?

Own Your Own Community!

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #264896 by krileon
Replied by krileon on topic Error on install of CB Activity
If you're getting that error then the table engine for _comprofiler_plugin_activity isn't InnoDB. InnoDB allows for 3500 bytes. Even if you're on an older MYSQL with 32 bit the limit is still higher than 1000 bytes. So you either need to fix your databases engine usage to InnoDB (plugins base their engine off _comprofiler and _comprofiler bases its engine off _users), modify the XML file and remove that index, or wait for RC2 where I've changed the index to have size limit to avoid it being so large.


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.
The following user(s) said Thank You: AlanJones

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

  • AlanJones
  • AlanJones
  • OFFLINE
  • Posts: 509
  • Thanks: 42
  • Karma: 2
9 years 5 months ago #265049 by AlanJones
Replied by AlanJones on topic Error on install of CB Activity
Thanks Krileon!

Own Your Own Community!

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #265055 by krileon
Replied by krileon on topic Error on install of CB Activity
This shouldn't be an issue anymore with now release CB Activity 3.0.0 RC2. If anyone is still having issues with it please let me know and will see if I can reduce the index size further, but I don't think I can without destroying performance.


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.

  • AlanJones
  • AlanJones
  • OFFLINE
  • Posts: 509
  • Thanks: 42
  • Karma: 2
9 years 5 months ago #265131 by AlanJones
Replied by AlanJones on topic Error on install of CB Activity
Thanks Krileon - Upload and install works great, but I'm not understanding the new feed.
It gives me a list of who did what + profile link, but no link or thumbnail to the item / group they interacted with? See attached. Am I doing something wrong?

Own Your Own Community!
Attachments:

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #265137 by krileon
Replied by krileon on topic Error on install of CB Activity
First issue is the styling is completely broken. Are you substituting in the tab into a module? If that's the case you need to surround it as follows and tell the CB Content Module to load CBs template CSS.

<div class="cb_template">
SUBSTITUTION
</div>

Regarding old activity entries please see #4 in the below announcement.

www.joomlapolis.com/forum/6-news-and-publicity/229590-cb-activity-30-rc1-released#263605


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: beatnantkrileon
Powered by Kunena Forum