CB tool/db issue after upgrade to Joomla 3.6.2

7 years 8 months ago #284816 by cliffvt
Guys

Using CB 2.0.14 - after updating to Joomla 3.6.2 from 3.5.x whern using CB tools all checks are ok except for user database - I get the following errors:

CB fields data storage database structure differences:
Table #__comprofiler Column twitter_previous_userid type is varchar(50) instead of text
Table #__comprofiler Column fb_previous_userid type is varchar(50) instead of text
Table #__comprofiler Column tumblr_userid type is varchar(50) instead of varchar(255)
The CB fields data storage database structure differences can be fixed (adjusted) by clicking here: Click here to fix (adjust) all CB fields data storage database differences listed above

When I do a DRY RUN - it all works fine (apparently) but when I do the actual fic, i get this error:

An error has occurred.

1170 BLOB/TEXT column 'twitter_previous_userid' used in key specification without a key length SQL=ALTER TABLE `#__comprofiler` CHANGE `twitter_previous_userid` `twitter_previous_userid` text

Any ideas how to fix please?

Please Log in to join the conversation.

7 years 8 months ago #284818 by cliffvt
I managed to FIX this by simply going into CB fields edit and pressing edit for each of those 3 fields and then saving them again - when I ran tools again, all eroors were fixed.

Cheers

Please Log in to join the conversation.

7 years 8 months ago #284831 by krileon
text columns can't have an index without a size set. This is a known issue in CB when a fields type is being fixed and it has an index. Since those fields are no longer linked to CB Connect (either unused or CB Connect is uninstalled) you can just delete them.


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 to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.212 seconds

Facebook Twitter LinkedIn