The printable page option for individuals does NOT work...
it comes back with the following error, which appears
something in the SQL is broken...
Cannot execute query.
SELECT a.*, family_fam.*, cls.lst_OptionName AS
sClassName, fmr.lst_OptionName AS sFamRole,
b.per_FirstName AS EnteredFirstName, b.Per_LastName AS
EnteredLastName, c.per_FirstName AS EditedFirstName,
c.per_LastName AS EditedLastName FROM person_per a LEFT
JOIN family_fam ON a.per_fam_ID = family_fam.fam_ID
LEFT JOIN list_lst cls ON a.per_cls_ID =
cls.lst_OptionID AND cls.lst_ID = 1 LEFT JOIN list_lst
fmr ON a.per_fmr_ID = fmr.lst_OptionID AND fmr.lst_ID =
2 LEFT JOIN person_per b ON a.per_EnteredBy = b.per_ID
LEFT JOIN person_per c ON a.per_EditedBy = c.per_ID
WHERE a.per_ID = 211 AND person_per.chu_Church_ID=1
Unknown table 'person_per' in where clause
Thanks,
Dan
Dan.Creed@thecreeds.net
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The printable page option for individuals does NOT work...
it comes back with the following error, which appears
something in the SQL is broken...
Cannot execute query.
SELECT a.*, family_fam.*, cls.lst_OptionName AS
sClassName, fmr.lst_OptionName AS sFamRole,
b.per_FirstName AS EnteredFirstName, b.Per_LastName AS
EnteredLastName, c.per_FirstName AS EditedFirstName,
c.per_LastName AS EditedLastName FROM person_per a LEFT
JOIN family_fam ON a.per_fam_ID = family_fam.fam_ID
LEFT JOIN list_lst cls ON a.per_cls_ID =
cls.lst_OptionID AND cls.lst_ID = 1 LEFT JOIN list_lst
fmr ON a.per_fmr_ID = fmr.lst_OptionID AND fmr.lst_ID =
2 LEFT JOIN person_per b ON a.per_EnteredBy = b.per_ID
LEFT JOIN person_per c ON a.per_EditedBy = c.per_ID
WHERE a.per_ID = 211 AND person_per.chu_Church_ID=1
Unknown table 'person_per' in where clause
Thanks,
Dan
Dan.Creed@thecreeds.net
Dan,
Was this from the demo site on churchledger.com or from the downloaded code? I'm having problems getting this bug to recur.
Thanks,
Steve