adding team to multiple positions on the same ladder will screw up ladder standing/levelposition/team list

[GoogleCodeExporter]

should prevent adding the same team to multiple positions.

quick fix:
remove the duplicated team on levelpositions of same ladder.

todo: 

1.backup db
2. delete keith/natasha from mix ladder/position
2.exchange position: eddy/jade with keith/natasha
3.backup db again
4.enable website.

Original issue reported on code.google.com by will....@gmail.com on 17 May 2010 at 2:59

Attachments:

• ladder_may17.png
• ladder_may17_position.png

[GoogleCodeExporter]

 Error 500: Error evaluating expression [posInstance.team?.status] on line [114]:
org.hibernate.HibernateException: More than one row with the given identifier 
was
found: 24, for class: ladder.LevelPosition
Servlet: grails
URI: /Ladder/grails/level/list.dispatch
Exception Message: More than one row with the given identifier was found: 24, 
for
class: ladder.LevelPosition
Caused by: Error evaluating expression [posInstance.team?.status] on line [114]:
org.hibernate.HibernateException: More than one row with the given identifier 
was
found: 24, for class: ladder.LevelPosition
Class: /home/will/projects/tennis-ladder-online/grails-app/views/level/list.gsp
At Line: [114]
Code Snippet:
113: <g:each sort="true" in="${levelInstance.levelposition}" status="j"
var="posInstance">
114: <span class="${posInstance.team?.status}">
115: ${fieldValue(bean:posInstance, 
field:'team')}${posInstance.team?.shortStatus}
Stack Trace

org.codehaus.groovy.grails.web.pages.exceptions.GroovyPagesException: Error
evaluating expression [posInstance.team?.status] on line [114]:
org.hibernate.HibernateException: More than one row with the given identifier 
was
found: 24, for class: ladder.LevelPosition

    at
home_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp$_run_clo
sure2_closure34_closure47.doCall(home_will_projects_tennis_ladder_online_grails_
app_views_level_list_gsp:107)

    at
home_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp$_run_clo
sure2_closure34.doCall(home_will_projects_tennis_ladder_online_grails_app_views_
level_list_gsp:105)

    at
home_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp$_run_clo
sure2.doCall(home_will_projects_tennis_ladder_online_grails_app_views_level_list
_gsp:101)

    at
home_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp$_run_clo
sure2.doCall(home_will_projects_tennis_ladder_online_grails_app_views_level_list
_gsp)

    at
home_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp.run(home
_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp:119)

    at java.lang.Thread.run(Thread.java:619)

Caused by: org.codehaus.groovy.runtime.InvokerInvocationException:
org.hibernate.HibernateException: More than one row with the given identifier 
was
found: 24, for class: ladder.LevelPosition

    ... 6 more

Caused by: org.hibernate.HibernateException: More than one row with the given
identifier was found: 24, for class: ladder.LevelPosition

    at
home_will_projects_tennis_ladder_online_grails_app_views_level_list_gsp$_run_clo
sure2_closure34_closure47_closure48.doCall(home_will_projects_tennis_ladder_onli
ne_grails_app_views_level_list_gsp:107)

    ... 6 more

Original comment by will....@gmail.com on 17 May 2010 at 3:02