WordPress.org

Forums

[resolved] when multi-site enabled, stie says database is broken (29 posts)

  1. cb-rcw
    Member
    Posted 4 years ago #

    I am working on enabling a multi-site. When I upload the new wp-config and .htaccess files, I go to log back in and it says that there is a broken database. I told it to go ahead and repair it, though nothing should have been wrong because it said the database was just fine moments before while it was a single site - and the following was the results:

    wp_1_posts: Table 'db352522720.wp_1_posts' doesn't exist
    wp_1_comments: Table 'db352522720.wp_1_comments' doesn't exist
    wp_1_links: Table 'db352522720.wp_1_links' doesn't exist
    wp_1_options: Table 'db352522720.wp_1_options' doesn't exist
    wp_1_postmeta: Table 'db352522720.wp_1_postmeta' doesn't exist
    wp_1_terms: Table 'db352522720.wp_1_terms' doesn't exist
    wp_1_term_taxonomy: Table 'db352522720.wp_1_term_taxonomy' doesn't exist
    wp_1_term_relationships: Table 'db352522720.wp_1_term_relationships' doesn't exist
    wp_1_commentmeta: Table 'db352522720.wp_1_commentmeta' doesn't exist

    Any ideas? I keep hitting weird walls while trying to enable the multi-site on my domain.

    Please help! Andrea_r has been helping me on another forum, but I thought this was a different issue, so should have it's own thread.

    I look forward to hearing your thoughts and ideas!

  2. Something is tripping a flag that tells it it's an upgraded mu install. in multisite from a single WP, there's NO wp_1_ tables needed.

    I've yet to figure out what's going on tho.

  3. just for giggles, what instructions are you following?

  4. cb-rcw
    Member
    Posted 4 years ago #

  5. I just did this on a test domain.
    I downloaded a fresh copy of WP 3.0.5.
    I used an empty database.
    I followed all the steps, in this case I did a subfolder install as I was in a subfolder.

    I did not get this error.

    everything works as expected, including the additional test site.

    What process in your steps is different than the one I just typed? And where are you hosted?

  6. followup:

    WHERE in wp-config.php did you put the lines that you get in the Network menu? at the bottom? IF so, that's your problem.

    (and I did address this in the ebook)

  7. Found it.

    Note when you paste in the lines in wp-config, there are TWO that mention multisite.

    define('WP_ALLOW_MULTISITE', true);
    define( 'MULTISITE', true );

    BOTH need to be there.

  8. cb-rcw
    Member
    Posted 4 years ago #

    Here is where I added in the wp-config:

    /**
     * WordPress Localized Language, defaults to English.
     *
     * Change this to localize WordPress.  A corresponding MO file for the chosen
     * language must be installed to wp-content/languages. For example, install
     * de.mo to wp-content/languages and set WPLANG to 'de' to enable German
     * language support.
     */
    define ('WPLANG', '');
    
    /**
     * For developers: WordPress debugging mode.
     *
     * Change this to true to enable the display of notices during development.
     * It is strongly recommended that plugin and theme developers use WP_DEBUG
     * in their development environments.
     */
    define('WP_DEBUG', false);
    
    define('WP_ALLOW_MULTISITE', true);
    
    define('WP_ALLOW_REPAIR', true);
    
    define( 'SUBDOMAIN_INSTALL', true );
    $base = '/';
    define( 'DOMAIN_CURRENT_SITE', 'ultimatehealthtrends.com' );
    define( 'PATH_CURRENT_SITE', '/' );
    define( 'SITE_ID_CURRENT_SITE', 1 );
    define( 'BLOG_ID_CURRENT_SITE', 1 );
    
    /* That's all, stop editing! Happy blogging. */
    
    /** Absolute path to the WordPress directory. */
    if ( !defined('ABSPATH') )
    	define('ABSPATH', dirname(__FILE__) . '/');
    
    /** Sets up WordPress vars and included files. */
    require_once(ABSPATH . 'wp-settings.php');

    As for following the directions, I tried this for installing with my tester site - and it setup alright - but when I added the new sites on there, they are broken as they try to go to site.com/subdirectory/wp-admin - which doesn't exist...

  9. cb-rcw
    Member
    Posted 4 years ago #

    Note when you paste in the lines in wp-config, there are TWO that mention multisite.

    define('WP_ALLOW_MULTISITE', true);
    define( 'MULTISITE', true );

    BOTH need to be there.

    I'm going to try this right now and let you know how it goes!

  10. cb-rcw
    Member
    Posted 4 years ago #

    Alright - I added the code. Now the site will load with its content, but I still can't login to the backend. It errors out and says the page doesn't exist.

  11. And none of your permalinks work either.

    This is related.

    you need to fix your htaccess file. If you pasted it exactly as instructed, then it is not being read. contact your webhost.

  12. cb-rcw
    Member
    Posted 4 years ago #

    Hello Andrea_r -

    I hope your weekend was nice. =)

    I looked at my .htaccess file and there was one line missing, so I added it and now it takes me to the login page no problem. However, when I attempt to login, it gives me an Error 500 - Internal server page when trying to go to the wp-admin folder.

    Do I still need to speak with the webhost to discuss the .htaccess file being read?

    Thank you for your help!

  13. Yes, you do.

  14. cb-rcw
    Member
    Posted 4 years ago #

    Alright... So, apparently, I needed to put a line in the .htaccess file to use php5. I can now get to my backend - yay! And I have the Super Admin section - yay!

    However, I have another problem - which I also had with the subdirectory test site I created. Creating the actual subsites...

    I'm doing it wrong or have to do it special maybe. Since I am with 1and1.com, I can't create the wildcard subdomain. However, I have the five subdomains I need created and pointed to the main domain. But, after I try and create the subsites in the Super Admin section, if I try and go to the backend for that section, it errors out on me with a 404 Error - saying the page/section does not exist.

    *bangs head against wall* Eventually I have to get this right...right?

    Thank you for your assistance so far. I would be very grateful if you could help me with this also. Thank you so much for all your time!

  15. However, I have the five subdomains I need created and pointed to the main domain.

    Did you point it to the /public_html/ folder?

  16. Seriously, on a different host this woudl have been done 3 days ago.

  17. cb-rcw
    Member
    Posted 4 years ago #

    Did you point it to the /public_html/ folder?

    I have them pointed folder the WordPress site is located in. This 1and1.com account hosts two different sites. The WordPress site domain is located in its own folder that the domain is pointed to. I cannot see the public_html folder in my cpanel...so, I don't know how to point to it. If I was on my personal webhost I'd be able to... *grrrr*

    Seriously, on a different host this woudl have been done 3 days ago.

    I'm glad to hear that... I think... *cries*

  18. The WordPress site domain is located in its own folder that the domain is pointed to.

    Huh. Can you share the full path? I mean, mine is /home/ipstenu/public_html and I'm wondering if the subdomain is pointed wrong.

  19. cb-rcw
    Member
    Posted 4 years ago #

    Huh. Can you share the full path? I mean, mine is /home/ipstenu/public_html and I'm wondering if the subdomain is pointed wrong.

    When I am in my root directory in my ftp account, it is 1and1 - u54457569/uht - that is where it is located. I can't go further up than the 1and1 - u54457569 folder. I think maybe this is just the setup of 1and1? Because, I checked with the CPanel, and it looks like I am as "high up" in the directories as I can go...

  20. 1and1 does NOT permit wildcard subdomains on home hosting package.

    MANUAL subdomains I have this note:

    steps.
    1) go to admin.1and1.com => add subdomain.
    Note : keep in mind to change destination to specifc folder.

    2) go to wp-admin and add a subdomain in config.
    Note : i recieved 500 Internal server error on adding subdomain but still the configuration is done.

    3) you might have to wait for 12hrs or more for subdomain setup to start working from 1&1 side.

    Hope this info helps someone.

    See http://wordpress.org/support/topic/multisite-subdomains-without-wildcards-on-godaddy-possible?replies=17#post-1601337

  21. cb-rcw
    Member
    Posted 4 years ago #

    Okay, if you don't mind... I'm going to attempt to explain those three steps in my own words to make sure I am understanding them correctly...

    1) go to admin.1and1.com => add subdomain.
    Note : keep in mind to change destination to specifc folder.

    Add the subdomain in the 1and1.com CPanel (I've done this)
    Point the subdomains to a specific folder made for that subdomain (I can do this)

    2) go to wp-admin and add a subdomain in config.
    Note : i recieved 500 Internal server error on adding subdomain but still the configuration is done.

    In the Super Admin menu, add the subdomains (I can do this)
    I do not understand its reference to "config"

    3) you might have to wait for 12hrs or more for subdomain setup to start working from 1&1 side.

    I don't think this will be a problem for me just because I've had the subdomains created for a while now.

  22. Point the subdomains to a specific folder made for that subdomain (I can do this)

    AHA! DO NOT do this!

    You need to point it to one folder UP from that specific folder for the subdomain!

    Example: If cpanel points it to /23198126312/usr/www/subdomain then you want it to point at /23198126312/usr/www/

    The problem here is I have NO idea of the folder structure for 1&1, but I DO know you need that folder to point to the folder where your wp-config.php is, or it won't ever work.

  23. cb-rcw
    Member
    Posted 4 years ago #

    Alright... Let me see if I can explain this well enough that you know what I mean! =)

    When in my CPanel - to tell the subdomain where to point to - the top, highest directory folder available is ( /./ ) and after that, my site's folder is ( /./uht/ ). WordPress is installed in the uht folder. I have the subdomains pointing to the /./ folder. There are no higher up folders I can point to.

    If I need to point the subdomain to the folder that houses my wp-config file, then I would need to point the subdomain to the uht folder.

    As it is currently set up (pointing to the /./ folder), it lets me create the site in the Super Admin, but if I attempt to go to the backend of the site, it gives me a 404 Error - saying it doesn't exist when it attempts to go to this address:
    http://body.ultimatehealthtrends.com/wp-admin/

    So, I guess I will try pointing the subdomain to the uht folder and seeing if that makes a difference - since hypothetically it would have a wp-admin folder to go to.

    If in reading this you know what I need to do, please let me know - otherwise I'll try pointing it to the uht folder and let you know how that works out. =)

    Thank you very much for your time and help. I really wish this was being more cooperative!

    *kindest regards*

  24. cb-rcw
    Member
    Posted 4 years ago #

    Oooooooh! I think this may have worked!!

    You guys have been so great!

    Many thanks for all your help. Hopefully this will help someone else someday...

  25. If I need to point the subdomain to the folder that houses my wp-config file, then I would need to point the subdomain to the uht folder.

    yes, that;s what we've been trying to tell you. ;) point the subdomain folder to where WORDPRESS is installed. And that is where wp-config.php is.

  26. cb-rcw
    Member
    Posted 4 years ago #

    Well, I'm pretty sure I have it working now... =) Thanks again to the both of you!!

  27. monsley
    Member
    Posted 4 years ago #

    cb-rcw, Ipstenu, Andrea_r -- it has helped someone else already. :) I'm on 1and1 too, can't afford to switch companies atm, and reading through all your posts has helped me set up Multisite with subdomains without a hitch.

    Following all the info posted by you throughout the forums, having a subdomain multisite with 1and1 is perfectly doable, at least when on a fresh install and setting everything up for the first time.

    Thank you very much to all of you, Andrea_r & Ipstenu for your time & knowledge (your ebook is great, Andrea!) and cb-rcw for pushing through despite the odds! :) Have a lovely weekend, all.

  28. I wish I could favorite posts. :) Yours are why we *keep* doing it.

  29. cb-rcw
    Member
    Posted 3 years ago #

    monsley~

    glad you found it helpful! lol - I felt like I was banging my head into an invisible wall... =)

    Have a great day!

Topic Closed

This topic has been closed to new replies.

About this Topic