Site
Home / Forum / General Discussion / Bugs reporting

Bugs reporting


Posted: 17 Jul 2020 10:45
curswine
Posts: 865
Joined: 2020-06-17

Some fixtures for the American USL Championship seem to have ended up on the Defunct NASL League. Do you know if these have come from the importer or user error? Would it be a quicker job in the backend to shift these to the new league (USL)

It's not me this time. Looking at how they've been added (1920 as the season) that would be the importer.

Posted: 22 Jul 2020 19:55
curswine
Posts: 865
Joined: 2020-06-17

I'm unable to add Pedro Mendes https://en.wikipedia.org/wiki/Pedro_Mendes_(footballer,_born_1979) to the DB, saying he already exists, but then links me to a player of the same name, but with a different DOB https://www.thesportsdb.com/player/34147295.

Posted: 23 Jul 2020 08:36
cydalby
Posts: 335
Joined: 2020-06-16

Some fixtures for the American USL Championship seem to have ended up on the Defunct NASL League. Do you know if these have come from the importer or user error? Would it be a quicker job in the backend to shift these to the new league (USL)

Any update on this?

Posted: 23 Jul 2020 18:57

zag
Posts: 3,323
Joined: 2020-03-23

Some fixtures for the American USL Championship seem to have ended up on the Defunct NASL League. Do you know if these have come from the importer or user error? Would it be a quicker job in the backend to shift these to the new league (USL)

Any update on this?

I've removed the API-Football ID from the NASL as its defuct and added a new one to the USL. Hopefully it will sync from the livescore importer now.

Can you make sure all the teams are correct and have the correct APIfootball ID?

You can find details here:
https://www.thesportsdb.com/sync_apifootball_leagues2.php?id=518

Posted: 23 Jul 2020 19:00

zag
Posts: 3,323
Joined: 2020-03-23

I'm unable to add Pedro Mendes https://en.wikipedia.org/wiki/Pedro_Mendes_(footballer,_born_1979) to the DB, saying he already exists, but then links me to a player of the same name, but with a different DOB https://www.thesportsdb.com/player/34147295.

Yeh he already exists I think here:
https://www.thesportsdb.com/player/34146614

I also checked the logic and the add player dupe search takes into account the name and DOB before blocking anything.

Posted: 23 Jul 2020 19:10

zag
Posts: 3,323
Joined: 2020-03-23

Could these two honours be merged, please?

https://www.thesportsdb.com/honour.php?h=Portuguese%20Primeira%20Liga
https://www.thesportsdb.com/honour.php?h=Primeira%20Liga

Done

Posted: 23 Jul 2020 20:01
curswine
Posts: 865
Joined: 2020-06-17

I'm unable to add Pedro Mendes https://en.wikipedia.org/wiki/Pedro_Mendes_(footballer,_born_1979) to the DB, saying he already exists, but then links me to a player of the same name, but with a different DOB https://www.thesportsdb.com/player/34147295.

Yeh he already exists I think here:
https://www.thesportsdb.com/player/34146614

I also checked the logic and the add player dupe search takes into account the name and DOB before blocking anything.

Great, I'll make sure to do a regular check in the future if anything like that arises again.

Posted: 23 Jul 2020 20:02
curswine
Posts: 865
Joined: 2020-06-17

Some fixtures for the American USL Championship seem to have ended up on the Defunct NASL League. Do you know if these have come from the importer or user error? Would it be a quicker job in the backend to shift these to the new league (USL)

Any update on this?

I've removed the API-Football ID from the NASL as its defuct and added a new one to the USL. Hopefully it will sync from the livescore importer now.

Can you make sure all the teams are correct and have the correct APIfootball ID?

You can find details here:
https://www.thesportsdb.com/sync_apifootball_leagues2.php?id=518


There's been some new teams added to the league which don't have APIfootball IDs listed, any chance a newer list could be published as it is the case in a couple of other leagues too.

Posted: 23 Jul 2020 20:09

zag
Posts: 3,323
Joined: 2020-03-23

There's been some new teams added to the league which don't have APIfootball IDs listed, any chance a newer list could be published as it is the case in a couple of other leagues too.

That page actually uses their API directly to lookup the teams so i'm guessing when they update it will show.

Posted: 28 Jul 2020 19:01

Ovokx
Posts: 1,697
Joined: 2020-06-17

random bug that appears while editing players & events:

Warning: mysqli::__construct(): (HY000/2002): Only one usage of each socket address (protocol/network address/port) is normally permitted. in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 97



Warning: Error establishing mySQLi database connection. Correct user/password? Correct hostname? Database server running? in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 102



Warning: Unexpected error while trying to select database in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 149



Warning: mysqli::escape_string(): Couldn't fetch mysqli in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 192




Posted: 12 Aug 2020 15:14

Ovokx
Posts: 1,697
Joined: 2020-06-17

Delete post function in the forum doesn't do anything

Posted: 17 Aug 2020 11:12
curswine
Posts: 865
Joined: 2020-06-17

It would seem that any match played where the time crosses from 23:59-00:00 UTC is being added in duplicate.

Check out any of the North/South American leagues being played, it seems to be occurring in all of them.

Posted: 18 Aug 2020 09:25
cydalby
Posts: 335
Joined: 2020-06-16

Some of these may be me manually moving them because they're coming up as the wrong date when factoring in UTC time. I think when I move them the importer is re-importing them on the first date meaning we have two events

zag
Posted: 18 Aug 2020 19:30

Ovokx
Posts: 1,697
Joined: 2020-06-17

UEFA Champions League and UEFA Europa League badges are not displayed on the main page:





Posted: 24 Aug 2020 11:49
cydalby
Posts: 335
Joined: 2020-06-16

It would seem that any match played where the time crosses from 23:59-00:00 UTC is being added in duplicate.

Check out any of the North/South American leagues being played, it seems to be occurring in all of them.

Seems to be happening pretty much every day now. BST wise, event 1014834 kicks off at midnight on Tuesday morning but is being picked up as kicking off at midnight on Monday morning by the db. I've been in and manually corrected them to the UTC date/time but they seem to get recreated by the importer meaning theres two events with one on the incorrect date. Getting a bit confusing with BST/UTC and where the event falls.

Am I right in thinking that the db itself should be taken as UTC time so all date/times should be in UTC where possible? (Excluding strLocalTime)


Posted: 26 Aug 2020 13:29
curswine
Posts: 865
Joined: 2020-06-17

I can't seem to add any fighting events at the moment, I keep getting an error where it looks like it's been added, but then displays this ...

Warning: Incorrect integer value: '' for column 'intRound' at row 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272

Warning: Incorrect integer value: '' for column 'idEvent' at row 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272
Checking Event Duplicates:
Adding Event...Done

It's happened with both NJPW and WWE, but it's fine when adding in events for other sports.

zag
Posted: 26 Aug 2020 13:35

zag
Posts: 3,323
Joined: 2020-03-23

I can't seem to add any fighting events at the moment, I keep getting an error where it looks like it's been added, but then displays this ...

Warning: Incorrect integer value: '' for column 'intRound' at row 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272

Warning: Incorrect integer value: '' for column 'idEvent' at row 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272
Checking Event Duplicates:
Adding Event...Done

It's happened with both NJPW and WWE, but it's fine when adding in events for other sports.

Thanks fixed by adding the round to the form.

curswine
Posted: 26 Aug 2020 13:36

zag
Posts: 3,323
Joined: 2020-03-23

Some of these may be me manually moving them because they're coming up as the wrong date when factoring in UTC time. I think when I move them the importer is re-importing them on the first date meaning we have two events

Yes this is going to happen as the importer checks for dupes only on the same date. I'm not sure how to fix it though as the importer is just using the data available.

Posted: 26 Aug 2020 13:43

zag
Posts: 3,323
Joined: 2020-03-23

It would seem that any match played where the time crosses from 23:59-00:00 UTC is being added in duplicate.

Check out any of the North/South American leagues being played, it seems to be occurring in all of them.

Seems to be happening pretty much every day now. BST wise, event 1014834 kicks off at midnight on Tuesday morning but is being picked up as kicking off at midnight on Monday morning by the db. I've been in and manually corrected them to the UTC date/time but they seem to get recreated by the importer meaning theres two events with one on the incorrect date. Getting a bit confusing with BST/UTC and where the event falls.

Am I right in thinking that the db itself should be taken as UTC time so all date/times should be in UTC where possible? (Excluding strLocalTime)


Yes always UTC. I will check the importer logic as this should not happen I think.

Posted: 26 Aug 2020 17:10
cydalby
Posts: 335
Joined: 2020-06-16

Might not help but 1018290 is an example from today. Kicks off BST 00:30 tomorrow

zag
Posted: 26 Aug 2020 18:17

zag
Posts: 3,323
Joined: 2020-03-23

Might not help but 1018290 is an example from today. Kicks off BST 00:30 tomorrow

Actually its very useful, I checked the source API and it looks to me like they have it wrong rather than anything we are doing. This is the football-api source data for that event.

stdClass Object
(
[fixture_id] => 319482
[league_id] => 1356
[league] => stdClass Object
(
[name] => Primera Division - Apertura
[country] => Paraguay
[logo] => https://media.api-sports.io/football/leagues/250.png
[flag] => https://media.api-sports.io/flags/py.svg
)

[event_date] => 2020-08-26T23:30:00+00:00
[event_timestamp] => 1598484600
[firstHalfStart] =>
[secondHalfStart] =>
[round] => Apertura - 16
[status] => Not Started
[statusShort] => NS
[elapsed] => 0
[venue] => Estadio Luis Alberto Salinas Tanasio
[referee] =>
[homeTeam] => stdClass Object
(
[team_id] => 3832
[team_name] => 12 de Octubre
[logo] => https://media.api-sports.io/football/teams/3832.png
)

[awayTeam] => stdClass Object
(
[team_id] => 1182
[team_name] => Olimpia
[logo] => https://media.api-sports.io/football/teams/1182.png
)

[goalsHomeTeam] =>
[goalsAwayTeam] =>
[score] => stdClass Object
(
[halftime] =>
[fulltime] =>
[extratime] =>
[penalty] =>
)

)


Posted: 26 Aug 2020 19:04
curswine
Posts: 865
Joined: 2020-06-17

Edit: I refreshed the page and it reposted my last message, please ignore.

Posted: 26 Aug 2020 19:05

zag
Posts: 3,323
Joined: 2020-03-23

Sorry deleted, please post again

Posted: 26 Aug 2020 19:07
curswine
Posts: 865
Joined: 2020-06-17

I thought something weird happened then.

Their time is correct as BST is UTC+1

UTC = 2020-08-26T23:30:00+00:00
BST = 2020-08-27T00:30:00+00:00

Posted: 26 Aug 2020 19:13
cydalby
Posts: 335
Joined: 2020-06-16

Yep I'm thinking its maybe something I need to handle on my end now

zag

Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm
About Us

Discussion forum for TheSportsDB.com site and related topics
Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 175 to 200 (Total: 456)