- Issue created by @Niubbo75
- 🇺🇸United States cilefen
The site probably missed a schema update.
- 🇮🇹Italy Niubbo75
@cilefen how can I upgrade schema?
Thanks for your reply. - 🇬🇧United Kingdom catch
@Niubbo75 this means running updates - either from update.php, or drush updb.
- 🇮🇹Italy Niubbo75
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 - Status changed to Fixed
about 1 year ago 6:35pm 9 June 2023 Automatically closed - issue fixed for 2 weeks with no activity.
- Status changed to Fixed
4 months ago 11:24pm 27 February 2024 - 🇺🇸United States devkinetic
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!
- batch table