Latest Version of CB fails to install

Good Morning
I just downloaded and attempted to install the latest version of CB 2.9.1+build.2024.04.05 ~~~b1996(Latest)
The download succeeded, but I get a failed message when it tries to install.
I then tried installing previous 3 versions, each version failed to install.
The site is running, but there are no CB admin functions.

This is the installation details message:
System Information
Joomla: 4.4.3
PHP: 8.2.16
Database: mysql 8.0.36

Package
File: 000_pkg_communitybuilder_2.9.1+build.2024.04.05.19.00.27.f541b1996.zip
Log:
Please Help!!!!
The user admin ID (admin-test) I created for you is still active if you need to troubleshoot.

I'm not sure how but you've hit the max database index key limit. We don't have that many keys. No where near that many in fact. So I've no clue how you're hitting that limit. Within your database (e.g. use phpmyadmin) check the _comprofiler table and see how many indexes it has. If it has a lot just delete them all and re-install CB.

It may not be CB doing it though. You getting "Can't find Joomla XML setup file." is strange. Something might be wrong with one of Joomla's tables itself. Try going to System > Maintenance > Database and see if it finds any issues with Joomla's tables.

Additionally used your previously provided login credentials as requested and took a look and CB seams to be up to date just fine and accessible. Was your issue with a different site than provided?

OK
In the phpmyadmin there are 64 rows in the _comprofiler
It appears that every field we created is a key. I will have to reduce the number of fields in user profiles to reduce the keys.
The install did not complete.
The admin menu did not install. I had to go into system - Add Modules - Add Community Builder Admin Module, to make it appear.
I ran System > Maintenance > Database, it reports no errors.
I will delete a few of my fields and try running the install again to see if the error still occurs.

So, I reduced the keys in  _comprofiler  to 42, re ran the installation and it worked perfectly.

For some reason whenever I create a new field, it now creates a new key. The original fields I created back in 2022 do not occupy a key, fields I added to the user profiles in 2023 and this year each creates a new key.

Also, if you use the option "Save as Copy" to create a new field, it adds a key field, if you rename the copy it creates another key.

So I created a field called cb_user1_image1
Used save as Copy which created a field cb_user1_image12
I renamed it cb_user1_image_2
and have 3 key fields

I have deleted 18 of the keys created by this process.

David

Strange it should not be creating keys for every field like that. Will look into it to see if a check is going wrong. Recommend deleting all the keys then reinstalling CB so only the core keys remain.

Tested creating 13 different field types and none of them created indexes on _comprofiler. I'm at a loss as to what is doing that on your install. Is it still doing it after deleting all the indexes and re-installing CB?