Set strict db types

Table #__comprofiler Column cb_thing type is tinyint(4) instead of text

The CB fields data storage database structure differences can be fixed (adjusted) by clicking here: Click here to Fix (adjust) all CB fields data storage database differences listed above (you can also Click here to preview fixing (adjusting) queries in a dry-run), but in all cases you need to backup database first as this adjustment is changing the database structure to match the needed structure for the installed version.

The fieldtype is a querytype (queryradio) and I wish to store this as an ID to that other table but if I manually adjust the db to make it an int type I get this warning. As I have queries that reference the table by id it seems best to store this as an int rather than text. I do not know where to change this requirement as some fields are labeled

exists but is not of strict type, so not checked.

I thought I could change something in the comprofiler_fields table but I don't see anything.

Query fields can't know what type of data is being used in advance so its type is always text to support any kind of value usage. You can change this in database, but yes tools is going to throw that notice. Just don't click the fix link and you're fine.