Skip to Content Skip to Menu

Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys

  • testeuse
  • testeuse
  • OFFLINE
  • Posts: 93
  • Thanks: 2
  • Karma: 0
6 years 8 months ago - 6 years 8 months ago #303098 by testeuse
Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys was created by testeuse
Hi,

I can't upgrade / Update CB to last version, from 2.0.15 to CB 2.1.4, i tried automatically, not working.

Then i downloaded it and try to ad in myself in administration and i got this error message :

Too many keys specified; max 64 keys allowed


What does it mean please?
Last edit: 6 years 8 months ago by testeuse.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
6 years 8 months ago #303142 by krileon
Replied by krileon on topic Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys
Sounds like there's too many indexes. Review your _comprofiler tables in phpmyadmin and delete all your indexes. CB will recreate its core indexes on install.

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.

  • testeuse
  • testeuse
  • OFFLINE
  • Posts: 93
  • Thanks: 2
  • Karma: 0
6 years 8 months ago #303212 by testeuse
Replied by testeuse on topic Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys
Thank you Krileon for your answer but i am not sure to understand what to do...

What do you mean by "review" my _ comprofiler tables?

Where to find the "indexes" to delete.

Right now, i can'tget access to my administrator, tried with another account, can't change my password and CB is not anymore in component list but keep working on frontend...

Please help.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
6 years 8 months ago #303217 by nant
Replied by nant on topic Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys

testeuse wrote: Thank you Krileon for your answer but i am not sure to understand what to do...

What do you mean by "review" my _ comprofiler tables?

Where to find the "indexes" to delete.

Right now, i can'tget access to my administrator, tried with another account, can't change my password and CB is not anymore in component list but keep working on frontend...

Please help.


www.google.com/search?source=hp&ei=HNWyWsKXIsOOggeDmpCgBA&q=using+phpmyadmin+to+delete+index&oq=using+phpmyadmin+to+delete+index&gs_l=psy-ab.3..33i22i29i30k1.35153.49500.0.49695.34.32.0.0.0.0.290.4941.0j22j5.27.0..2..0...1.1.64.psy-ab..7.27.4938.0..0j35i39k1j0i131k1j0i10k1j0i22i30k1.0.rW4jJAcHuzs
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)
The following user(s) said Thank You: krileon

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

  • testeuse
  • testeuse
  • OFFLINE
  • Posts: 93
  • Thanks: 2
  • Karma: 0
6 years 6 months ago #304240 by testeuse
Replied by testeuse on topic Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys
Thank you for the link but i am not still sure of what to do...

I have find where the indexes are on php myadmin but, do i have to remove all indexes? From every comprofiler tables?

Or should i remove only some indexes from a specific table?

Please try to be precise as i really don't understand anything in these and my site just not working well because of this.

Thank you for your answer.

regards

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
6 years 6 months ago - 6 years 6 months ago #304259 by krileon
Replied by krileon on topic Can't update CB from 2.0.15 to CB 2.1.4 - Error Too many keys
Edit the _comprofiler table within phpmyadmin and just delete all of its indexes except the one with a keyname of PRIMARY. Those that are necessary will be created again when you install CB.

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.
Last edit: 6 years 6 months ago by krileon.
The following user(s) said Thank You: nant

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

Moderators: beat, nant, krileon
Powered by Kunena Forum