Joomla RuleZ

Ok if you have a lot of fields, you will sooner meet a limitation of mysql in the column size.

So to solve this you have to limit the existing column size on mysql.

CB use a length of 255 characters for each column for a VARCHAR type, the most of time you don't need all this space, so we will reduce each one to a specific length.

Example:

For the firstname you have 255, you can reduce it to 100
For the middlename you have 255, you can reduce it to 100
For the lastname you have 255, you can reduce it to 100

And so one for each one fields

Be careful only does this for the VARCHAR type!!!


If you know how to use mysql it's quite simple:

1 - Save your database.

2 - Edit your database with phpmyadmin.

3 - Select "jos_comprofiler".

4 - Select all the fields “Check All” and click on the "change" button.

5 - Now reduce for each "Type" = VARCHAR, the "Length/Values" according to the length expect.

6 – Save.

6 - Install again the CB player Advanced.

7 - After you install you can do the same adjustment for the fields create by our plugin.

ok i tried this and had limited success, after reducing about 20 varchar255 to 100 I was able to create new fields, which I was unable to do previously, but after trying to re-install cb media player i am still receiving this message:

it seems you have always reech the limitation of size...

you are nearly because the installation failed at `cb_plformat5` who is the last one

try again to reduce some other parameters (analyse each fields and see at what size you can reduce, for example a name you can reduce at 50 and so on)


tell me you result here thanks.

reducing from 255 to 55 did not help so I began changing all the text fields from varchar to text and this solved the problem.

I have noticed that all the mp3 player fields have been created as varchar, will it be ok to change these to text as well?

Yes It's ok.