Support » Networking WordPress » Upgrade 3.0 issues w/ tables missing & wp_ vs wp_1

  • Resolved anndonnelly

    (@anndonnelly)


    I think I have resolved this, but want to check if there’s anything else I need to check to be sure — and thought this post may help others.

    I upgraded a WordPress MU site to 3.0 using the quick install in the Control Panel and following steps in http://developersmind.com/2010/06/17/upgrading-wordpress-mu-2-9-2-to-wordpress-3-0/ (thanks to andrea_r for posting this on another thread).

    I also adding to wp-config.php (not sure if needed):
    define( β€˜MULTISITE’, true );

    I got database errors and WP couldn’t repair and I did a few things I stupidly cannot remember and finally got an error showing that there were tables missing. There were a few “wp_” tables missing. To fix I:
    – dropped all the tables in the existing database
    – did the installation again
    – imported my backed up database

    Database fixed, but there was no data in my main site, but there was in the second site. I thought I had read something that with 3.0 it was using wp_ instead of wp_1 so I:
    – renamed some of the wp_ tables to wp_3 (as I was afraid to just drop them in case I needed to go back) — some of the wp_ files did not have equivalent wp_1 and wp_2 files so I left as wp_ thinking they were needed to run the overall application.
    – then renamed the wp_1 tables to wp_

    It worked, but now I am just afraid there may be some other things I ma need to fix. Anyone think of anything else I should check?

    Should I drop the tables I now have as wp_3 to keep the db tidy and in case I do add a 3rd site here.

Viewing 9 replies - 16 through 24 (of 24 total)
  • πŸ˜€

    Hopefully the rest of them will go smooth. remember to follow the steps in the link above and not mess aroudn in the db. πŸ˜‰

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    πŸ³οΈβ€πŸŒˆ Plugin Review Team Rep

    Yeah, that sounds very familiar, anndonnelly πŸ™‚

    Andrea wisely stays the hell out of DB renaming. I ended up doing it because when I upgraded from 2.9.2 to 3.0 beta, it was PRE the built in conversion therapy code πŸ˜‰ Which was really stupid of me, and I never suggest it to anyone! Now that 3.0 has a built in way to convert, you should never have to play in the DB again πŸ™‚

    Ha! I go play in the database and rename things willy-nilly when I feel like living on the edge. πŸ˜€

    Ahhhh – I’m back! Trying this on a second MU site — followed Andrea’s post http://wpmututorials.com/how-to/upgrading-from-wpmu-to-wp-3-0/ and got error that database needed repair again and it couldn’t be fixed. Looked at database and again got issues with names of the tables. Some were still wp_1_… and others were just wp_…

    Renamed tables that were wp_1_… to wp_… and could then access admin, etc. but permalinks and images are not working.
    – I’d like to get the permalinks back because those urls are indexed in Google and they are doing well.
    – image url that was http://progressivesolar.ie/files/2010/05/013.jpg no brings a dead page. Thumbnails are working, but the images in the posts are not.

    Again I’m thinking oh, I’ll go and change everything manually, but hoping there may be one place I’ve gone wrong and it’s an easier fix — and I can’t figure out what the right URL should be anyway πŸ™‚

    Just prior to upgrading I had changed the url of the site in the settings to be http://progressivesolar.ie instead of with the www so that the subdomains would work properly when I do them – could this have brought the image problems. Think the problem was only after upgrade, but not 100% certain.

    Sorry I’m messing things up again!!!

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    πŸ³οΈβ€πŸŒˆ Plugin Review Team Rep

    Some of them are supposed to be named WP_, though and others WP_1 … You should never have to change ’em manually was the point. Ah well, it’s working.

    Changing the URLs, you need to do a massive search/replace in the database any time you do that for WP Multisite. I need to write a post about how to do that, since it’s a hassle in Multisite *sigh*

    http://www.progressivesolar.ie/files/2010/05/013.jpg and http://progressivesolar.ie/files/2010/05/013.jpg fail…

    Check on your server. What’s the real path? Something like http://progressivesolar.ie/wp-conent/blogs.dir/1/files right?

    Looked at database and again got issues with names of the tables. Some were still wp_1_… and others were just wp_…

    Renamed tables that were wp_1_… to wp_… and could then access admin, etc. but permalinks and images are not working.

    I’m wondering what you keep running into that you “have to” rename tables?

    Upgraded mu installs will have wp_1_ tables on that main blog only. There will still be global tables that do not need to have a number in them. Ever.

    The main blog on a single WP install that has the network feature enabled should not have any numbered tables for the main blog.

    Also, try not to change too many thing at once. πŸ˜‰ (re: www )

    And if your permalinks are gone, then it’s your .htaccess file. that may fix your image rewrites too.

    Oh, what a dodo I am! Like Andrea was saying, try not to change too many things at once! I had some of my own redirects in the .htaccess from when the site was redone from static to WordPress. I thought best to delete out to avoid any possible conflict — and I deleted some necessary bits. Fixed and it’s sorted the images and permalinks.

    Sorry to have bothered you with my stupidity!!! At least I know NOT to add the define for MULTISITE next time — I do have one more MU to upgrade, so hopefully I’ve learned enough from my mistakes on these first two upgrades!!!!

    Thanks a million!

    Saved my day πŸ™‚

    i have had same issue.
    i have not renamed table names.
    try to uncomment define( ‘MULTISITE’, true );
    try to run /wp-admin/ms-upgrade-network.php ,
    try to set english interface .

Viewing 9 replies - 16 through 24 (of 24 total)
  • The topic ‘Upgrade 3.0 issues w/ tables missing & wp_ vs wp_1’ is closed to new replies.