Fatal error activating on multisite install

Alexander, I get this message when I try to activate the plugin on a multisite site (not the network admin).

Pls just show me your steps, that you do to get error.

Currently I have a test, that successfully pass multisite.

Alexander, I wrote you by mail.

step 1) /wp-admin/network/plugin-install.php – find the plugin and press install
/wp-admin/network/update.php?action=install-plugin&plugin=wp-testing
press OK
system stays on the same address and confirms the successful installation

step 2) /wp-admin/plugins.php – press Activateunder the plugin name
/wp-admin/plugins.php?action=activate&plugin=wp-testing%2Fwp-testing.php&plugin_status=all&paged=1&s
the system shows this page
/wp-admin/plugins.php?plugin=wp-testing%2Fwp-testing.php
where a fatal error is reported:

Fatal error: Uncaught Migrate.php(259) : AddTestScoresTable – Error executing ‘query’ with: CREATE TABLE wp_236_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_236_t_scores’ already exists thrown in …/wp-content/plugins/wp-testing/vendor/ruckusing/ruckusing-migrations/lib/Task/Db/Migrate.php on line 259

@ulteriori, hi.

Finally here is what I found:

* Your case is not repeatable
* Because you are not using clean fresh WP, as wp_236 tells us that this is just added site #236 and not fresh install
* Your concrete issue as in error could be related just to timeout — you have too many sites on some not so powerful hosting, so this is possible not only on multisite
* To fix those error just delete errored table (wp_236_t_scores) and try again

Also currently this plugin is not truly multisite — it should be activated per-site and not network-wide. I will release a hotfix to warn user during network-wide activations to not do it. And then when I will have a time, just implement normal true network activation/upgrading and etc. Same as described at this article: https://shibashake.com/wordpress-theme/write-a-plugin-for-wordpress-multi-site

@ulteriori, in another issue that I received today I found that it could be a foreign key related. Not with multisite.

I will try to release a hotfix ASAP and will let you know here.

Fixed in 0.18. Not multisite-related, but now plugin becomes really multisite-compatible.

Thank you Alexander, looks like it works now. I will test it in more details and let you know the results.

Jst to prove that it’s same issue that I think, please run this queary an check if “Engine” column differs under wordpress tables:

SHOW TABLE STATUS

This plugin made a post called “Eysenck’s Personality Inventory (EPI) (Extroversion/Introversion)” and posted it to my website. Sorry I cannot dive into it right now so I better switch off the plugin until it works as expected.