Residue of removed CB plugins

Hello,

I have recently updated from Joomla 3.5 to Joomla 4. Before doing the update, I had gone through the list of extensions to see what I still wanted to keep and what I wanted to ditch.

One extension I removed is JBolo from Techjoomla, a chat function that integrated also with CB (and therefore also had a CB plugin). 

Now I notice that there is still stuff of JBolo present in the MySQL database. I found out when trying to register a new test account, and I got this error:

1364Field 'jboloallowall' doesn't have a default value

(in fact, it did create the user but only in Joomla, not in CB, and no confirm email was sent out)

Indeed, the "jboloallowall" field is still listed in jos_comprofiler. This means that with uninstalling JBolo, something was left behind that shouldn't have. Nothing of JBolo appears among the plugins of Joomla itself, nor in the plugin list of CB. So it's there, but CB doesn't seem to see it and yet takes it into account. I have tried the various tools of CB, but it makes no difference (and it finds nothing of JBolo there). 

I am not well versed in MySQL databases but I saw that the line had less information in it than the other lines, so for this field I put in the same as for most other lines, and imported again to the database. So I managed to make sure it has a "default value" and is no longer interfering with new registrations.

But this aside, there's no need for JBolo to be present in the SQL database. So my question is: how do I get rid of it?
As I said, the tools of CB don't find it and so don't do anything with it, is there another solution without having to manipulate the database? (I imagine that it's easy for someone who knows all about it, but I would definitely screw it up)

I would like to point out here that while this issue occurs at CB, it seems to me that by no means CB itself is at fault. It's not one of your own CB plugins but one of Techjoomla, and clearly it is their uninstall that screwed something up. I used a few products of Techjoomla in the past, but often found them to slow down the website while not being very stable software, which is one of the reasons why I decided to discontinue using their extensions when updating to Joomla 4. But since you are familiar with how CB is structured in the database, I figured this would be the best place to ask.


Thanks!
 

Is there a field for that column in CB > Field Management? If so you should be able to just delete it there. If not try running the database checks in CB > Tools as it might be able to find it and remove it for you. If still not removed you'll need to do so within phpmyadmin by deleting that column from the _comprofiler table.

No there is no field for it, nor is there a tab. All that was gone after I uninstalled JBolo. I tried all the tools of CB but it didn't find it either.

Not sure how to delete a column in phpmyadmin.

Looks like they added it to _comprofiler table incorrectly. They should've created a CB field to store their custom information. Within phpmyadmin navigate to the table then click Structure at the top. You should see the full table structure and all its columns. Now find jboloallowall and click the Drop link to the far right in its row to get rid of that column.

Thanks, didn't know it was that simple!

I successfully did so, and noticed that it was not the only residue in there. There were also 4 fields of the supposedly already deleted CB plugin Geommunity, which I also decided to discontinue because it often didn't work properly.

I have the impression that much of Techjoomla's stuff is sloppy writing. I don't know how to code myself, but it just gives me the impression that they're trying to put together something quick without proper testing, and then charge for it. So I'm not surprised they added the table incorrectly.

Thanks again!