Tables are not created when adding a new site

I’ve installed a clean multisite, without any plugins or whatsoever, but when i add a new site the database tables are not created.

I’ve found some other people with these issues, but they all had them three years ago and i can’t find any recent topics about this issue.

Like i said, i installed a clean WordPress and that all worked fine (the initial tables were created in the setup proces). During the Multisite setup proces the additional tables were added as well, but when i tried to setup a new Site, the appropriate _2 tables where missing from my database.

When i go to my newly added site (say https://test.domain.com), i get the following error:

Error establishing a database connection

When i add /wp-admin (so https://test.domain.com/wp-admin) it says:

One or more database tables are unavailable. The database may need to be repaired.

When i then repair and optimise the database, i get the message that all the default tables are ok, but ends with the following:

main_4_posts: Table ‘sites.main_4_posts’ doesn’t exist
main_4_comments: Table ‘sites.main_4_comments’ doesn’t exist
main_4_links: Table ‘sites.main_4_links’ doesn’t exist
main_4_options: Table ‘sites.main_4_options’ doesn’t exist
main_4_postmeta: Table ‘sites.main_4_postmeta’ doesn’t exist
main_4_terms: Table ‘sites.main_4_terms’ doesn’t exist
main_4_term_taxonomy: Table ‘sites.main_4_term_taxonomy’ doesn’t exist
main_4_term_relationships: Table ‘sites.main_4_term_relationships’ doesn’t exist
main_4_commentmeta: Table ‘sites.main_4_commentmeta’ doesn’t exist

Everything seems to work when i manually add those tables, but i don’t feel like doing that manually each time i add a new site.

I hope anybody can help me out because it’s driving me crazy at the moment