Site
Home / Forum / General Discussion / Bugs reporting

Bugs reporting


Posted: 13 Feb 2021 13:41
curswine
Posts: 863
Joined: 2020-06-17

It should work for any new events added manually with the "Add Event" button that have a specific artwork map (click the 'art' button on the league page to check for a mapping). If not then upload art again and it should map it for the future.

Sadly the bulk importing scripts I use in the background will need a load more code to complete but I will add it to the list.

At the moment the feature will work best for things like motor racing or golf I think.


It seems I misunderstood how it actually worked,

I will reupload them when I get chance to.

Posted: 16 Feb 2021 13:31
cydalby
Posts: 335
Joined: 2020-06-16

Barca vs PSG showing no previous results between the two teams. Pretty sure they've played each other a few times in the Champions league

zag
Posted: 17 Feb 2021 19:47

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

While adding manually events for Spanish Copa del Rey de baloncesto, the new feature of mapping images is wrongly linking images from other competitions between these teams. Here you can see an example where is linking an EuroLeague thumb:

https://www.thesportsdb.com/event/1091216

I guess that the mapping process only search for name events to link images. Is it possible to first search by league and then by event name, in order to avoid this wrong links, please?

TY!


Thanks, I did a load more work so it supports leagues as well as event naming now. Thanks for bringing this up!

Posted: 17 Feb 2021 19:48

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

It seems I misunderstood how it actually worked,

I will reupload them when I get chance to.


It will work with the automated soccer importers soon I hope. I just wanted to get manual working first.

Posted: 17 Feb 2021 19:54

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

Barca vs PSG showing no previous results between the two teams. Pretty sure they've played each other a few times in the Champions league

Thanks yeh I had to disable the head 2 head code as it was causing performance issues. I'll look for more solutions.

Posted: 21 Feb 2021 14:02
curswine
Posts: 863
Joined: 2020-06-17

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

Posted: 21 Feb 2021 19:19

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

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,690
Joined: 2020-06-17

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,311
Joined: 2020-03-23

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

Ovokx
Posted: 25 Feb 2021 22:02
curswine
Posts: 863
Joined: 2020-06-17

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: 30
Joined: 2021-02-10

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,311
Joined: 2020-03-23

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,311
Joined: 2020-03-23

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: 863
Joined: 2020-06-17

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,311
Joined: 2020-03-23

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-02-14

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: 863
Joined: 2020-06-17

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

Posted: 28 Feb 2021 23:25
Contruba
Posts: 8
Joined: 2021-02-14

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: 863
Joined: 2020-06-17

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,311
Joined: 2020-03-23

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-02-14

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: 863
Joined: 2020-06-17

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,311
Joined: 2020-03-23

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: 863
Joined: 2020-06-17

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,690
Joined: 2020-06-17

User page looks broken:



No stats and no watched events are displayed


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 294 to 319 (Total: 456)