related tables not counting records correctly.

[skyrun]

see http://www.skyrun.com/skyforce/leads

in the db, there are:
3 activities for lead 1
2 for lead 2
2 for lead 3

however the 'activities' column says all 7 are in the first lead... click it though and it correctly shows just the 3 from lead 1. so the link is correct, however the text is wrong.

ALSO, when you ADD an activity, the id on the new activity is null.

 

[rob]

hard to check as list id 4 is giving me an sql error now, is that something you are working on?

 

[rob]

ok should be fixed on your site and in github -there was a missing $query->group() line which mean the count results were not grouped for each of the list's rows.