Invalid query 1146 issue

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.

As far as I know the user ID had full permissions. There is only one user ID.
I decided to try another tactic for the moment. I created a wildcard database and let it choose a default location (in bluehost’s cPanel it created a folder called “wildcard” in the home directory). The knowledge base over there says it can take up to 72 hours to populate the wildcard (seems weird to me that it should take that long!), so I’ll give it a go. Now when I go to the sub-site I get a banner for bluehost (see here: http://caveofscribes.starvingactivist.com/). I’ll wait a day or so and see. Someone once said that patience is a virtue and it’s one I’m working hard to earn 😉

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!

Database name is starvip1_wor2 and the table prefix is icl.

When I go into my phpMyAdmin and look for the bit that’s listed as not being there, I find starvip1_wor2, then seek out the icl_5_options table, and voila! there it is. It seems populated properly; siteurl is correct, the email address is correct, user is correct, “home” is correct, blogdescription is right. I don’t get it.

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…

I turned off the plugins, but had deleted the site. I went ahead and created a new one and it was there. Am I able to turn my plugins back on after the site is created?