Database problems

You can run the DB update script for v2.11.0 again to fix this problem:

CREATE TABLE IF NOT EXISTS pool_wp_predictions_audit_log (
  log_date DATETIME NOT NULL ,
  user_id INT UNSIGNED NOT NULL ,
  type TINYINT UNSIGNED NOT NULL ,
  source_id INT UNSIGNED NOT NULL ,
  result_code TINYINT UNSIGNED NOT NULL ,
  log_value VARCHAR(200) NOT NULL ,
  INDEX ix_log_date (log_date),
  INDEX ix_user_id (user_id),
  INDEX ix_source_id (source_id)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE pool_wp_teams ADD is_favorite TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER is_active;

Seems like your upgrade path was a bit ‘longer’ and you’re not only missing the version 2.11 database upgrades. Because the question_order column was introduced in version 2.9.0.

I suggest you also run the following scripts:

v2.9.0
v2.9.3
v2.10.0 ^*)

And perhaps even the v2.8.0 one^**):

v2.8.0

^*) After running all database scripts, you’ll have to start a calculation to create a ranking.

^**) Please note that some of the statements may result in a warning because it tries to remove an index that does not exist or to add one that already exists. You can ignore those warnings. They are in those cases an indication that this particular update was already succesfull

No, this is highly unusual. But probably you’ve tried the plugin before in the past (some years ago) that left the tables behind in the database. Because the plugin will not install with only one column missing. That is impossible.

It is a lot easier (and safer) to just deactivate the plugin (make sure you first uncheck the option on the plugin options page that says to “keep data on uninstall”). That will remove all custom tables for my plugin from your database. And then activate the plugin again to start with a 100% clean install.