1054 - Unknown column 't.useraccessgroupid'

hello,

No way to migrate to cb1.9.1 CB2.0.4.

Finally, I have this message:

1054 - Unknown column 't.useraccessgroupid' in 'where clause' SQL=SELECT * FROM talia_comprofiler_tabs t WHERE t.enabled=1 AND t.useraccessgroupid IN (-2,-1,1,2,3,4,5,9,12,11,10,6,7,13, ORDER BY t.position, t.ordering

On all pages of the site!
blog.montki.be/

The problem occurred when I was doing the checks in "tool"
And then everything is ok except "verification database" where I just this message:

Attention: 1 entries comprofiler_field_values refer to bad FieldType fields.
fieldvalueid FieldType = text = 45

Thanks

Finally, I have this message:

1054 - Unknown column 't.useraccessgroupid' in 'where clause' SQL=SELECT * FROM talia_comprofiler_tabs t WHERE t.enabled=1 AND t.useraccessgroupid IN (-2,-1,1,2,3,4,5,9,12,11,10,6,7,13, ORDER BY t.position, t.ordering

Where? That column is replaced with a new column as we use view access levels now instead of usergroups. Our installer handles the migration of that column then removes it. If you've a 3rd party extension still querying that table with that column then you'll get an error like that. Only way to be sure is to upgrade all your CB plugins and disable any remaining incompatible plugins.

Attention: 1 entries comprofiler_field_values refer to bad FieldType fields.
fieldvalueid FieldType = text = 45

You have a field that doesn't support field options (a text field), but there are field options for it in _comprofiler_field_values. CB won't delete these with its tools. You have to clean them up manually within the _comprofiler_field_values database table.