Plugin Contributor
Savvas
(@savvasha)
Hi @frykky ,
Confirm that you have set the default match minutes at SportsPress->Settings->Matches https://snipboard.io/SFfbV4.jpg
And that there is no “0” value at your events Full time field: https://snipboard.io/S6cMJ3.jpg
Thanks,
Savvas
Thread Starter
Frykky
(@frykky)
if you tell me in which table plugin writes I can tell you the values that are stored on db
Plugin Contributor
Savvas
(@savvasha)
Hi there @frykky ,
Did you confirm that there is no ā0ā or empty value at your events Full time field:Ā https://snipboard.io/S6cMJ3.jpg ?
All meta data of SportsPress are stored in post_meta table.
Thanks,
Savvas
Thread Starter
Frykky
(@frykky)
Yes I confirm, look my screenshot two posts above
Thread Starter
Frykky
(@frykky)
This is the simplest example
https://cslebowski.it/event/c-s-lebowski-vs-albinia/
this is the backend https://snipboard.io/VCF1Pd.jpg. D’Alessandro is starter and was substitute at minute 55 by Macchi
in post_meta these are stored values
a:2:{i:2116;a:3:{i:0;a:5:{s:11:”appearances”;s:0:””;s:5:”goals”;s:0:””;s:7:”assists”;s:0:””;s:11:”yellowcards”;s:0:””;s:8:”redcards”;s:0:””;}
i:19466;a:9:{s:6:”number”;s:0:””;s:8:”position”;a:1:{i:0;s:2:”33″;}s:11:”appearances”;s:1:”1″;s:5:”goals”;s:0:””;s:7:”assists”;s:0:””;s:11:”yellowcards”;s:0:””;s:8:”redcards”;s:0:””;s:6:”status”;s:6:”lineup”;s:3:”sub”;s:1:”0″;}
i:20096;a:9:{s:6:”number”;s:0:””;s:8:”position”;a:1:{i:0;s:2:”33″;}s:11:”appearances”;s:1:”1″;s:5:”goals”;s:0:””;s:7:”assists”;s:0:””;s:11:”yellowcards”;s:0:””;s:8:”redcards”;s:0:””;s:6:”status”;s:3:”sub”;s:3:”sub”;s:5:”19466“;}}
i:12881;a:1:{i:0;a:5:{s:11:”appearances”;s:0:””;s:5:”goals”;s:0:””;s:7:”assists”;s:0:””;s:11:”yellowcards”;s:0:””;s:8:”redcards”;s:0:””;}}}
where 2116 is C.S. Lebowski ID, 12881 is Albinia ID, 19446 is D’Alessandro and 20096 is Macchi
In Macchi details at “Coppa Italia” there is 1 presence 0 minutes https://cslebowski.it/player/macchi-francesco/
hi there!
Thanks for your reply.
Did you check the event edit screen itself? Savvas was referring to the event in addition to the general SportsPress settings.
Thanks!
Thread Starter
Frykky
(@frykky)
You’re right, it’s zero!
https://snipboard.io/Mrt0XA.jpg
Why?
How can i fix it?
Plugin Contributor
Savvas
(@savvasha)
Hi @frykky ,
How did you create your events? In my testing environment with SportsPress 2.7.16, when I create a new event the full-time field is pre-populate with the default value 90
Thanks,
Savvas
Thread Starter
Frykky
(@frykky)
We have 5142 events on wordpress.
In postmeta table there are 1020 records with meta_key “sp_minutes” (why?)
Of these 731 have null value, 288 have “0” value.
I can cdo an update query to clean up these 0 values.
We insert record with a csv files, could that be the problem?
We’ve been doing it for many years and it’s never happened to us before š
Thread Starter
Frykky
(@frykky)
Maybe i can give you an example of our csv?
Plugin Contributor
Savvas
(@savvasha)
Yes. Just use a service like https://pastebin.com/ . Make sure that you replace “sensitive” data with dummy data before publish.
Thanks,
Savvas
Thread Starter
Frykky
(@frykky)
Plugin Contributor
Savvas
(@savvasha)
Working just fine here…
https://snipboard.io/2aJiod.jpg
https://snipboard.io/WNhzeQ.jpg
Are you using the latest version of SportsPress? Did you try to import a couple of fixtures to check if this issue was temporary?
Thanks,
Savvas
Thread Starter
Frykky
(@frykky)
maybe there was a bug in the September 2022 release that has now been fixed? I can’t find the changelog with dates…
anyway now with the latest version i tried to import from csv and i see 90 minutes
