Fix error when primary key is required #16290

refs https://wordpress.org/support/topic/error-in-visits-over-time/

refs https://forum.matomo.org/t/matomo-on-digitalocean-managed-database-cluster-mysql-8-sql-require-primary-key-error/37623

Putting this into Matomo 4 since it is required for Matomo for WordPress as people can't change DB settings on wordpress.com etc.

How long will it take before this is released? Matomo is basically useless as it is now.

@EmilMoe there will be a beta available likely in the next 2 weeks. The final release might be still 2 months or so away