Fatal error on activation

  • Resolved miresru

    (@miresru)


    7 years, 6 months ago

    On activation it crashes with error:

    Fatal error: Uncaught Migrate.php(259) : WpTesting_Migration_AddQuestionsTable – Error executing ‘query’ with: DROP TABLE IF EXISTS wp_t_questions Reason: Cannot delete or update a parent row: a foreign key constraint fails thrown in /sites/html/wp-content/plugins/wp-testing/vendor/ruckusing/ruckusing-migrations/lib/Task/Db/Migrate.php on line 259

    When I try do remove plugin it says “Removing..” and nothing happened.
    I have tried to Google it by error code. It looks like this is php 7 problem.

    Perhaps it’s because of using WordPress MU Domain Mapping plugin.
    When I try to activate plugin from subdomain it says:

    Fatal error: Uncaught Migrate.php(259) : WpTesting_Migration_AddWpTables – Error executing ‘query’ with: CREATE TABLE IF NOT EXISTS wp_2_users ( ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_login varchar(60) NOT NULL DEFAULT “”, user_pass varchar(64) NOT NULL DEFAULT “”, user_nicename varchar(50) NOT NULL DEFAULT “”, user_email varchar(100) NOT NULL DEFAULT “”, user_url varchar(100) NOT NULL DEFAULT “”, user_registered datetime NOT NULL DEFAULT “0000-00-00 00:00:00”, user_activation_key varchar(60) NOT NULL DEFAULT “”, user_status int(11) NOT NULL DEFAULT “0”, display_name varchar(250) NOT NULL DEFAULT “”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARSET=utf8 Reason: Invalid default value for ‘user_registered’ thrown in /sites/html/wp-content/plugins/wp-testing/vendor/ruckusing/ruckusing-migrations/lib/Task/Db/Migrate.php on line 259

    • This topic was modified 7 years, 6 months ago by miresru.
    • This topic was modified 7 years, 6 months ago by miresru.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor ustimenko

    (@ustimenko)

    php7 is not issue.

    It should be multisite compatible.

    But if you use non-standard multisite — then this could be issue.

    What is “WordPress MU Domain Mapping”?

    Thread Starter miresru

    (@miresru)

    WordPress MU Domain Mapping is plugin allows to use several websites (subdomains) with one WP engine.

    https://ru.www.ads-software.com/plugins/wordpress-mu-domain-mapping/

    Plugin Contributor ustimenko

    (@ustimenko)

    Ok, let’s research it.

    1. Install fresh WP with multisite in standalone DB.
    2. Try to activate this plugin on one MU site.
    3. Try to activate this plugin on another MU site.
    4. Then remove those DB and install fresh WP once again.
    5. Activate those MU plugin.
    6. Try to activate this plugin on one MU site.
    7. Try to activate this plugin on another MU site.

    Report back.

    Thread Starter miresru

    (@miresru)

    The WordPress MU Domain Mapping plugin create tables for subdomain like wp_2_*.
    The Wp-testing on primary domain works fine but on subdomain on activation it can not create tables.

    With your help I have created that tables by myself. Now it forks fine.

    Thank you.

    Plugin Contributor ustimenko

    (@ustimenko)

    @miresru pls describe here what exactly you did to resolve the issue.

    Thread Starter miresru

    (@miresru)

    Ok. I will describe steps to fix. I use phpmyadmin to work with MySQL DB.

    1. Install and activate WP-Testing plugin on primary website. (It will create all necessary tables)
    2. In phpmyadmin export all tables wp_t_* to *.sql file. (I exported separatelly.)
    3. In all *.sql files replace text from wp_ to wp_X_ (X is the subdomain index, in my case it is 2)
    4. In wp_t_passings.sql file change wp_X_users back to wp_users. (Because WP use global users for all subdomains)
    5. Restore *.sql files in phpmyadmin.
    6. Go to WP-Admin for subdomain and activate WP-Testing plugin.

    Done.

    • This reply was modified 7 years, 6 months ago by miresru.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Fatal error on activation’ is closed to new replies.