Title: Invalid query 1146 issue Last modified: August 21, 2016 --- # Invalid query 1146 issue * Resolved [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/) * Hello everyone! * So, where to begin?? * I am hosting through bluehost and have created a wildcard subdomain on the same directory as my primary site. * I have multisite enabled and working; I was able to create a subdomain site, got the “site created” email, and imported the contents of a blog I’d like to shut down (the dashboard looks normal–I can see the correct information in the“ Right Now” and “Recent Comments” area). However, when I attempt to view the site, check recent posts, look at media files, or anything that would take me to the site itself, I get this message: * **Invalid query: 1146: Table ‘starvip1_wor2.icl_3_rfr2b_options’ doesn’t exist** * I’ve gone into myPhpAdmin and the file appears to be there with the correct website and everything. * I tried chat with bluehost and couldn’t get any help. * Any ideas? Thanks much! Viewing 15 replies - 1 through 15 (of 28 total) 1 [2](https://wordpress.org/support/topic/invalid-query-1146-issue/page/2/?output_format=md) [→](https://wordpress.org/support/topic/invalid-query-1146-issue/page/2/?output_format=md) * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172502) * > imported the contents of a blog I’d like to shut down * How? 🙂 * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172517) * Hi Mika: * I used the “export” feature in my old blog and the “import” feature in my subdomain blog. The old one is on wordpress.com so it worked very nicely. * But my issue is I can’t get the page to load. I keep getting the error described above and would really like some help… * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172518) * That would be “Mik**a**“ 😉 * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172519) * So sorry!!!!! Mika!!!! * That’s what I get for reading too quickly. Will edit post-haste! * Might anyone be able to help with my invalid query problem? * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172520) * I did but from what I remember the errors were related to the authorname. When I checked my PhpAdmin, the table is there. * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172521) * > from what I remember the errors were related to the authorname. * Can you recall what the errors were? * Can you confirm that you had logged into the relevant sub-site when you carried out the import? * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172522) * Thanks for asking; I was both in the sub-site and fiddling in bluehost’s cpanel since I had gotten mixed up a bit regarding how to set up the wildcard/subdomain. * I’ve gone back in now to re-import and here’s what I got. The file came in and the first error message was * **Failed to import author . Their posts will be attributed to the current user.** * I selected an author to assign the existing posts to and continued. On the next page I got a list that indicated the posts and media already exists (since I had evidently done the import correctly the last time) and the final line of the “Import WordPress” page was * **Invalid query: 1146: Table ‘starvip1_wor2.icl_3_rfr2b_options’ doesn’t exist** * Is there a way to create this table? * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172523) * Not manually, no. Although it would be possible in theory, in reality, it would be _way_ too difficult. Was the site working before you ran the import? * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172524) * 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. * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172525) * > It has not worked at all on self-hosted sub-site * But did the sub-site work _before_ you tried to carry out the import? * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172526) * I didn’t try it. I’ll give it a go now to see what happens… * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172527) * 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.” * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172528) * Well – that information puts the issue in a whole new light. This has nothing to do with the import. Looks like there is a problem creating tables in the database. * Have you been able to create any sub-sites? * Thread Starter [arobinsonneal](https://wordpress.org/support/users/arobinsonneal/) * (@arobinsonneal) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172531) * None that work 🙁 In my cPanel, I have the wildcard subdomain pointing to the same document root as my primary domain. When I create a wildcard subdomain that points to its own document root I get a bluehost banner page with nothing on it. * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/#post-4172533) * What happens if you remove wildcards? Viewing 15 replies - 1 through 15 (of 28 total) 1 [2](https://wordpress.org/support/topic/invalid-query-1146-issue/page/2/?output_format=md) [→](https://wordpress.org/support/topic/invalid-query-1146-issue/page/2/?output_format=md) The topic ‘Invalid query 1146 issue’ is closed to new replies. ## Tags * [multisite](https://wordpress.org/support/topic-tag/multisite/) * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/) * 28 replies * 3 participants * Last reply from: [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * Last activity: [12 years, 9 months ago](https://wordpress.org/support/topic/invalid-query-1146-issue/page/2/#post-4172565) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics