Site
Home / Forum / General Discussion / Bugs reporting

Bugs reporting


Posted: 21 Feb 2021 19:19

zag


Posts: 3,515
Joined: 2020

I've found two players with the same name and (presumably) the same DoB, any idea how that could have happened?

https://www.thesportsdb.com/player/34146075
https://www.thesportsdb.com/player/34174161

Had a quick look at the db fields and indeed has same DOB so not quite sure. Might be the apifootball sync script as only one had an apifootball ID. I removed the dupe now.

Posted: 23 Feb 2021 18:16

Ovokx

Posts: 1,769
Joined: 2020

error that I'm getting while adding TV info (NBA 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: 23 Feb 2021 18:49

zag


Posts: 3,515
Joined: 2020

Looks like someone is hammering the website or API again! I will look...

Ovokx
Posted: 25 Feb 2021 22:02
curswine


Posts: 940
Joined: 2020

I'm getting this error when trying to sync the Rangers vs Antwerp match

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272

Timeline Dupe

It only affects this match, and only the Rangers team. https://www.thesportsdb.com/event/1065804

Posted: 26 Feb 2021 05:58
coachwood


Posts: 32
Joined: 2021

Not a bug per say, but this league looks to have had a data import with old and/or bad data.

Fixtures are changing regularly due to COVID restrictions around Australia but this is a now a mess with many duplicate events.

https://www.thesportsdb.com/season.php?l=4356&s=2020-2021

I can only edit basic data, cant see a way to remove / merge events?

zag
Posted: 26 Feb 2021 20:29

zag


Posts: 3,515
Joined: 2020

I'm getting this error when trying to sync the Rangers vs Antwerp match

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in C:\inetpub\thesportsdb.com\includes\ez_sql_mysqli.php on line 272

Timeline Dupe

It only affects this match, and only the Rangers team. https://www.thesportsdb.com/event/1065804

Problem with the Rangers api football ID fixed.

Posted: 26 Feb 2021 20:31

zag


Posts: 3,515
Joined: 2020

Not a bug per say, but this league looks to have had a data import with old and/or bad data.

Fixtures are changing regularly due to COVID restrictions around Australia but this is a now a mess with many duplicate events.

https://www.thesportsdb.com/season.php?l=4356&s=2020-2021

I can only edit basic data, cant see a way to remove / merge events?

Oh wow, bit of a mess already! Is the Ozzy season cancelled?

EDIT: I re-imported but its still pretty messed up, looks like they have rescheduled games on the same date as future events or something. I guess it will fix itself over time.

Posted: 26 Feb 2021 23:28
curswine


Posts: 940
Joined: 2020

The new time selection method is allowing incorrectly input times to be used if nothing is entered in the seconds column.

For example:
https://www.thesportsdb.com/event/1037337

Posted: 27 Feb 2021 00:20

zag


Posts: 3,515
Joined: 2020

The new time selection method is allowing incorrectly input times to be used if nothing is entered in the seconds column.

For example:
https://www.thesportsdb.com/event/1037337

Thanks cleaned it up a little and added some edge cases to the code. Hopefully all fixed now and the timestamp also is updated which was another small bug.

Posted: 28 Feb 2021 22:39
Contruba

Posts: 8
Joined: 2021

https://www.thesportsdb.com/league/4489-V8-Supercars

It's not really a bug, per se... but when I attempt to enter (clean) text in the League->Description text area, the resulting display on the page includes carriage return and line feeds ('\r\n\r\n'), as well as escaping characters for single-quotes.

I've tried multiple approaches to keep it from rendering those symbols (so that it looks clean like the Formula 1 Description). I even formatted it as HTML, and while this provides clean looking text on the webpage, it will include the HTML markup in the API "strDescriptionEN" field, which is not a great solution.

Please advise how I can add text to the league description text area without the resulting carriage return + line feed (yes, I am using a Windows OS and Google Chrome browser).

Cheers,
Jason

Posted: 28 Feb 2021 23:08
curswine


Posts: 940
Joined: 2020

What is the source of the text that you're copying from?

Posted: 28 Feb 2021 23:25
Contruba

Posts: 8
Joined: 2021

What is the source of the text that you're copying from?

I've tried straight copy-paste from Wikipedia (which is where the original information came from; I was just updating it). When that caused issues, I tried copy-paste in and out of Notepad to remove any hidden markup. When that didn't work, I used online tools to clean/strip out any hidden characters. When that didn't work, I turned to using HTML.

While I was able to get HTML to work by ONLY using paragraph tags (line break tags caused the same issue) without any spaces/new lines in the text, I realized that the output in the API would include HTML markup, which is inconsistent with the Formula 1 page (and I assume most other pages).

Yet, I have new lines in this post right here and there are no unexpected side effects. So, yeah, I'm not sure what I could do to avoid the issue.

-Jason

Posted: 01 Mar 2021 09:27
curswine


Posts: 940
Joined: 2020

The first things you tried should have worked fine, so I'm a little confused on what the issue could be.

What operating system are you using? With you trying to paste to Notepad first I'm guessing it's Windows you're using.

Posted: 01 Mar 2021 10:39

zag


Posts: 3,515
Joined: 2020

Actually this was a bug I introduced yesterday doing some SQL injection hardening! All fixed now, thanks for pointing it out.

You should be able to directly copy and paste from Wikipedia and the code will remove the formatting bits and reference [] items.

EDIT: Also fixed on events, players and team pages.

curswine, Contruba
Posted: 01 Mar 2021 15:41
Contruba

Posts: 8
Joined: 2021

curswine, copy/paste in and out of Notepad is just an old skool trick to get rid of the nasty Windows hidden symbols that can come up using other text editors. Yes, yes... I'd prefer to be in Linux, but Windows is needed for my 'real' job haha

Thanks, Zag! I thought I was going crazy!



zag, curswine
Posted: 03 Mar 2021 19:04
curswine


Posts: 940
Joined: 2020

I'm getting this error when trying to sync squads and also when looking up league IDs

cURL Error #:error setting certificate verify locations: CAfile: C:\inetpub\cacert.pem CApath: none

The live scores don't appear to have updated from around 11/12 o'clock today either.



Posted: 03 Mar 2021 21:29

zag


Posts: 3,515
Joined: 2020

I'm getting this error when trying to sync squads and also when looking up league IDs

cURL Error #:error setting certificate verify locations: CAfile: C:\inetpub\cacert.pem CApath: none

The live scores don't appear to have updated from around 11/12 o'clock today either.



Damn, I thought I didn't need that file restored...


curswine
Posted: 03 Mar 2021 22:10
curswine


Posts: 940
Joined: 2020

Looks like all games which had results concluded in that time haven't had their results added.

Something to just keep an eye on.

Posted: 07 Mar 2021 08:35

Ovokx

Posts: 1,769
Joined: 2020

User page looks broken:



No stats and no watched events are displayed

Posted: 12 Mar 2021 13:56

zag


Posts: 3,515
Joined: 2020

Yes sorry turned off for perfomance reasons, I will turn back on soon when I check the SQL optimzation.

- Fixed a small bug with event titles and back slashes or apostrophes.

Posted: 12 Mar 2021 22:44
curswine


Posts: 940
Joined: 2020

I'm getting this error when trying to add a new wrestling event.

Parse error: syntax error, unexpected ')' in C:\inetpub\thesportsdb.com\edit_event_add_process.php on line 13

Posted: 13 Mar 2021 10:44

Ovokx

Posts: 1,769
Joined: 2020

same error here while trying to add boxing event

Posted: 13 Mar 2021 21:04

zag


Posts: 3,515
Joined: 2020

Fixed sorry...

curswine, Ovokx
Posted: 19 Mar 2021 13:40
curswine


Posts: 940
Joined: 2020

Just a small thing, when uploading stadium pictures a successful upload returns 'Return to Artist', could this be changed to 'Return to Team' like every other successful upload message?

Thanks.

Posted: 21 Mar 2021 19:49
curswine


Posts: 940
Joined: 2020

Can an extra check on the event types be done when syncing events, at the moment if two events happen to a player in the same minute one is being counted as a dupe.

So if a player is subbed and then scores or is carded it isn't being added and needs to be done manually.

Here is an example of what I'm talking about.




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 300 to 325 (Total: 470)