Missing tables

Can you manually create a table in that db via phpMyAdmin? Maybe your host has some limit…

Yes, i can create tables manually. I run my own vps so i set any restrictions and there aren’t any on that account.

As i say it all set up correctly. Just not new subsites

You run your own VPS or you host your VPS on someone else?

Are you logged in with the same ID used by WordPress? I generally log in as my admin account to cPanel, but WordPress uses a special SQL account for access. Maybe that account ‘lost’ access to create new tables? (Remember: The ability to create tables in SQL is different from writing to tables and adding rows!)

I manage my own vps.

I log in as admin to wp and this wp account quite happily creates new posts etc. So i don’t think its a mysql permissions thing.

I’d been reading about define Charset needing to be utf rather than latin etc. I’ve compared wp config on both old and new installs as well as the databases themselves and they both look to be the same – utf 8.

I’m puzzled and slightly alarmed.

I log in as admin to wp and this wp account quite happily creates new posts etc. So i don’t think its a mysql permissions thing.

NOT the same thing ??

Your WordPress ID is not the same as the ID you login to your server with, and that isn’t the same (normally) as the ID you use for SQL.

In your wp-config.php file, where it says what the SQL user ID is, THAT is the ID used to create new tables. And THAT is the ID, I think, that is somehow to do so.

So when you log into phpMyAdmin, are you doing so as the server admin or as the SQL account for your WordPress install?

I manage my own vps.

I’ll ask differently. Who is your webhost?

I manage my own VPS, but the server is owned by my WebHost and they give me access to it ?? It’s semantics and technicalities, but it matters since you may need to ask your ISP for help fixing your SQL user ID permissions if you get stumped.

(Don’t worry about UTF-8/Latin-1 – If you’re on UTF-8, you’re fine).

OK, well it seems I’ve now bottomed-out this issue.

When I have Defensio 2.5.8 network activated, new sites don’t create the required tables. If I network DEACTIVATE Defensio, I can then create a new site and everything behaves as expected. I then simply reactivate Defensio and all works well. Errrmmm……

I have noticed that in PHPMyAdmin, all of the Defensio entries (e.g. wp_2_defensio, signature, status, classification etc) are all latin_swedish_ci in the collation field. Whereas everything else in the d/b is utf8_general_ci

So I’m wondering if this is the cause. Needless to say, I’ll be getting in touch with Defensio again (2.5.9 was partly because of me!)

Yep, that would be the issue.