Fatal error activating on multisite install

@joefollette, Hi.

Thx for the bug report. You are the 1st, that tells me about multisite ))

Yes, I never tested it under multisite. Honestly, I never use this WP feature even when I have on one server 3 WP sites.

Can you provide more details about those fatal? Some error messages or else.

Regarding your case — pls confirm how to repeat the bug:

* under multisite WP activate plugin on 1st site
* try to activate it on 2nd site
* system will respond by fatal

Am I right?

Yes. Here is the error message I got.
Plugin could not be activated because it triggered a fatal error.
Fatal error: Uncaught Migrate.php(259) : AddQuestionsTable – Error executing ‘query’ with: ALTER TABLE wp_10_t_questions ADD CONSTRAINT fk_question_test FOREIGN KEY (test_id) REFERENCES wp_10_posts (ID) ON DELETE CASCADE ON UPDATE CASCADE, ADD INDEX fk_question_test (test_id); Reason: Can’t write; duplicate key in table ‘#sql-6185_8bb28’ thrown in /nas/wp/www/cluster-40898/ltcn/wp-content/plugins/wp-testing/vendor/ruckusing/ruckusing-migrations/lib/Task/Db/Migrate.php on line 259

Hmm.. I think I know the reason. In the next release(-s) I will research it and will publish hotfix ASAP.

Btw, will it be ok for you to delete plugin from existing multisite and then reinstall it when hotfix will be ready?

ps: Currently there are no any import/export/backup ability. So all plugin’s data will be lost.

But I have done so much already. You mean all is lost?

@joefollette, I already confirmed the reason.

I’m not sure if all will work 100%, but in about 98,99% — I need to test it somehow, which is my main pain now.

Regarding data. As I see on the migration phase, possibly there will be no need to deinstall/reinstall.

Or if you will meet problems during activating after hotfix on 2nd site — I can provide some paid support to fix it on your side. As of you are 1st who report such bug and you are caught in the middle of migration phase.

When do you plan to have this fixed?

@joefollette I think on this week.

I’m struggling with another CI service to test it on multisite install.

https://circleci.com/gh/garex/wp-testing

@joefollette If this is really critical for you — you can speed up the process.

So how can I speed up the process?

Contact me [email protected]

Fixed in 0.16.1

Nice to see you Joe!

Does this hotfix fixed your issue?

I am actually having the same issue on the latest version. Seems to activate and work on the main site but not any of the other sites.

Fatal error: Uncaught Migrate.php(259) : AddPassingsTables – Error executing ‘query’ with: CREATE TABLE wp_19_t_passings ( passing_id bigint UNSIGNED auto_increment NOT NULL, test_id bigint UNSIGNED NOT NULL, respondent_id bigint UNSIGNED, created datetime NOT NULL, modified datetime NOT NULL, PRIMARY KEY (passing_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8; Reason: Table ‘wp_19_t_passings’ already exists thrown in /var/www/apps/blog/wp-content/plugins/wp-testing/vendor/ruckusing/ruckusing-migrations/lib/Task/Db/Migrate.php on line 259

Same issue.

Fatal error: Uncaught Migrate.php(259) : AddTestScoresTable – Error executing ‘query’ with: CREATE TABLE wp_404_t_scores ( answer_id bigint UNSIGNED NOT NULL, question_id bigint UNSIGNED NOT NULL, scale_id bigint UNSIGNED NOT NULL, score_value tinyint DEFAULT 0 NOT NULL, PRIMARY KEY (answer_id,question_id,scale_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8; Reason: Table ‘wp_404_t_scores’ already exists

@ulteriori, what concrete steps you did to get this error?

My default multisite test not repeat this issue.