sherpabizdev

Nick, Thank you for the quick reply and recommendation. Cheers!

Let me clarify my final paragraph:

If I use standard, host-available, tools to create the initial subdomains (like http://geo1.example.com) can I then install a discreet WordPress *network* w/Buddypress at the top level that won’t get confused or angry at me?

Strange. Whatever the support person did must have resolved something. The subdomains I had previously tried still had the “error establishing database…” error.

For the heck of it, I tried establishing a new site and it worked… and the site is reachable.

Now I want to create a fresh one using a subdomain name I had already attempted before. The network admin panel did NOT show those old sites among the existing network sites. So I tried to re-create it new and I got an error that the site already existed. So I went into the wp_blogs table and deleted the old entries.

I still can’t create a new site under the subdomain I want. The error I get now is “Sorry, that site is reserved!”

Any thoughts about where else I need to clean out that name so that I can create a fresh site?

Thanks in advance.

Andrea_r, you’ve been amazing. I feel like I am getting close, but just don’t understand enough to fix this myself. Are you for hire? Should I just uninstall everything and start over?

Here is the new reply I got after communicating the issues you presented:

Hello,
It still appears to be a scripting issue.

mysql> select blog_id, site_id, domain from wp_blogs;

+———+———+———————-+
| blog_id | site_id | domain |
+———+———+———————-+
| 1 | 1 | 99andunder.com |
| 4 | 1 | sfbay.99andunder.com |
| 5 | 1 | sf2.99andunder.com |
| 6 | 1 | test.99andunder.com |
+———+———+———————-+

This is information from one table. The following I found on the link your provided for multisite. The script is not creating the necessary tables. Above I’ve shown you
“The data of the main site are stored in existing unnumbered tables. The data of additional sites are stored in new numbered tables.”

mysql> show tables;
+————————+
| Tables_in_sherpa_wdps1 |
+————————+
| wp_blog_versions |
| wp_blogs |
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_registration_log |
| wp_signups |
| wp_site |
| wp_sitemeta |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
| wp_woo_term_meta |
+————————+

I added a new database user to the database to ensure that you have all database privileges available:
ALTER CREATE CREATE ROUTINE CREATE TEMPORARY TABLES CREATE VIEW DELETEDROP EXECUTE INDEX INSERT LOCK TABLES REFERENCES SELECT TRIGGER UPDATE

I checked my db and there is a ‘wp_blogs’ table that includes entries for the primary site and the subdomains I have created. Does the fact that the table and those entries exist indicate that db permissions is not my problem?

Thanks for the reply t-p. Is your advice generic for any WordPress installation, or specific to my problem of converting to a network installation?

My primary domain works fine (http://99andunder.com) but any subdomain I create (like sfbay.99andunder.com) is unreachable.

Thanks again for your help. Any additional clarification would be great.

Andy