search

DOMjudge / DOMjura

DOMjudge Results Application
https://domjudge.github.com/DOMjura
MIT License
24 stars 1 forks source link

Encountered some problems in beijing invitational contest 2014 #1

Closed 51isoft closed 10 years ago

51isoft commented 10 years ago

We tried to use that for closing ceremony, but it failed to render.... I can give you the original event.xml and scoreboard.xml directly saved from plugin/*.php for debug purpose. My guess might be some issues in UTF-8 characters.

We tested it in a smaller contest before that and it worked perfect.

nickygerritsen commented 10 years ago

Hi Yi,

Yeah please send it so I can take a look :).

51isoft commented 10 years ago

I sent them to your @me.com email. Thank you very much!

nickygerritsen commented 10 years ago

I did take a look and I think I found the problem. The scoreboard.xml has other problem ID's than the events.xml.

For example, in events.xml:

<event id="381" time="2014-05-17 14:31:00">
  <submission id="102">
    <team id="seat004">BIT_F8</team>
    <problem id="CC">Calculate Your RP</problem>
    <language id="cpp">C++</language>
  </submission>
</event>

Whereas in the scoreboard.xml the only problem that has an ID starting with C is:

<problem id="CL" color="#00ff00">Champions League</problem>

So what happened to the problems?

51isoft commented 10 years ago

hmm... In the system we have several different contests. The warmup contests are using AA BB CC DD. And the official contests are using other ones.

On Sat, May 31, 2014 at 7:41 PM, Nicky Gerritsen notifications@github.com wrote:

I did take a look and I think I found the problem. The scoreboard.xml has other problem ID's than the events.xml.

For example, in events.xml:

BIT_F8 Calculate Your RP C++

Whereas in the scoreboard.xml the only problem that has an ID starting with C is:

Champions League

So what happened to the problems?

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746052 .

nickygerritsen commented 10 years ago

Hmmm those are also in event.xml so let me check further

51isoft commented 10 years ago

FYI, the time table is shown below. c3 uses all the problems. c5 c9 c6 uses AA BB CC DD, c4 c8 c7 uses others. c7 is the contest I want to show. And between contests, I just move the problems from one contest to another.

CID activate start freeze end unfreeze name c7 21:30 09:00 13:00 14:00 21:00 2014 ACM-ICPC Beijing Invitational Programming Contest edit delete c8 17:50 18:00 21:29 21:29 21:29 Final Test edit delete c6 11:30 14:30 17:00 17:30 17:30 2014 ACM-ICPC Beijing Invitational Programming Contest, Warmup edit delete c9 05:00 06:00 11:20 11:20 11:20 Morning test edit delete c5 12:00 13:00 23:00 23:00 23:00 Practice Contest, time test edit delete c4 17:40 17:40 21:50 22:50 01:50 BNU Test Contest edit delete c3 12:00 12:00 17:39 17:39 17:39 Test Contest edit delete

nickygerritsen commented 10 years ago

OK it is really strange from what I can see. In the events.xml there are submission events for all problems, including the real contest. However, the judging events are only there for:

So I am missing the judgings of the "normal" teams for the correct problems and thus I can not determine if the submissions are correct or not...

51isoft commented 10 years ago

Hmm... Strange to me as well... Maybe a domjudge issue?

On Sat, May 31, 2014 at 8:00 PM, Nicky Gerritsen notifications@github.com wrote:

OK it is really strange from what I can see. In the events.xml there are submission events for all problems, including the real contest. However, the judging events are only there for:

  • Problems AA, BB, CC, DD
  • Team domjudge

So I am missing the judgings of the "normal" teams for the correct problems and thus I can not determine if the submissions are correct or not...

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746456 .

nickygerritsen commented 10 years ago

Seems to me that way yeah. Maybe it is because problems were moved?

51isoft commented 10 years ago

Hmm... strange enough... We moved the problems multiple times.. Maybe because we turned on "verification required" before official contest? I'll file another issue to domjudge

On Sat, May 31, 2014 at 8:08 PM, Nicky Gerritsen notifications@github.com wrote:

Seems to me that way yeah. Maybe it is because problems were moved?

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746634 .

51isoft commented 10 years ago

seems I found the problem... In DB, the judging id is NULL...

12003 2014-05-18 14:00:15 7 NULL cpp FT 5824 NULL 0 problem judged

On Sat, May 31, 2014 at 8:18 PM, 51isoft yichaonet@gmail.com wrote:

Hmm... strange enough... We moved the problems multiple times.. Maybe because we turned on "verification required" before official contest? I'll file another issue to domjudge

On Sat, May 31, 2014 at 8:08 PM, Nicky Gerritsen <notifications@github.com

wrote:

Seems to me that way yeah. Maybe it is because problems were moved?

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746634 .

nickygerritsen commented 10 years ago

And for the other problems it is not? Because there can be multiple judging for 1 submission right, so I'd think there would be a submissionId in the judgings table? (I don't have access to a domjudge database currently, sorry)

51isoft commented 10 years ago

Yeah, there is a submissionId. I tried to set judgingids all to a certain ID, seems nothing changes... Sorry for the false alarm..

On Sat, May 31, 2014 at 8:23 PM, Nicky Gerritsen notifications@github.com wrote:

And for the other problems it is not? Because there can be multiple judging for 1 submission right, so I'd think there would be a submissionId in the judgings table? (I don't have access to a domjudge database currently, sorry)

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746913 .

nickygerritsen commented 10 years ago

Very strange. I think we should ask the domjudge team then? Or is there something like a contest-ID in either the judging or submission table?

51isoft commented 10 years ago

Yes there is. I'll contact domjudge team then. I can send the full sql file if they needed :).

On Sat, May 31, 2014 at 8:27 PM, Nicky Gerritsen notifications@github.com wrote:

Very strange. I think we should ask the domjudge team then? Or is there something like a contest-ID in either the judging or submission table?

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746980 .

51isoft commented 10 years ago

I found the problem, and it's because the judgingid is NULL.

In event.php:

61 case 'problem judged': 62 $data = $DB->q('MAYBETUPLE SELECT s.submittime, j.result FROM judging j 63 LEFT JOIN submission s ON (s.submitid = j.submitid) 64 WHERE j.judgingid = %i', $row['judgingid']);

I modified it a little bit to make it temporarily work: 65 $data = $DB->q('MAYBETUPLE SELECT s.submittime, j.result FROM judging j 66 LEFT JOIN submission s ON (s.submitid = j.submitid) 67 WHERE j.submitid = %i limit 0,1', $row['submitid']);

So, the question becomes: why judging id is null... So it's definitely a domjudge issue..

Thanks for your time and patience!

On Sat, May 31, 2014 at 8:29 PM, 51isoft yichaonet@gmail.com wrote:

Yes there is. I'll contact domjudge team then. I can send the full sql file if they needed :).

On Sat, May 31, 2014 at 8:27 PM, Nicky Gerritsen <notifications@github.com

wrote:

Very strange. I think we should ask the domjudge team then? Or is there something like a contest-ID in either the judging or submission table?

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44746980 .

nickygerritsen commented 10 years ago

No problem, glad to help. Let's see what the domjudge team has to say then :smile: . Will close this issue for now

thijskh commented 10 years ago

I do not have a simple explanation for this. Would it be possible to receive an SQL dump of the database?

51isoft commented 10 years ago

of course, I'll find a way to send that to you this in a few days. 2014-6-3 下午6:03于 "Thijs" notifications@github.com写道：

I do not have a simple explanation for this. Would it be possible to receive an SQL dump of the database?

— Reply to this email directly or view it on GitHub https://github.com/nickygerritsen/DOMjura/issues/1#issuecomment-44945654 .