v0.16.0 - 2024-02-07
⚠️ Warning
V0.16.0 has a new database structure. To complete the update, a migration process will be necessary.Please ensure that you install the update when you have sufficient time to run the migration process.
⚠️ It is strongly advised to take a database backup before initiating the migration process.
⚠️ Some plugin functionality wouldn't work till the end of the migration process.
⚠️ All "API Import" scheduled tasks will be disabled. Do not activate them till the end of the migration process.
⚠️ It is recommended to begin the data migration process during less busy hours to minimize disruptions to website visitors. If you have a large database, it may take more than several hours.
----------------------------------------------------------
changed increased the minimal version to PHP 7.0
fixed "date_from" and "date_to" arguments in the Player Stats Panel shortcode are not working properly
improved API Import settings have been moved to a dedicated page
fixed Subteams summary page is not working properly
improved automatic user's timezone functionality (logic of kickoff time converting)
improved Calendar Slider performance
Database Optimization
The new version will reduce database size by 200-300% and improve performance for most database queries.
A special migration tool has been introduced in v0.16.0 to guide you through the migration process.
improved custom player statistics moved into "anwpfl_players" table (from "anwpfl_player_stats" table)
removed "anwpfl_player_stats" table (after migration)
improved moved prediction from "postmeta" to new "predictions" table (less db size, better performance)
improved moved all formations from "postmeta" to new "formations" table (less db size, better performance)
improved moved all transfers from "postmeta" to new "transfers" table.
Migration Process
Test Results
1st website (23K - games, 28K players, DB size - 0.9GB)
After migration: DB - 0.45GB, migration process - 4 hours
2nd website (6K - games, 10K - players, DB size - 304MB)
After migration: DB - 141MB, migration process - 12 minutes
Player Statistics Optimization
From v0.16.0, custom player statistics are saved in the "players". The creation of appropriate database columns takes place automatically during saving statistics configuration.
Result: less db size, good performance for rendering shortcodes based on custom player statistics.
API Data Import - UI Improvements
New Menu and minor changes in Dashboard UI
API Data Import - new settings page
Old settings will be automatically migrated to a new format during the update.
Customer support service by UserEcho
Здравствуйте! В web версии не показывает, а моб. версии показывает.
I get error messages at this point:
Migrate game meta to "matches" table - 146
Move game metadata from "postmeta" to "matches" table.
with the following content:
Task log 21:58:22 error Request failed with status code 400 Update Data Error - ID:21227 - Data: {"extra":0,"coach_home":"11742","coach_away":"12339","referee":"19152","match_events":"[{\" type\":\"commentary\",\"club\":\"\",\"minute\":\"\",\"minuteAdd\":\"\",\"assistants\":[ {\"id\":10466,\"position\":\"g\",\"number\":1,\"name\":\"Kai Eisele\",\"country\":\" de\",\"group\":\"subs\"},{\"id\":5142,\"position\":\"g\",\"number\":30,\"name\ ":\"Sven M\\u00fcller\",\"country\":\"de\",\"group\":\"lineup\"},{\"id\":10480,\"position\ ":\"d\",\"number\":5,\"name\":\"Jannes Vollert\",\"country\":\"de\",\"group\":\"subs \"},{\"id\":10417,\"position\":\"d\",\"number\":25,\"name\":\"S\\u00f6ren Reddemann\",\ "country\":\"de\",\"group\":\"lineup\"},{\"id\":10467,\"position\":\"d\",\"number\" :3,\"name\":\"Niklas Kastenhofer\",\"country\":\"de\",\"group\":\"subs\"},{\"id\":10469, \"position\":\"d\",\"number\":31,\"name\":\"Niklas Landgraf\",\"country\":\"de\",\"group\" :\"lineup\"},{\"id\":10715,\"position\":\"d\",\"number\":22,\"name\":\"Janek Sternberg\", \"country\":\"de\",\"group\":\"lineup\"},{\"id\":10476,\"position\":\"d\",\"number\ ":8,\"name\":\"Antonios Papadopoulos\",\"country\":\"de\",\"group\":\"lineup\"},{\"id\":5651 ,\"position\":\"m\",\"number\":26,\"name\":\"Marcel Titsch-Rivero\",\"country\":\"de,es\", \"group\":\"subs\"},{\"id\":3464,\"position\":\"m\",\"number\":33,\"name\":\" Jonas Nietfeld\",\"country\":\"de\",\"group\":\"lineup\"},{\"id\":10481,\"position\":\"m\" ,\"number\":6,\"name\":\"Toni Lindenhahn\",\"country\":\"de\",\"group\":\"lineup\"},{\" id\":5383,\"position\":\"m\",\"number\":10,\"name\":\"Michael Eberwein\",\"country\":\"de\" ,\"group\":\"lineup\"},{\"id\":13019,\"position\":\"f\",\"number\":19,\"name\":\ "Laurenz Dehl\",\"country\":\"de\",\"group\":\"subs\"},{\"id\":10482,\"position\":\"f\ ",\"number\":24,\"name\":\"Julian Guttau\",\"country\":\"de\",\"group\":\"subs\"},{\ "id\":3454,\"position\":\"f\",\"number\":7,\"name\":\"Julian Derstroff\",\"country\":\"de\ ",\"group\":\"lineup\"},{\"id\":12335,\"position\":\"f\",\"number\":11,\"name\": \"Jan Shcherbakovski\",\"country\":\"by\",\"group\":\"subs\"},{\"id\":10474,\"position\":\"f \",\"number\":13,\"name\":\"Terrence Boyd\",\"country\":\"de,us\",\"group\":\"lineup\"} ,{\"id\":20049,\"position\":\"d\",\"number\":23,\"name\":\"Stipe Vucur\",\"country\":\ "at,hr\",\"group\":\"lineup\"}],\"card\":\"y\",\"ownGoal\":\"\",\"fromPenalty\": \"\",\"scored\":\"\",\"id\":1607258027812,\"comment\":\"Verl and Halle, two in-form teams, meet today. The hosts collected 13 points from the last 6 games. \",\"sorting\":\"-1\",\"player\":0,\"assistant\":0,\"playerOut\":0},{\"type\":\" commentary\",\"club\":\"6760\",\"minute\":\"\",\"minuteAdd\":\"\",\"assistants\":[{\"id\ ":9670,\"position\":\"g\",\"number\":32,\"name\":\"Robin Br\\u00fcseke\",\"country\":\"de\ ",\"group\":\"lineup\"},{\"id\":10099,\"position\":\"g\",\"number\":22,\"name\": \"Till Brinkmann\",\"country\":\"de\",\"group\":\"subs\"},{\"id\":9678,\"position\":\"d \",\"number\":23,\"name\":\"Julian St\u00f6ckner\",\"country\":\"de\",\"group\":\"lineup\" },{\"id\":9700,\"position\":\"d\",\"number\":4,\"name\":\"Daniel Mikic\",\"country\": \"de\",\"group\":\"lineup\"},{\"id\":9676,\"position\":\"d\",\"number\":21,\" name\":\"Lars Ritzka\",\"country\":\"de\",\"group\":\"lineup\"},{\"id\":13443,\"position\" :\"d\",\"number\":20,\"name\":\"Steffen Lang\",\"country\":\"de\",\"group\":\"subs\ "},{\"id\":12892,\"position\":\"m\",\"number\":8,\"name\":\"Julian Schwermann\",\"country\" :\"de\",\"group\":\"subs\"},{\"id\":12743,\"position\":\"m\",\"number\":31,\ "name\":\"Sascha Korb\",\"country\":\"de\",\"group\":\"subs\"},{\"id\":11924,\"position\ ":\"m\",\"number\":6,\"name\":\"Barne Pernot\",\"country\":\"de\",\"group\":\"lineup \"},{\"id\":9684,\"position\":\"m\",\"number\":7,\"name\":\"Mehmet Kurt\",\"country\ ":\"de,tr\",\"group\":\"lineup\"},{\"id\":3890,\"position\":\"m\",\"number\": 11,\"name\":\"Philipp Sander\",\"country\":\"de\",\"group\":\"lineup\"},{\"id\":12587,\ "position\":\"m\",\"number\":9,\"name\":\"Kasim Rabihic\",\"country\":\"ba\",\"group\": \"lineup\"},{\"id\":9690,\"position\":\"f\",\"number\":18,\"name\":\"Ayg\\u00fcn Yildirim\ ",\"country\":\"de,tr\",\"group\":\"lineup\"},{\"id\":10829,\"position\":\"f\", \"number\":30,\"name\":\"Patrick Schikowski\",\"country\":\"de,pl\",\"group\":\"subs\"},{\ "id\":9692,\"position\":\"m\",\"number\":13,\"name\":\"Zlatko Janji\\u0107\",\"country\":\ "ba,de\",\"group\":\"lineup\"},{\"id\":18925,\"position\":\"f\",\"number\":26,\ "name\":\"Justin Eilers\",\"country\":\"de\",\"group\":\"subs\"},{\"id\":2692,\"position\ ":\"m\",\"number\":25,\"name\":\"Berkan Taz\",\"country\":\"de,tr\",\"group\":\ "subs\"},{\"id\":20367,\"position\":\"m\",\"number\":24,\"name\":\"Christopher Lannert\",\" country\Tomorrow I will publish a new version v0.16.1.
I hope it will fix your migration issue.
--
Best Regards
Andrei S.
Thanks, worked with version 0.16.1.
The only thing that hasn't been taken over are all transfers.