redirect issue after ugrade php / sql 4 to php / sql 5 multisites only (20 posts)

  1. djsteveo
    Posted 4 years ago #

    I went the through the php / sql upgrade this weekend (v 4 to v 5), and all seems okay with my standard worpdress installs, but the multi site installs on this server have some kind of infinite redirect issue now and fail to load any pages. Anyone else have this issue?


  2. By upgrade you mean you copied the database to the new, SQL 5, install?

  3. djsteveo
    Posted 4 years ago #

    Well, I am having this same issue on two different web sites on two different servers. I upgraded the sql / php and it failed with the multisite sites - the one with the first fail:
    I took the backup I had made (while the database was on php / sql 4 version) - and then imported the sql file and imported it to a new database with the phpmyadmin 5 and that did not work, changed the credentials in wp-congif and it still did the infinite redirect fail - then I took the php 4 version and imported straight into the database that had been converted to php/ sql 5 overwriting the main one, and it still has the redirect fail.

    It fails / redirect loops on the home page, as well as mysite.com/wp-admin/ - strange thing is that going to wp-admin/upgrade.php brings up a page, but clicking upgrade basically refreshes the screen and it dies.

  4. You can't upgrade SQL 4 to 5, which was the point of my question (that's an annoying SQL thing).

    On your new PHP 5/SQL 5 box, can you make a NEW install of WP and turn on MultiSite? Let's try and see if you have a bad install of the 5s or something else :)

    Also, what ELSE is different? Are these new servers or old ones?

  5. djsteveo
    Posted 4 years ago #

    Yes, I made a new wp 3.2 multisite and it seems to work fine.

    Same server, nothing else has changed, just the upgrade to sql 5.

    I paid extra to get supreme support from my host and asked them to double check everything, including all the php / sql modules being upgraded and installed properly. We went through the process of importing the sql 4 database into a new blank database (which is not running v5) - and still have the same redirecting loop issue.

    I tried check / repair of this database and still fails.

    This site was a wpmu v 1.5 (I think) that has been upgraded several times over the years.

    I tried renaming the plugins folder to make sure it was not a plugins issue (although I really think this install was not running any plugins)

    I just had the same issue occur on a different server, with a different host and the mu sites on that server did the same thing. They were able to re-import the backup dumps into php/sql5 and everything runs fines on that server, taking away this redirecting issue - but that does not seem to work properly on this one server with my other host.

    the dot com redirect loops, the dotcom/wp-admin redirect loops.. going to wp-admin/upgrade.php shows a page, click the buttin, it changes the page and says done - and does not seem to change anything - very strange.

  6. The redirect look is often caused by a miss-match between http://www.domain.com and http://domain.com

    Check in your DB and your wp-config.php to make sure it's the same all around.

  7. djsteveo
    Posted 4 years ago #

    Thank you so much for helping with this!

    I am assuming that in wp-config I look to this line for this info:
    define('DOMAIN_CURRENT_SITE', 'mysite.com' );

    But where would I look in the database for this info?
    Also, what are the best ways to look into the database? Should I use phpmyadmin or try to open it in a text editor like from open office or editplus or is there something better?

  8. go into phpmyadmin and use the search tab.

  9. djsteveo
    Posted 4 years ago #

    Did the search, and in wp-site meta it shows the same type of setup; http://mysite.com

    This is so weird. Would it be possible for someone to import my database into a fresh install on a different server and see if it's working right there, and then re-export the database from sql v5 or would that not work either?

  10. Check the PREFIX of that table in wp_site though. It's in a separate field in the table.

  11. djsteveo
    Posted 4 years ago #

    in the wp_site section, I just see three fields - "Id" is 1, "domain" is mysite.com, "path" is /

    I do not see a field for prefix in wp_site

    Could that be the problem?!

  12. Er... not prefix, sorry, Brain fart. Don't know where I got that.


    Do a search for http://www.mysite.com in the WHOLE database.

  13. djsteveo
    Posted 4 years ago #

    okay, I see two instances of the http://www.mysite in the database, on is in wp_signups and the other is in wp_users - should I edit those two blocks and take out the www? Would that be causing the redirect on home page issuse?

  14. Edit the ones in wp_users, it MIGHT be causing it.

  15. djsteveo
    Posted 4 years ago #

    okay, tried that - still not working.. I think that signup was someone trying to exploit something from a registration in 2004 - they had signed up with wwww.mysite.com (4 W's) as username and site name -

    I wonder if my database had some corrupt tables while in php / mysql V4 - and then when it got upgraded / imported to V5 is truncated some stuff that was needed or something..

  16. It's ... possible.

    How many sites aand users are on your network?

  17. djsteveo
    Posted 4 years ago #

    Looking at the phpmyadmin search results, it appears to be about 2459 users/blogs.. most of these are not active and marked as spam / archived - I am guessing there are only about 30-50 blogs / users that were active, but the sql dump uncompressed is about 160mb - I should go through and delete all those archived ones I guess!

  18. Throwing out the idea of 'Maybe you could just rebuild....' Wow. Yeah, that's a clean before you move thing, normally.

  19. djsteveo
    Posted 4 years ago #

    Yeah, I was hoping that maybe I could find someone that would be able to take in this sql4 database onto their box and get it to work or hash out the problem, but it seems it may just be easier to go through and rebuild from scratch - I just rebuilt one of the two sites, manually copying posts from the phpmyadmin and pasting into pages on the rebuilt small site - not it appears that I will have to do it the same way with this one - sighs, loves wordpress updates, really trying to anyway - lol

    Thanks so much for the help here btw - just having some reply makes a huge difference in stress levels!

  20. Sometimes a rebuild is the only way :/

    My site was WP 1.5 -> 2.9, then I switched to WPMU, then WP 3.0-beta MultiSite. Then BACK to 3.1 Single Site and BACK AGAIN to 3.2 multisite. And then something broke. ;) Sometimes all this crap we add on kills us.

Topic Closed

This topic has been closed to new replies.

About this Topic