Site
Home / Forum / General Discussion / Bugs reporting

Bugs reporting


Posted: 15 Jul 2022 14:49
curswine


Posts: 959
Joined: 2020

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
transparent spacer
Posted: 27 Jul 2022 07:07

Ovokx

Posts: 1,783
Joined: 2020

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
transparent spacer
Posted: 27 Jul 2022 10:08

zag


Posts: 3,627
Joined: 2020

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
transparent spacer
Posted: 28 Jul 2022 18:19

zag


Posts: 3,627
Joined: 2020

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

transparent spacer
Posted: 30 Jul 2022 11:47
curswine


Posts: 959
Joined: 2020

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.

transparent spacer
Posted: 07 Aug 2022 07:41

Ovokx

Posts: 1,783
Joined: 2020



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

transparent spacer
Posted: 07 Aug 2022 16:09

zag


Posts: 3,627
Joined: 2020

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

All fixed now, sorry all.

cardinaldiehard25
transparent spacer
Posted: 08 Aug 2022 12:19


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?

transparent spacer
Posted: 09 Aug 2022 09:45

zag


Posts: 3,627
Joined: 2020

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.

transparent spacer
Posted: 11 Aug 2022 16:58
curswine


Posts: 959
Joined: 2020

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
transparent spacer
Posted: 12 Aug 2022 12:04
curswine


Posts: 959
Joined: 2020

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
transparent spacer
Posted: 17 Aug 2022 11:45

zag


Posts: 3,627
Joined: 2020

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.

transparent spacer
Posted: 20 Aug 2022 09:02

Ovokx

Posts: 1,783
Joined: 2020

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




transparent spacer
Posted: 20 Aug 2022 10:47

Ovokx

Posts: 1,783
Joined: 2020

"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
transparent spacer
Posted: 28 Aug 2022 00:09
cardinaldiehard25

Posts: 162
Joined: 2021

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
transparent spacer
Posted: 17 Sep 2022 12:47

Ovokx

Posts: 1,783
Joined: 2020

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
transparent spacer
Posted: 17 Sep 2022 13:02
curswine


Posts: 959
Joined: 2020

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
transparent spacer
Posted: 02 Nov 2022 14:44

zag


Posts: 3,627
Joined: 2020

Fixed the last 2 bugs mentioned. Thanks for reporting.

Ovokx
transparent spacer
Posted: 05 Nov 2022 13:34

Ovokx

Posts: 1,783
Joined: 2020

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





transparent spacer
Posted: 23 Jan 2023 08:43
curswine


Posts: 959
Joined: 2020

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).



transparent spacer
Posted: 08 Feb 2023 14:38
smudgie

Posts: 379
Joined: 2020

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
transparent spacer
Posted: 01 Mar 2023 12:08
Franz

Posts: 15
Joined: 2022

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

transparent spacer
Posted: 01 Mar 2023 14:33
curswine


Posts: 959
Joined: 2020

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
transparent spacer
Posted: 02 Mar 2023 21:59

zag


Posts: 3,627
Joined: 2020

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"

transparent spacer
Posted: 03 Mar 2023 15:54

zag


Posts: 3,627
Joined: 2020

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

transparent spacer

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: 470)