arobinsonneal

D’Oh!!!! [in Homer Simpson style]

The issue was that I had plugins activated at the network level. I am cooking with gas now, thanks to you. Where can I post a great big giant thank you? You are fabulous!!! Thank you so much for your patience Mika–you hung in there with me!

On the plugins bit: I turned them off to set up the network, then I turned them back on. Should I turn them off again, delete the subdomain and try again?

When I scroll down farther on the DB page, there are tables that have the rfr2b in them, but they don’t have the _5_. The _options one seems to be the script that allows a reader to leave a comment or something…

I got a response from bluehost support pointing me to the MU domain mapping plugin for WP. Gotta run out for a moment but will try creating the subdomain again after turning off all plugins and installing the domain mapping plugin at the network level…

Yes…my bad: wildcard folder 😀

I followed those directions and it created the wildcard folder in the home directory.

I opened a tech support ticket and got this answer:

Hello,

I have corrected this issue for you by following the instructions listed here: https://my.bluehost.com/cgi/help/527

When I access the subdomain http://caveofscribes.starvingactivist.com I do not get a bluehost page, I get a text error: Invalid query: 1146: Table ‘starvip1_wor2.icl_5_rfr2b_options’ doesn’t exist

Right. I went to check the page myself and what do you know…the infamous Invalid query is back. I opened another ticket.

I checked my files in bluehost and there is a wildcard folder with the basic stuff in it (); I checked the subdomains page and it lists my wildcard as *.starvingactivist.com so it should be pointing to my document root.

Waiting now for the second ticket to get a response, but if you have any thoughts I’ll take ’em!

I tried deleting the wildcard from cPanel and then tried to open the sub-site; got an error message that said “Sorry–Google Chrome could not find” the site.
I went back and created the wildcard again. My primary site is http://starvingactivist.com, so the sub-site is http://caveofscribes.starvingactivist.com. When I visit http://testing.caveofscribes.starvingactivist.com, I get a page that tells me I am the site administrator, that I can get new sites up in seconds, and the list of sites I am already a member of (both the starvingactivist.com and the sub-site are listed). However, when I click the link to open the sub-site, I still get the same error of

Invalid query: 1146: Table ‘starvip1_wor2.icl_4_rfr2b_options’ doesn’t exist

In cPanel, my wildcard is “*” with a root domain of .starvingactivist.com, and home folder/document root of /public_html which is where my wp-config.php file is.

It basically did the same thing; I got a confirmation that the site was created and then when I clicked “Visit Site” the page opened to

Invalid query: 1146: Table ‘starvip1_wor2.icl_4_rfr2b_options’ doesn’t exist

Not sure what the numbers after the “.icl_” represent; note in the previous error messages, the number was “3” and now it’s “4.”

The site worked fine on wordpress.com. It has not worked at all on self-hosted sub-site, which is what sparked my original question above. As I said there, when I am on the sub-site dashboard I see what should be there but when I attempt to do anything or visit the site I get the invalid query line.

I did but from what I remember the errors were related to the authorname. When I checked my PhpAdmin, the table is there.