Cannot add 2nd new site to multisite

It doesn’t add a ‘database’ to the blogs.dir, that will remain empty until you upload images.

If you’re getting a plain white page with nothing on it when you hit submit, that’s a PHP error. Check your logs.

Hey, thanks for responding!

Check what logs where for what?

For errors. Specifically any that seem to relate to /wp-admin/network/ pages.

Ok, I found a ton of errors… here are the ones from today that only relate to the wp-admin/network

/home4/rockand8/public_html/wp-admin/network/error_log:

[26-Jan-2012 19:12:49] WordPress database error Table 'rockand8_wrd29.wp_17_options' doesn't exist for query SELECT * FROM wp_17_options WHERE option_name = 'siteurl' made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_MS_Sites_List_Table->display_rows, get_admin_url, get_site_url, get_blog_option
[26-Jan-2012 19:12:49] WordPress database error Table 'rockand8_wrd29.wp_17_options' doesn't exist for query SELECT * FROM wp_17_options WHERE option_name = 'home' made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_MS_Sites_List_Table->display_rows, get_home_url, get_blog_option
[26-Jan-2012 19:13:00] WordPress database error Table 'rockand8_wrd29.wp_17_options' doesn't exist for query SELECT option_value FROM wp_17_options WHERE option_name = 'blogname' LIMIT 1 made by wpmu_delete_blog, get_blog_details, get_blog_option, get_option
[26-Jan-2012 19:13:00] WordPress database error Table 'rockand8_wrd29.wp_17_options' doesn't exist for query SELECT option_value FROM wp_17_options WHERE option_name = 'siteurl' LIMIT 1 made by wpmu_delete_blog, get_blog_details, get_blog_option, get_option
[26-Jan-2012 19:13:00] WordPress database error Table 'rockand8_wrd29.wp_17_options' doesn't exist for query SELECT option_value FROM wp_17_options WHERE option_name = 'post_count' LIMIT 1 made by wpmu_delete_blog, get_blog_details, get_blog_option, get_option

Do you know from this what I need to do to fix?

Does the table wp_17_options exist?

no, just wp_3_options and everything else for wp_3 – that’s the first site I set up in the network.

Seems like wp_17 is for the site I’m trying to set up and stalls out on.

wp_3 is the first site?

What happened to wp_2 and then wp_4 through 16?

Does your SQL ID have the full permissions to write to the DB and create tables?

Yes, wp_3 is the first site. Everytime I try to add a new site, the numbers it assigns keep going up – whether it works or not. So, when it doesn’t work, I delete the site and try again.

I’m assuming it has full permissions since it created one new site so far. (?)

Double check the DB permissions. It’s not creating new TABLES, but it’s apparently updating extant ones. That speaks for permissions.

Hi I called Bluehost and all the permissions were there… might have been hacked? Rolling back sites now. Still have no idea, but thanks for your help!

Hack is less likely than database ‘issues’. Like anything else, data can be corrupted.

They said everything looked fine – I told them that about a week ago I started seeing some kind of encrypted text in my PHP files when I went to update them and I couldn’t. I had to use the back-up files on my desktop to change and then overwrite what was there… all of my sites now have this code starting at the top of the PHP pages…

[Code moderated as per the Forum Rules. Please use the pastebin]

I have no idea what this is or how it affected 29 sites on their server… unless it had to do with their email message we just got over the weekend:

The IP address change is temporary and related to a DDoS attack on your
server. To ensure your hosting service will continue to function normally
while we resolve the attack, we’ve added a free dedicated IP address to
your account until the attack is resolved.

I’m so lost.

Oh, and the rollback didn’t change anything.

THAT sounds like a hack.

Yes, it was… I was able to overwrite the PHP files with my backed up files on my desktop, and now everything is working as it should. Damn hackers.

I’ve also installed a nice security plugin.

Thanks so much for your help.

=)

Change your passwords while you’re at it. All of ’em. WordPress and FTP.