Site
Home / Forum / General Discussion / Bugs reporting

Bugs reporting


Posted: 15 Jul 2022 14:49
curswine
Posts: 868
Joined: 2020-06-17

Noticed a bug with FIBA Asia Cup that is likely happening for other Cup Competitions. Only teams that have FIBA Asia Cup set as their main league are having their events imported. I know for example we were having issues with Euroleague where events were not importing, but it would still show up in live scores if the event was added manually.

https://www.thesportsdb.com/league/4898

Events are also getting duped somehow from the importer


Regarding the events not being imported when not main league, I saw that happen with Volleyball also.

Event dupes might be related to my previous post about Triple A baseball events being duplicated.

cardinaldiehard25
Posted: 27 Jul 2022 07:07

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

Women national teams don't have current season activated in order to add kits on the Archive page. Example:



https://www.thesportsdb.com/equipment.php?t=136818


zag
Posted: 27 Jul 2022 10:08

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

Women national teams don't have current season activated in order to add kits on the Archive page. Example:



https://www.thesportsdb.com/equipment.php?t=136818


Yeh thats by design, it will only show the years for the main tournament they are in. In this case the world cup.

Ovokx
Posted: 28 Jul 2022 18:19

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

Fixed a big bug with the update of 2021-2022 scheduals. All should be imported now.

Posted: 30 Jul 2022 11:47
curswine
Posts: 868
Joined: 2020-06-17

Something is causing the event timelines to duplicate entries when it is clicked more than once. https://www.thesportsdb.com/event/1576656 is an example. I synced lineups and timeline, one player was missing, I added them and synced both lineup and timeline again, but some appeared in duplicate.

Also the player import seems to not be working.

Posted: 07 Aug 2022 07:41

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



Fanart Image icon is not displayed even having the art added to the event

Posted: 07 Aug 2022 16:09

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

Livescore was broken for 36hrs. Not great on premiership opening weekend!

All fixed now, sorry all.

cardinaldiehard25
Posted: 08 Aug 2022 12:19
toy_man_98
Posts: 1
Joined: 2022-05-06

https://www.thesportsdb.com/API/v1/json/2/eventsseason.php?id=4391&s=2022
When I try this with my API key, not working.
Ideas?

Posted: 09 Aug 2022 09:45

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

https://www.thesportsdb.com/API/v1/json/2/eventsseason.php?id=4391&s=2022
When I try this with my API key, not working.
Ideas?


Working fine here, just copied and pasted into a web browser.

Posted: 11 Aug 2022 16:58
curswine
Posts: 868
Joined: 2020-06-17

I'm trying to update events and I keep getting this error message.

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


cardinaldiehard25
Posted: 12 Aug 2022 12:04
curswine
Posts: 868
Joined: 2020-06-17

Here's more error messages I've been getting today, they're making the site unusable and its also affecting the API.

Loading the frontpage...
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


Updating an event...
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

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

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


On the MLB 2022 season page, this would appear between events...
Warning: mysqli::escape_string(): Couldn't fetch mysqli in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 192

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

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

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


On the calendar page, the last two lines repeated about 30 times...

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: mysqli::escape_string(): Couldn't fetch mysqli in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 192


API error shows this...


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

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



cardinaldiehard25
Posted: 17 Aug 2022 11:45

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

Thanks for the reports, i'm keeping an eye on the MYsql issues.

It's was just overloaded and someone doing something silly with the free key. I'll investigate some more but it should not be a problem going forward.

Posted: 20 Aug 2022 09:02

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

Just found a bug related to automatic soccer player stats:

If a player played a game from the bench, it doesn't count on the appearences stats. Here you can see an example with Radamel Falcao (https://www.thesportsdb.com/player/34152730) who played yesterday and scored, but on his profile page only the goal is counted.



This bug is still active. I have detected a new example: https://www.thesportsdb.com/player/34174634



Any advance on this bug reported in 2021, please? Just found another example of a player displaying 3 goals (made as substitute), but with no appearences stats displayed

https://www.thesportsdb.com/player/34199235


Bug still active. New example of subst player without displaying he played a game (and scored):

https://www.thesportsdb.com/player/34200254




Posted: 20 Aug 2022 10:47

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

"World Swimming Championships" league has the "Team vs Team" structure and should be changed into "Fighting" structure in order to add events, please:

https://www.thesportsdb.com/league/5308

zag
Posted: 28 Aug 2022 00:09
cardinaldiehard25
Posts: 162
Joined: 2021-05-22

Non-soccer leagues are not having their events imported unless teams are set with the league as the "primary competition". This is an issue for cup competitions like EuroLeague where a different league is their primary competition. Below is a sample of some leagues affected by this:

https://www.thesportsdb.com/league/5275
https://www.thesportsdb.com/league/5274
https://www.thesportsdb.com/league/4980
https://www.thesportsdb.com/league/4546
https://www.thesportsdb.com/league/4547
https://www.thesportsdb.com/league/4548

curswine
Posted: 17 Sep 2022 12:47

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

If League Badge Old is changed by a new one replacing an existing one, displayed version keeps the same. Example on 2012-13 Bundesliga:

New version was added:


Displayed version:


zag
Posted: 17 Sep 2022 13:02
curswine
Posts: 868
Joined: 2020-06-17

I'm having trouble syncing lineups for two games

Stuttgart vs Ein Frankfurt - https://www.thesportsdb.com/event/1574405
Dortmund vs Schalke 04 - https://www.thesportsdb.com/event/1574406

I'm getting error messages for every player with a green tick, but none are showing up, the error is:

Warning: Data too long for column 'strPositionShort' at row 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272
Home Lineup Inserted (Player Name)


Edit I synced them once more and it worked correctly this time. I'll leave the message up just incase its something that needs looking at.

zag
Posted: 02 Nov 2022 14:44

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

Fixed the last 2 bugs mentioned. Thanks for reporting.

Ovokx
Posted: 05 Nov 2022 13:34

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

League Badge Old bug detected also in player pages. Example https://www.thesportsdb.com/player/34192442

It shows not updated badge for 2019 events (dark blue color) instead of white updated version: https://www.thesportsdb.com/season.php?l=5007&s=2019





Posted: 23 Jan 2023 08:43
curswine
Posts: 868
Joined: 2020-06-17

Just seen this bug,

I imagine this is because the player wasn't in the DB when I synced the match, and they were substituted on in the same minute they scored too,



This results in the subbed player's name not appearing or the goal they scored (should be for Elvis Rexhbecaj).



Posted: 08 Feb 2023 14:38
smudgie
Posts: 338
Joined: 2020-06-17

Hi Zag, players images, on teams with large squads 40+.
On team members page 2 you can't change the view type, clicking another type reverts to team members page 1.

zag
Posted: 01 Mar 2023 12:08
Franz
Posts: 11
Joined: 2022-06-18

The flag of Congo is wrong, while the flag of "Congo, Democratic Republic of" shows nothing, pls fix it

Posted: 01 Mar 2023 14:33
curswine
Posts: 868
Joined: 2020-06-17

The flag of Congo is wrong, while the flag of "Congo, Democratic Republic of" shows nothing, pls fix it

Definitely needs fixing, but a work around for now is:

DR Congo = Congo
Congo = Republic of the Congo

Franz, zag
Posted: 02 Mar 2023 21:59

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

The flag of Congo is wrong, while the flag of "Congo, Democratic Republic of" shows nothing, pls fix it

Thanks fixed and normalized for team and player countries.

"Democratic Republic of Congo"

Also fixed and normalized:

"Ivory Coast"

Posted: 03 Mar 2023 15:54

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

Hi Zag, players images, on teams with large squads 40+.
On team members page 2 you can't change the view type, clicking another type reverts to team members page 1.


Thanks, fixed


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 425 to 450 (Total: 456)