Played minutes error

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

90 minutes

if you tell me in which table plugin writes I can tell you the values that are stored on db

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

Yes I confirm, look my screenshot two posts above

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!

You’re right, it’s zero!

https://snipboard.io/Mrt0XA.jpg

Why?
How can i fix it?

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

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 ??

Maybe i can give you an example of our csv?

Yes. Just use a service like https://pastebin.com/ . Make sure that you replace “sensitive” data with dummy data before publish.

Thanks,
Savvas

https://pastebin.com/mmWmay8u

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

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