After upgrade from 8.9.20 to 9.5.9 can't create custom block

The site probably missed a schema update.

@cilefen how can I upgrade schema?
Thanks for your reply.

@Niubbo75 this means running updates - either from update.php, or drush updb.

@cilefen done yet, but nothing to update.

Solved, I manually add keys that were lost, now seems that all works.
I use another DB of another installation that work to compare tables and keys.
Best regards,
Alessandro

Automatically closed - issue fixed for 2 weeks with no activity.

I ran into this as well on a recent upgrade from Drupal 8 -> 9 -> 10. We ended up having to do a full database audit and found multiple issues, Before doing so we attempted the entire upgrade again so there is absolutely something missing in the upgrade path:

• batch table
  • missing primary keys
  • missing indexes
  • missing auto increment on bid
• block_content table
  • missing primary keys
  • missing indexes
  • missing auto increment on id
• block_content_* tables
  • missing primary keys
  • missing indexes
• some cache_* tables
  • missing primary keys
  • missing indexes
• users table
  • missing auto increment on uid

We solved the issue with the audit, and fixing the schema manually. I saw the referenced error about the users table, and can confirm that that update was ran but didn't fix things. I guess something to look out for when upgrading!