database structure

Just wanted to know if these messages could be harm full because everything seems to be working OK.

Table #__comprofiler Column avatar type is mediumtext instead of text
Table #__comprofiler Column bannedreason type is longtext instead of mediumtext
Table #__comprofiler_fields Column tablecolumns type is mediumtext instead of text
Table #__comprofiler_fields Column description type is longtext instead of mediumtext
Table #__comprofiler_fields Column default type is longtext instead of mediumtext
Table #__comprofiler_fields Column params type is longtext instead of mediumtext
Table #__comprofiler_lists Column description type is longtext instead of mediumtext
Table #__comprofiler_lists Column params type is longtext instead of mediumtext
Table #__comprofiler_members Column reason type is longtext instead of mediumtext
Table #__comprofiler_members Column type type is longtext instead of mediumtext
Table #__comprofiler_plugin Column params type is mediumtext instead of text
Table #__comprofiler_tabs Column description type is mediumtext instead of text
Table #__comprofiler_tabs Column params type is longtext instead of mediumtext
Table #__comprofiler_userreports Column reportexplaination type is mediumtext instead of text
Table #__comprofiler_sessions Column session_data type is longtext instead of mediumtext

You've database columns with the wrong database type. There should be a fix link to correct them. The database is optimized for the types it wants to change them to so not changing them could have performance issues.

The database structure was changed to UTF8-Multibyte using the Admin Tools Joomla plugin on the basis of below suggestion from the Admin Tools app..:


Things to know before changing the database collation

Joomla! is designed to work with the UTF-8 collation. However this collation does not allow you to use Emoji and other multibyte characters such as certain Traditional Chinese glyphs, Cherokee etc. In this case you need to change the collation to “UTF-8 Multibyte”. You may need to repeat that after installing or upgrading extensions. After changing the collation you are strongly advised to use the Repair & Optimise feature.

Is this not advised by you for CB?

CB uses UTF8. That's not the issue here. You've several columns set to the wrong types. For example your avatar column is mediumtext when it now is text.