Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

not unique table alias error

#209

ActiveRecord::StatementInvalid: Mysql::Error: Not unique table/alias: 'groups_students': SELECT enrollments.* FROM enrollments inner join groups_students on groups_students.student_id = enrollments.student_id inner join user_group_assignments on group

http://vegantech.hoptoadapp.com/...

Reported by shawn (at vegantech) · March 25th, 2009 @ 10:10 AM

State: resolved
Assigned to: shawn (at vegantech) shawn (at vegantech)

Activity

  1. shawn (at vegantech)
    shawn (at vegantech)

    Search by groups seems to be entirely broken, names appear duplicated several times.

    March 26th, 2009 @ 11:10 AM

  2. shawn (at vegantech)
  3. shawn (at vegantech)
    shawn (at vegantech)

    pick a grade, pick a different user, pick one of the groups.

    March 26th, 2009 @ 11:12 AM

  4. shawn (at vegantech)
    shawn (at vegantech)

    (from [2f30c80526034e14edb4af9d3e67c82a5cd04c62]) Features to capture two problems in [#209 not unique table alias error] group search dropdowns and abbiguous error also updated fixtures so this can be triggered in dev http://github.com/vegantech/sims...

    March 26th, 2009 @ 04:40 PM

  5. shawn (at vegantech)
    shawn (at vegantech)

    (from [2b94c5e981e06c6b52b6279707c565e34d32fd9e]) [#209 not unique table alias error] Remove side effect of setting prompt in params from model and remove duplicate group members http://github.com/vegantech/sims...

    March 26th, 2009 @ 04:40 PM

  6. shawn (at vegantech)
    shawn (at vegantech)

    (from [ff46048bc8a0b8cdd046402e1b3de1b77b971254]) [#209 not unique table alias error] fix for error, still needs more unit tests. Also the group dropdowns produce invalid combinations http://github.com/vegantech/sims...

    March 26th, 2009 @ 04:40 PM

  7. shawn (at vegantech)
    shawn (at vegantech)
    • State changed from new to resolved

    (from [0a378bbe41dfe65cadc3e8c39f6896c51a86c822]) Added specs and fixed feature [#209 not unique table alias error state:resolved] http://github.com/vegantech/sims...

    March 26th, 2009 @ 04:40 PM

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.