ReInstalled fresh site – Multisite DB errors

  • Resolved norrette

    (@norrette)


    4 years, 9 months ago

    Hi there,

    I am fairly new to www.remarpro.com but a long time user of wordpress.com.

    Having created a new hosted site and installed via Softalacious I am trying to create a subdomain Multi wordpress site. My hosting account has sub-domain capability.

    I have copied the code issued by wordpress into my wp-config.php and into my .htaccess but when I try to access the site or the admin site I get : Error establishing a database connection. Switching on debug i see the following tables are missing

    wp6g_1_posts: Table ‘mysite_a2wp838.wp6g_1_posts’ doesn’t exist
    wp6g_1_comments: Table ‘mysite_a2wp838.wp6g_1_comments’ doesn’t exist
    wp6g_1_links: Table ‘mysite_a2wp838.wp6g_1_links’ doesn’t exist
    wp6g_1_options: Table ‘mysite_a2wp838.wp6g_1_options’ doesn’t exist
    wp6g_1_postmeta: Table ‘mysite_a2wp838.wp6g_1_postmeta’ doesn’t exist
    wp6g_1_terms: Table ‘mysite_a2wp838.wp6g_1_terms’ doesn’t exist
    wp6g_1_term_taxonomy: Table ‘mysite_a2wp838.wp6g_1_term_taxonomy’ doesn’t exist
    wp6g_1_term_relationships: Table ‘mysite_a2wp838.wp6g_1_term_relationships’ doesn’t exist
    wp6g_1_termmeta: Table ‘mysite_a2wp838.wp6g_1_termmeta’ doesn’t exist
    wp6g_1_commentmeta: Table ‘mysite_a2wp838.wp6g_1_commentmeta’ doesn’t exist

    Now i DO have tables with these names but WITHOUT the insert ” _1_”
    eg
    wp6g_posts
    wp6g_options

    etc, etc

    I wonder which part of wordpress is calling for these names and not the same as all the others

    Any help would be much appreciated

    Norrette

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi

    I have copied the code issued by wordpress into my wp-config.php and into my .htaccess

    Please let me know, this you have copied from your dashboard or www.remarpro.com?

    Kind Regards

    Thread Starter norrette

    (@norrette)

    Thanks Prashant,

    I copied them from the pop-up on my dashboard when I clicked on Network set-up.

    The hosting company tell me I need a developer to fix it. Yet given I have spent 30 years in IT, and fairly experienced in various sytems, I can’t see anyone doing anything differently to what I have done.

    Everywhere I look online people are using the sub directory method and not the subdomain method. Maybe it is that which is not working on the latest WordPress?

    define('WP_ALLOW_MULTISITE', true ); 
define('MULTISITE', true);
define('SUBDOMAIN_INSTALL', true); 
define('DOMAIN_CURRENT_SITE', 'Your_Data');
define('PATH_CURRENT_SITE', 'Your_Data');
define('SITE_ID_CURRENT_SITE', 1); 
define('BLOG_ID_CURRENT_SITE', 1);

    Please let me know if you have the above code lines in your wp-config.php file.

    Note: ‘Your_Data’ is used just for an example. On place of that you will see a specific value in the file.

    Thread Starter norrette

    (@norrette)

    Just a quick update for anyone who has the same issue. The Hosting company recommends we install an “A2 optimised” version of wordpress. (which turns out to be 5 years old)

    This time I uninstalled and reinstalled with vanilla WordPress version 5.4.

    So far so good

    Glad to know that ??

    Thread Starter norrette

    (@norrette)

    Yes, I now have a clean perfect install of WP 5.4.2.

    This version of WP installation has a check box for MultiSites and when selected already installs the populated wp-conf and .htaccess files. The only change I needed was to change “define(‘SUBDOMAIN_INSTALL’…)” from False to true.

    Hosting company error. Thanks for your time Prashant

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘ReInstalled fresh site – Multisite DB errors’ is closed to new replies.