• Resolved joecoyle

    (@joecoyle)


    This is a brand new install of WP. Prior to following the steps to create a network I was able to log into wp-admin.

    After updating .htaccess and wp-config.php I clicked on the link to log back into wp-admin. I received the following error:

    “One or more database tables are unavailable. The database may need to be repaired.” After wp attempted to repair the database I get the following errors:

    multi_wp_1_posts: Table ‘jtcoyle_wp_multi.multi_wp_1_posts’ doesn’t exist
    multi_wp_1_comments: Table ‘jtcoyle_wp_multi.multi_wp_1_comments’ doesn’t exist
    multi_wp_1_links: Table ‘jtcoyle_wp_multi.multi_wp_1_links’ doesn’t exist
    multi_wp_1_options: Table ‘jtcoyle_wp_multi.multi_wp_1_options’ doesn’t exist
    multi_wp_1_postmeta: Table ‘jtcoyle_wp_multi.multi_wp_1_postmeta’ doesn’t exist
    multi_wp_1_terms: Table ‘jtcoyle_wp_multi.multi_wp_1_terms’ doesn’t exist
    multi_wp_1_term_taxonomy: Table ‘jtcoyle_wp_multi.multi_wp_1_term_taxonomy’ doesn’t exist
    multi_wp_1_term_relationships: Table ‘jtcoyle_wp_multi.multi_wp_1_term_relationships’ doesn’t exist
    multi_wp_1_termmeta: Table ‘jtcoyle_wp_multi.multi_wp_1_termmeta’ doesn’t exist
    multi_wp_1_commentmeta: Table ‘jtcoyle_wp_multi.multi_wp_1_commentmeta’ doesn’t exist

    Here are the tables that currently exists in the db
    
    [jtcoyle_wp_multi.multi_wp_blogmeta]
    [jtcoyle_wp_multi.multi_wp_blogs]
    [jtcoyle_wp_multi.multi_wp_commentmeta]
    [jtcoyle_wp_multi.multi_wp_comments]
    [jtcoyle_wp_multi.multi_wp_links]
    [jtcoyle_wp_multi.multi_wp_options]
    [jtcoyle_wp_multi.multi_wp_postmeta]
    [jtcoyle_wp_multi.multi_wp_posts]
    [jtcoyle_wp_multi.multi_wp_registration_log]
    [jtcoyle_wp_multi.multi_wp_signups]
    [jtcoyle_wp_multi.multi_wp_site]
    [jtcoyle_wp_multi.multi_wp_sitemeta]
    [jtcoyle_wp_multi.multi_wp_term_relationships]
    [jtcoyle_wp_multi.multi_wp_term_taxonomy]
    [jtcoyle_wp_multi.multi_wp_termmeta]
    [jtcoyle_wp_multi.multi_wp_terms]
    [jtcoyle_wp_multi.multi_wp_usermeta]
    [jtcoyle_wp_multi.multi_wp_users]
    [jtcoyle_wp_multi.multi_wp_wps_cleaner]
    [jtcoyle_wp_multi.multi_wp_wps_cleaner_queue]

    There seems to be an issue with the table names. I noticed it is looking for _1_ added to the tables names. Should these tables have been created during the Network install? Do I need to add these tables?

    Any help would be greatly appreciated

    • This topic was modified 9 months, 1 week ago by joecoyle.
    • This topic was modified 9 months, 1 week ago by joecoyle.
    • This topic was modified 9 months, 1 week ago by joecoyle.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter joecoyle

    (@joecoyle)

    This is my setup information:

    • WP 6.3.2 on Hostgator shared server
    • WP Install in root public_html
    • Permalinks set to https://domain.com/sample-post/
    • All plugins disabled
    • .htaccess file:
    • RewriteEngine On
    • RewriteRule .* – [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
    • RewriteBase /
    • RewriteRule ^index.php$ – [L] add a trailing slash to /wp-admin
    • RewriteRule ^wp-admin$ wp-admin/ [R=301,L]
    • RewriteCond %{REQUEST_FILENAME} -f [OR]
    • RewriteCond %{REQUEST_FILENAME} -d
    • RewriteRule ^ – [L]
    • RewriteRule ^(wp-(content|admin|includes).) $1 [L] RewriteRule ^(..php)$ $1 [L]
    • RewriteRule . index.php [L]
    • wp_config file:
    • define( ‘WP_ALLOW_REPAIR’, true);
    • define( ‘WP_ALLOW_MULTISITE’, true);
    • define( ‘SUBDOMAIN_INSTALL’, true );
    • define( ‘DOMAIN_CURRENT_SITE’, domain.com’ );
    • define( ‘PATH_CURRENT_SITE’, ‘/’ );
    • define( ‘SITE_ID_CURRENT_SITE’, 1 );
    • define( ‘BLOG_ID_CURRENT_SITE’, 1 );

    @joecoyle, first welcome. 2nd, this is absolutely 1 of the most stellar support request I’ve seen in years, & I’ve been doing this a very long time. Congrats to you!

    My suspicion is that the problem lies w/the multi.multi part of the database tablenames.

    I don’t know if you deliberately redacted the part of the file where your database name & connection are supposed to be, but that could also be a problem, since they’re not included.

    Additionally, I don’t know if you redacted your domain_current_site, but that’s incorrect if not. Nor are we provided with the $table_prefix name, which may (or may not) be helpful in this case.

    Since this is a fresh install, my inclination would be to remove it & start again. Generally, hosting providers have 1-click install scripts (my current favorite is Softaculous, as it seems to routinely have the most up-to-date script versions. Just answer yes to the question of whether the install is multisite, & you should be good to go. I think that’s likely the simplest, least painful approach.

    If you’d like to chase down the problems w/the current install, though, please provide us w/the information above, ie, your domain name & prefix_tablename, & we’ll see what we can do to help.

    Thread Starter joecoyle

    (@joecoyle)

    @abletec Thank you for your reply. Yes, I had redacted my host name. I also used Hostgator’s one-click install to successfully wp network install. I am not sure what I missed in the manual install but I did compare the .htaccess file and I noticed there was some entries (not related to wp) that was not included in the on-click install from Hostgator.

    Thank you again,

    Joey

    Hi again, Joey. So do I understand correctly that this problem is now resolved? If that be the case, would you please be so kind as to mark the topic as ‘resolved’ in the forum so the support volunteers know you’ve been helped & can move on to assist others? Thank you for that.

    You really did do a very nice job of providing us w/information. I hope that at some point you might be interested in helping others on this forum. You showed a very good understanding of the information needed to troubleshoot problems, & I think you’d do a great job of helping others do that as well. We need folks on this forum, as is evident from the amount of time it took you just to get a reply w/a question from me. If going out on your own scares you, my contact information is in my profile. I’d be glad to do whatever I can to make you feel better about the whole process. I know having some encouragement from a couple of the ladies here was really helpful for me when I first got started. That was pretty scary. I’m offering to pay it forward, if you feel it might help. Please at least think about it. We’re all here for you.

    Thread Starter joecoyle

    (@joecoyle)

    @abletec Yes, I will marked this as resolved. I would also be willing to provide forum support. I am currently working full-time as a Point of Sale Customer Support Specialist. I support both software and hardware issues. Please pm any information I would need to get started.

    Joey

    Well that would explain your posting, Joey. You don’t need anything to get started except a wordpress.org account, which you already have, else we wouldn’t be communicating now. Initially it’s a bit scary, but it gets easier the more you do it. Just find a post you think you can help with & jump in. I usually check the list of postings that have no replies first. But like I said, if you feel you’d like a bit of backup, I’m happy to help as I can. My husband’s recently had hip replacement surgery & I’m sole caregiver, but he’s getting along better now.

    The link for the support handbook is:

    https://make.wordpress.org/support/handbook/

    which you might wish to look at just so you can say you did if anyone asks. No, really, it’s a good resource, & I recommend it highly. It details team meeting times & all kinds of other good stuff. Attending the meetings isn’t mandatory. I seldom get to, but they’re good if you can.

    I think you’ll enjoy it, & I guarantee you’ll learn a lot about WordPress in the process. You’ll also get to meet some really cool folks. Doesn’t get much better than that.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Unable to access WP after Network Install’ is closed to new replies.