Can't create new entities because Field 'notes' doesn't have a default value

alcoma

Hello,
I am having issues creating new entities both through the main menu and quick add in records.
I can't save anything because of this error:

Name (ca_entities.preferred_labels) (Field 'notes' doesn't have a default value)

But there is no field named 'notes' in the display. ??

monica

alcoma Preferred Labels can have a notes field enabled. Have you upgraded lately, if so what versions?

jeffschneider

Did you have something set up in the data dictionary at some point?

alcoma

jeffschneider No, haven't used data dictionary.

alcoma

monica Yes, upgraded from 2.0.4 to 2.0.9

monica

alcoma Did you run the data migration?

monica

alcoma The notes field wasn't added until version 2.0.10. Are you sure that you only upgraded to 2.0.9? You didn't go to 2.0.10 then try and downgrade?

alcoma

monica is that same as updating database schema ? If so, yes.

alcoma

alcoma Oh, yes. Initially I did try to downgrade, but then ended up reverting to a backup of what we were on previously, then updated again from there (2.0.4 to 2.0.9).

monica

alcoma Make sure you have completely cleared all caches (Including redis/memcache if using). If you truly did revert to a 2.0.4 backup, then you shouldn't have this happening. @seth Can you think of any other reason for this?

alcoma

monica when I run cat app/version.php it shows:

CollectiveAccess major version number; don't change
define('CollectiveAccess', '2.0');

CollectiveAccess minor version number; don't change
define('CollectiveAccess_Version', '2.0.9');

Schema revision
define('CollectiveAccess_Schema_Rev', 204);

Release type
define('CollectiveAccess_Release_Type', 'GIT');

alcoma

*Update: This issue resolved after I upgraded again, from v2.0.9 to 2.0.11.