Error calculating ranking | WordPress.org

[ad_1]

Looks like the last update did not update your database. If you run the following script via a tool like phpMyAdmin, then this error should be resolved.

ALTER TABLE pool_mukp_predictions CHANGE home_score home_score TINYINT UNSIGNED NULL, CHANGE away_score away_score TINYINT UNSIGNED NULL;

DROP TABLE pool_mukp_scorehistory_s1_t1; 

DROP TABLE pool_mukp_scorehistory_s1_t2; 

CREATE TABLE IF NOT EXISTS pool_mukp_scorehistory_s1_t1 ( ranking_id INT UNSIGNED NOT NULL, score_order INT UNSIGNED NOT NULL DEFAULT '0', type TINYINT UNSIGNED NOT NULL DEFAULT '0', score_date DATETIME NOT NULL, source_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, score INT UNSIGNED NOT NULL, full SMALLINT UNSIGNED NOT NULL DEFAULT '0', toto SMALLINT UNSIGNED NOT NULL DEFAULT '0', goal_bonus SMALLINT UNSIGNED NOT NULL DEFAULT '0', goal_diff_bonus SMALLINT UNSIGNED NOT NULL DEFAULT '0', joker_used SMALLINT UNSIGNED NOT NULL DEFAULT '0', total_score INT UNSIGNED NOT NULL DEFAULT '0', ranking INT UNSIGNED NOT NULL, PRIMARY KEY (ranking_id,type,source_id,user_id), KEY ix_ranking_score_order_user (ranking_id,score_order,user_id) USING BTREE, KEY ix_user_id (user_id) USING BTREE, KEY ix_ranking_id (ranking_id) USING BTREE, KEY ix_ranking (ranking) USING BTREE, KEY ix_score_order (score_order) USING BTREE, KEY ix_joker_used (joker_used) ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 

CREATE TABLE IF NOT EXISTS pool_mukp_scorehistory_s1_t2 ( ranking_id INT UNSIGNED NOT NULL, score_order INT UNSIGNED NOT NULL DEFAULT '0', type TINYINT UNSIGNED NOT NULL DEFAULT '0', score_date DATETIME NOT NULL, source_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, score INT UNSIGNED NOT NULL, full SMALLINT UNSIGNED NOT NULL DEFAULT '0', toto SMALLINT UNSIGNED NOT NULL DEFAULT '0', goal_bonus SMALLINT UNSIGNED NOT NULL DEFAULT '0', goal_diff_bonus SMALLINT UNSIGNED NOT NULL DEFAULT '0', joker_used SMALLINT UNSIGNED NOT NULL DEFAULT '0', total_score INT UNSIGNED NOT NULL DEFAULT '0', ranking INT UNSIGNED NOT NULL, PRIMARY KEY (ranking_id,type,source_id,user_id), KEY ix_ranking_score_order_user (ranking_id,score_order,user_id) USING BTREE, KEY ix_user_id (user_id) USING BTREE, KEY ix_ranking_id (ranking_id) USING BTREE, KEY ix_ranking (ranking) USING BTREE, KEY ix_score_order (score_order) USING BTREE, KEY ix_joker_used (joker_used) ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  • This reply was modified 16 minutes ago by AntoineH. Reason: too many backticks messed up the layout

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer