Ticket #677 (new defect)
Opened 3 years ago
Admin Part: Affiliates problem
| Reported by: | IgorL | Owned by: | somebody |
|---|---|---|---|
| Priority: | major | Milestone: | Dolphin 6.1.7 |
| Keywords: | Cc: |
Description
when you are in the admin panel and click on users->affiliates ... and there I click on the memb # then I get the following database error:...
Query: SELECT Profiles.ID as ID, NickName, Email, Sex, DATE_FORMAT(DateLastLogin, '%m-%d-%y %H:%i' ) AS DateLastLoginCur, DATE_FORMAT(DateReg, '%m-%d-%y %H:%i' ) AS DateReg, Status , IDLevel, IF(ISNULL(MemLevels.Name),, MemLevels.Name) AS MemName FROM Profiles ,aff_members LEFT JOIN ProfileMemLevels ON ProfileMemLevels.IDMember = Profiles.ID LEFT JOIN MemLevels ON ProfileMemLevels.IDLevel = MemLevels.ID WHERE 1 AND idAff = '2' AND idProfile = Profiles.ID AND (Couple=0 OR Couple>Profiles.ID) GROUP BY Profiles.ID ORDER BY DateLastLogin? LIMIT 0, 30 Mysql error: Unknown column 'Profiles.ID' in 'on clause'
