Hello Gibbon Support!
I recently ran a Whole School Mailing List in Query Builder and discovered an unusual anomaly. There were two students in my system with two entries on the returned query. Both students have a complete record (with all personal information and family attachments) and a record that only contains their name. When I search my list of users, though (in User Admin or student profiles), I only see one entry for each student.
Is there a way for me to clear this up? I believe the error came about from an extra user profile that got created through the application process and deleted improperly, but I’m only guessing. It’s not causing a problem right now, but I’m concerned that something will get messed up down the road.
Thank you as always for the help!
Hi Kevin, it does sound like some possible orphaned records in your database. But, in a query, it’s easy to end up with duplicates listed based on how table joins work, even if there is really only one copy of the record. So, to find the cause you’d need to do a bit of database investigation. One way to do this is to modify the query so that it includes the gibbonPersonID column, as this would tell you if there is truly more than one user record. If there isn’t, you could then check that gibbonPersonID on tables like gibbonStudentEnrolment, to see if there is perhaps a duplicate there. Hope this helps!
This was helpful, Sandra–thank you as always.
I was able to confirm that both students showing up twice in my query each have a single gibbonPersonID, so good news there. I was also able to pull them up and isolate their records on the table gibbonStudentEnrolment, but I didn’t see anything that would explain the two records in the query. The student who had been enrolled in our programs for two years had two entries for gibbonStudentEnrolmentID, while the student who was new only had one entry. Nothing else about the data in the table seemed off to me, but I will admit it gets a little confusing at times.
What other tables should I check? (You mentioned tables like gibbonStudentEnrolment, but I’m not sure which others to explore.) If I find something that’s off, how do I decide what to delete so I don’t break the database further?
Making it happen!