New registration process could not create the blog "and table" (6 posts)

  1. leksa
    Posted 5 years ago #

    the condition is weird in our Multisite.

    The condition:
    I used the multisite 3.1.2, (live) that hold around 30000 users and blogs (oh yes, there's tons of spams -i'm in attitude to kill them all for several weeks later). And the company didn't cluster/scaling database yet. Waiting the upgrade-migration process finished (that i do right now)

    Its come from the old WPMU 2.7 before (i posted in this forum about our upgrade). Upgraded step by step from 2.7, 2.8, 2.9, 3.0, 3.1. Upgrading with native WP (all plugins shutting down).
    It was working smoothly. They use nginx for this website

    And then the problems occured:
    1. The pagination in "users list" and "blog list" -network admin (navigation at the top right of table), its not working.
    (this pagination problem, maybe have corelation with next problem)

    2. The big problems then the visitor couldnot create new blog: (but the admin can do this like there's no problem)
    - they can register username, email, then next step choose subdomain name.
    - the new registered get an email notification about activation key. The URL for wp-activation.php use subdomain.domain.com/~key. False redirect.
    - So, I did small change on ms-function, to generate the correct address. So now its works for domain.com/~key.
    - But then another stuck loading comes from that activation process. Its just stopped, without confirmation for new registered user.
    - I check the wp_signups, users list, and blog list. Its recorded. But, the blog not working. So i check the database, darn.. the tables wp_id_ was not created.

    I test it several times, with or without plugins.
    Then, for backtest, i copied all core (WP-ADMIN, WP-INCLUDES) from live website, then use for test website in similar server container. I took some database sampling.
    And i did the test (login, pagination).. its working fabolously like there's no problem at all. :(

    I did some debugging process all night, to get where is the bug, and then the die process stuck at wp-admin/includes/upgrade.php -recognized the show tables process stuck in "function dbDelta".

    So, here's the question after long detail above, maybe some expert here can explain about the limitation and confused problem here? Or maybe there's something i miss about the process?

    Thanks you verymuch

  2. leksa
    Posted 5 years ago #

    ** edit **
    And i did the test (login, pagination).. its working fabolously like there's no problem at all. :(
    --- including the maintest "Registration, key, the table creation,..
    all works..

  3. leksa
    Posted 5 years ago #

    Any one know the problem here?

  4. Undo all the hacks and changes you did to get it to work so it is back to its original state.

    Now disable ALL of your plugins. All of 'em. And try again.

  5. leksa
    Posted 5 years ago #

    I have it tested it like that.
    native without plugins..

    Still same problem..

  6. Does your db increment by a value other than 1?

Topic Closed

This topic has been closed to new replies.

About this Topic