Doitsuyama

Sumo Reference Updates

Recommended Posts

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

(works fine for other basho)

Edited by Senkoho

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

  • Like 1
  • Thanks 3

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

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.

  • Thanks 1

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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 by Doitsuyama
  • Thanks 3

Share this post


Link to post
Share on other sites
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 by Asashosakari

Share this post


Link to post
Share on other sites
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)

  • Thanks 1

Share this post


Link to post
Share on other sites
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.

 

Share this post


Link to post
Share on other sites
4 minutes ago, Yamanashi said:

Working for me.

 

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

Share this post


Link to post
Share on other sites

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.

SDks.png

Share this post


Link to post
Share on other sites
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.

 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now