williamleonard / obblm

Automatically exported from code.google.com/p/obblm
1 stars 0 forks source link

no modification possibles anymore, since a game-report was incompletely done. #642

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. a game was created 
2. the coachs forgot to enter in the game-report the results of the dices for 
the new skills won during a game.
3. one of the coach manage to select a skill on his team-page, even if these 
values were not entered. 

What is the expected output? What do you see instead?
No more modification are possible. even for not related team/games.
1. when trying to update any game report we see this:
Request failed : Saving match report
Request failed : Failed to save player entry with PID = 28

Got error -1 from storage engine

INSERT INTO match_data 
(agn1,agn2,bh,cp,f_coach_id,f_did,f_lid,f_match_id,f_player_id,f_race_id,f_team_
id,f_tour_id,inj,intcpt,ir1_d1,ir1_d2,ir2_d1,ir2_d2,ir3_d1,ir3_d2,ki,mg,mvp,si,t
d) VALUES (1,1,0,0,6,5,7,17,28,21,17,5,1,0,0,0,0,0,0,0,0,0,0,0,0)

2. When trying to schedule a new game, hire a player, etc:
Request failed : SQL query failed.

3. When trying to rename or re-numerate a player
Request failed

Etc...

Even with admin rights i could not do such changes.
All teams/games/coachs/users are impacted since this weekend... 

What version of the product are you using?
OBBLM version 0.96
i was assuming it was similar to Issue 598. but, we are much more blocked...

i probably badly identify the root cause of the issue... 

Please provide any additional information below.
Here the links of the 2 games:
http://www.bbbrussels.figs28.be/index.php?section=matches&type=report&mid=17
http://www.bbbrussels.figs28.be/index.php?section=matches&type=report&mid=16

Original issue reported on code.google.com by florentm...@gmail.com on 5 May 2014 at 9:42

GoogleCodeExporter commented 9 years ago
This sounds pretty severe. I will need full database access to figure out if 
this is OBBLM or some MySQL problem. Send me an email and I'll have a look at 
it for you.
Sorry for the delay, I'm a little busy at the moment.

Original comment by Nimda...@gmail.com on 8 Jul 2014 at 6:48