Error when updating to latest release: Unknown column 'access' in 'field list'

I get the following error message when updating to the latest release:

Unknown column 'access' in 'field list'

Any idea how to resolve this?

CB Blogs is the only core database table with an "access" column. What version of CB were you updating from? Does installing over itself a second time resolve the issue? Aside from that it could be a Joomla issue. What version of Joomla are you using?

I am updating from 2.4.5+build.2020.05.07.21.35.06.e8f8a6125 and Joomla 3.9.19

Also tried variants: a local server with php 7.3 and 7.4, previous upgrade to Joomla 3.9.20, and multiple overwrites of CB. No difference.

Just realized that when I run the DB check, I get various schema corrections.
However, when I try to run the repair, I get an success message, although nothing has been changed.

Core CB database structure differences:
Table #__comprofiler Column id type is int instead of int(11)
Table #__comprofiler Column user_id type is int instead of int(11)
Table #__comprofiler Column hits type is int instead of int(11)
Table #__comprofiler Column message_number_sent type is int instead of int(11)
Table #__comprofiler Column avatarapproved type is tinyint instead of tinyint(4)
Table #__comprofiler Column canvasapproved type is tinyint instead of tinyint(4)
Table #__comprofiler Column canvasposition type is tinyint instead of tinyint(4)
Table #__comprofiler Column approved type is tinyint instead of tinyint(4)
Table #__comprofiler Column confirmed type is tinyint instead of tinyint(4)
Table #__comprofiler Column banned type is tinyint instead of tinyint(4)
Table #__comprofiler Column bannedby type is int instead of int(11)
Table #__comprofiler Column unbannedby type is int instead of int(11)
Table #__comprofiler Column acceptedterms type is tinyint unsigned instead of tinyint(1) unsigned
Table #__comprofiler_field_values Column fieldvalueid type is int instead of int(11)
Table #__comprofiler_field_values Column fieldid type is int instead of int(11)
Table #__comprofiler_field_values Column ordering type is int instead of int(11)
Table #__comprofiler_field_values Column sys type is tinyint instead of tinyint(4)
Table #__comprofiler_fields Column fieldid type is int instead of int(11)
Table #__comprofiler_fields Column maxlength type is int instead of int(11)
Table #__comprofiler_fields Column size type is int instead of int(11)
Table #__comprofiler_fields Column required type is tinyint instead of tinyint(4)
Table #__comprofiler_fields Column tabid type is int instead of int(11)
Table #__comprofiler_fields Column ordering type is int instead of int(11)
Table #__comprofiler_fields Column cols type is int instead of int(11)
Table #__comprofiler_fields Column rows type is int instead of int(11)
Table #__comprofiler_fields Column sys type is tinyint instead of tinyint(4)
Table #__comprofiler_fields Column pluginid type is int instead of int(11)
Table #__comprofiler_lists Column listid type is int instead of int(11)
Table #__comprofiler_lists Column viewaccesslevel type is int unsigned instead of int(10) unsigned
Table #__comprofiler_lists Column ordering type is int instead of int(11)
Table #__comprofiler_members Column referenceid type is int instead of int(11)
Table #__comprofiler_members Column memberid type is int instead of int(11)
Table #__comprofiler_plugin Column id type is int instead of int(11)
Table #__comprofiler_plugin Column viewaccesslevel type is int unsigned instead of int(10) unsigned
Table #__comprofiler_plugin Column ordering type is int instead of int(11)
Table #__comprofiler_plugin Column published type is tinyint instead of tinyint(3)
Table #__comprofiler_plugin Column iscore type is tinyint instead of tinyint(3)
Table #__comprofiler_plugin Column client_id type is tinyint instead of tinyint(3)
Table #__comprofiler_plugin Column checked_out type is int unsigned instead of int(11) unsigned
Table #__comprofiler_tabs Column tabid type is int instead of int(11)
Table #__comprofiler_tabs Column ordering type is int instead of int(11)
Table #__comprofiler_tabs Column ordering_edit type is int instead of int(11)
Table #__comprofiler_tabs Column ordering_register type is int instead of int(11)
Table #__comprofiler_tabs Column pluginid type is int instead of int(11)
Table #__comprofiler_tabs Column sys type is tinyint instead of tinyint(4)
Table #__comprofiler_tabs Column viewaccesslevel type is int unsigned instead of int(10) unsigned
Table #__comprofiler_userreports Column reportid type is int instead of int(11)
Table #__comprofiler_userreports Column reporteduser type is int instead of int(11)
Table #__comprofiler_userreports Column reportedbyuser type is int instead of int(11)
Table #__comprofiler_userreports Column reportedstatus type is tinyint instead of tinyint(4)
Table #__comprofiler_views Column viewer_id type is int instead of int(11)
Table #__comprofiler_views Column profile_id type is int instead of int(11)
Table #__comprofiler_views Column viewscount type is int instead of int(11)
Table #__comprofiler_views Column vote type is tinyint instead of tinyint(3)
Table #__comprofiler_sessions Column userid type is int unsigned instead of int(11) unsigned
Table #__comprofiler_sessions Column ui type is tinyint instead of tinyint(4)
Table #__comprofiler_sessions Column expiry_time type is int unsigned instead of int(14) unsigned
Table #__comprofiler_ratings Column id type is int instead of int(11)
Table #__comprofiler_ratings Column user_id type is int instead of int(11)
Table #__comprofiler_ratings Column item type is int instead of int(11)
Table #__comprofiler_ratings Column target type is int instead of int(11)

Did you ever restore your site from a backup? For example using Akeeba Backup? Was your site ever running CB 1.x? Seams odd your database structure is incorrect like that for so many core table columns.