Sumo Reference Updates

[Asashosakari]

46 minutes ago, Senkoho said:

Could someone explain this to me? Looks like the DB is not really  familiar with the 2017 Kyushu banzuke...

Works. 

The basho display counter needs to be changed from 2 to 1, because otherwise it's trying to access non-existent 201801 data which causes the query output to go blank.

[Senkoho]

8 minutes ago, Asashosakari said:

Works. 

The basho display counter needs to be changed from 2 to 1, because otherwise it's trying to access non-existent 201801 data which causes the query output to go blank.

thanks for the link!

I'm 100% sure this wasn't an issue before, though. I've used this query many times and never had to switch the counter to 1.

[Asashosakari]

39 minutes ago, Senkoho said:

I'm 100% sure this wasn't an issue before, though. I've used this query many times and never had to switch the counter to 1.

Yes, I agree. Maybe there's usually some dummy data for future tournaments which hasn't been added this time, I'm not sure.

[Atenzan]

http://sumodb.sumogames.de/Rikishi.aspx?r=12316

Kotokumazoe's day 1 win doesn't show up in his rikishi information page- however, it is reflected in his basho record and does show up in his hoshitori breakdown. 

[Doitsuyama]

On 14.11.2017 at 18:22, Asashosakari said:

Yes, I agree. Maybe there's usually some dummy data for future tournaments which hasn't been added this time, I'm not sure.

Not really dummy data, it's the basho table entry with data like venue, start and end date which was still missing. I added the next 18 basho now according to the dates on the NSK site.

[Ryoshishokunin]

On 15/11/2017 at 15:56, McBugger said:

http://sumodb.sumogames.de/Rikishi.aspx?r=12316

Kotokumazoe's day 1 win doesn't show up in his rikishi information page- however, it is reflected in his basho record and does show up in his hoshitori breakdown. 

This is true for a bunch of the Makushita guys--I didn't go through the whole list, but all the ones I looked at had this problem.

[Asashosakari]

Yes, as Pandaazuma mentioned a few posts up, all the hoshitori markers are missing for Day 1 in the lower divisions.

In addition, the fusen result for Ishihara vs Shimizu on Day 4 wasn't accounted for correctly.

[Asashosakari]

Aoiyama's daily records are missing the yasumi counter.

Edited November 19, 2017 by Asashosakari

[sgm]

On 11/9/2017 at 02:44, Doitsuyama said:

I had to move the sumogames websites to a different (and better) server as the old server somehow wasn't able to view the sumo.or.jp website. The new DNS entry might not be there for everybody at once, but usually is available in a matter of a few hours, up to a day. If you see any hickups (which I actually expect with such a big change) please write here or in the games bugs section.

Entry for the sumo games should be possible now.

Thank you for the excellent database!

During this basho, I got the error message "404 - File or directory not found. The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable." a few times. This is not a big deal though, as I can usually access to the website in 10-20 minutes. Can it be related to the new server?

[Nekonishiki Banji]

Something is wrong with the daily results.
http://sumodb.sumogames.de/Results.aspx?b=201711&d=9&simple=on&l=e

In Column 7 (kekka of the east side rikishi) after Aoiyama's result 2-3-4, ALL the east siders get the value of Aoiyama's 4 yasumi.
(Same for the Japanese page)

And the same problem with Sandanme and Jonokuchi.
There wasn't such problem yesterday.

[Asashosakari]

Additional note: These extra yasumi were already added to their records before today's results were accounted for, as the hide-results view indicates.

I noticed that yesterday it was the other way around, i.e. Shimizu in jonokuchi (record before Day 9: 0-2-2) was listed as only 0-2 on the Day 9 torikumi in the DB, while the banzuke view had him correctly at 0-2-2.

[Asashosakari]

Something seems to have corrupted several daily torikumi in the Hatsu 1991 tournament:

http://sumodb.sumogames.de/Results.aspx?b=199101&d=4
http://sumodb.sumogames.de/Results.aspx?b=199101&d=6
http://sumodb.sumogames.de/Results.aspx?b=199101&d=13
http://sumodb.sumogames.de/Results.aspx?b=199101&d=14
http://sumodb.sumogames.de/Results.aspx?b=199101&d=15 (two bouts)

All of these have random maegashira bouts listed as occurring after the musubi no ichiban instead of earlier in the day.

[rhyen]

also missing are Mienoumi's earlier day by day performance.
http://sumodb.sumogames.de/Rikishi.aspx?r=4065

[Asashosakari]

Both the Aki and the Kyushu results have the "rikishi with 0 wins or 0 losses don't show up in the query" bug again.

[Doitsuyama]

On 23.11.2017 at 08:30, rhyen said:

also missing are Mienoumi's earlier day by day performance.
http://sumodb.sumogames.de/Rikishi.aspx?r=4065

What do you mean with this? If you look more closely, you'll see that for these basho no lower division results are available. Maybe I am missing something?

[Doitsuyama]

On 22.11.2017 at 20:42, Asashosakari said:

Something seems to have corrupted several daily torikumi in the Hatsu 1991 tournament:

http://sumodb.sumogames.de/Results.aspx?b=199101&d=4
http://sumodb.sumogames.de/Results.aspx?b=199101&d=6
http://sumodb.sumogames.de/Results.aspx?b=199101&d=13
http://sumodb.sumogames.de/Results.aspx?b=199101&d=14
http://sumodb.sumogames.de/Results.aspx?b=199101&d=15 (two bouts)

All of these have random maegashira bouts listed as occurring after the musubi no ichiban instead of earlier in the day.

Fixed...

Edit: I did a rather big SQL and found 15 more of these weird musubi bouts, mostly from 1989 to 1993, all sorted properly now.

Edited November 25, 2017 by Doitsuyama

[Asashosakari]

On 17.2.2017 at 15:30, PawnSums said:

For Kyushu 1974, Takanohana I And Wakamisugi have Jun-Yusho While Kitanoumi Has Yusho-Doten

This one was fixed back when it was pointed out, but I ran into another case just now: 1976.03 has a 13-win doten and a bogus 12-win jun.

Seems to be the last one though, at least for 1949.05 onward (I only looked at 15-day results).

Edited November 27, 2017 by Asashosakari

[Rocks]

Is the entire site down?

[orandashoho]

13 minutes ago, Rocks said:

Is the entire site down?

Looks that way -- 404 error. This happened to parts of the site yesterday as well (the home page and torikumi page were working then but other pages were down)

[Yamanashi]

1 hour ago, orandashoho said:

Looks that way -- 404 error. This happened to parts of the site yesterday as well (the home page and torikumi page were working then but other pages were down)

Working for me.

 

[Rocks]

4 minutes ago, Yamanashi said:

Working for me.

 

yes, seems to be back up, but still slow.

[Yubinhaad]

Just noticed while preparing the kimarite notes that the Sandanme yusho kettei-sen bout hasn't been added to the database. I don't know whether it's the cause, but for some odd reason the kimarite (oshidashi) is given in Japanese on the English side of the Kyokai site.

[Asashosakari]

On 20.9.2017 at 20:50, Asashosakari said:

On 20.9.2017 at 19:35, Doitsuyama said:

On 1.8.2017 at 16:55, Asashosakari said:

And another jun-yusho question:

1922.05 - isn't Tochigiyama also in a jun-yusho position here? He's got the same W-L differential as Asogatake. Compare 1910.01 which also has two jun-yusho rikishi listed with the same W-L but different draws and absences.

Right, that is not going by the same rules here. Since jun-yusho isn't official and pretty much made up from me I can make my own rules... I feel someone with same win differential, but more draws should be ahead, so I did remove the jun-yusho for Komagatake in 1910.01. It's just 1 win for wins, 0.5 wins for draws, 0 for losses and absences in my mind, as sumo generally isn't very kind to absences.

I'm not sure that's right, because in those days it was possible to get an absent day without being at fault (opponent goes kyujo -> yasumi for both) . I could swear I saw one yusho result that was decided on the same issue, but I'll have to take a look again because I don't remember the details at the moment.

To revisit this again: The example I was thinking of was 1916.01. IMHO, Nishinoumi's yusho victory indicates that the relevant number to establish superiority was simply wins minus losses in those days, ignoring any draws and absences - clearly Nishinoumi didn't have the most wins overall, and he also trailed Genjiyama 8.5 to 9 if draws get counted as half-wins, so it has to be based on them both having a W-L difference of 8 (with the ozeki taking the yusho on his higher rank).

Based on that I don't think it's a good idea to credit the jun-yusho differently, even if they're just unofficial anyway. So, I would be in favour of crediting jun-yusho to Komagatake in 1910.01 and Tochigiyama in 1922.05.

 

[Golynohana]

On 7.11.2017 at 00:41, Golynohana said:

It turns out to be not a problem with the NSK site but with sumogames.de server not being able to reach http://www.sumo.or.jp/ site.
It gives 403 error (Forbidden).
Because I can reach the sumo kyokai site from my local pc, I will grab the results using my grabber locally and then generate scripts and execute them on sumogames.de server.
That way I can run my games for the upcoming basho.
Regarding sumo database and other games - Doitsuyama is on vacations now, hopefully he can find a solution when he comes back.

 

Unfortunately NSK decided to block our new server too, Moving our sumo stuff to yet another server would probably work only for a short time.
We will need to look for a new solution.

Solution idea: developing an easy-to-install windows service, which could be installed on a server that is not blocked by NSK.
This windows service would grab all needed data and send it to sumo reference and to my sumo site via web services.

Regarding my games for hatsu'18 - I am going to enter the data manually as I won't have time to develop anything new.

[dada78641]

On 12/23/2017 at 23:03, Golynohana said:

Unfortunately NSK decided to block our new server too, Moving our sumo stuff to yet another server would probably work only for a short time.
We will need to look for a new solution.

Solution idea: developing an easy-to-install windows service, which could be installed on a server that is not blocked by NSK.
This windows service would grab all needed data and send it to sumo reference and to my sumo site via web services.

Regarding my games for hatsu'18 - I am going to enter the data manually as I won't have time to develop anything new.

I would be willing to set up a proxy script on my server. Technically it should be very simple. I assume we only need opaque calls (only need to retrieve and pass on the actual response data, no need for custom headers other than perhaps some fake UA headers).