TLDR: access is tinyint.
I am currently examining how to upgrade our 1.7 installation to current version.
Latest difficulty was error saving Preffered labels on places, collections, etc.
It fails with error
There are errors preventing information in specific fields from being saved:
Access: '1' is not a valid choice for Access
This is actually combination of two things -
in migration 177.sql there was statement like
ALTER TABLE ca_collection_labels ADD COLUMN access tinyint unsigned not null default 0;
for many *_labels tables. Somwhere later system sets accesfield to 1.
However, in our installation , possible field values for acces are 1433,1434 and 1435.
Those values can't be even saved in tinyint.
So, i have changed the tables using
ALTER TABLE ca_collection_labels MODIFY COLUMN access smallint; //repeat for all eleven tables that had access tinyint
and then
UPDATE ca_collection_labels set access = 1433 where access = 1;
Now saving works.
