There was an error getting the member details in f_GetPeopleList. The reported error message is: Failed at step selectdb::192.168.1.2::mak_prod::mak_proddy::fr3ddy with the message Access denied for user ''@'localhost' to database 'mak_prod'
The query is
SELECT mi.member_info_uid, IFNULL(mi.location_uid, 0) AS location_uid, mi.gender, mi.online_name, mi.membership_type_uid,IFNULL(UNIX_TIMESTAMP(mi.last_updated),-1) AS info_altered,CASE mi.gender WHEN 'M' THEN 'Male' WHEN 'F' THEN 'Female' ELSE 'Gender free' END AS gender_word,language_setting, UNIX_TIMESTAMP(last_updated) AS unix_last_updated, UNIX_TIMESTAMP(registration_date) AS unix_registration_date, 0 AS has_note, mst.name AS membership_type_name, mi.first_name AS first_name, mi.dob AS dob, mi.display_age AS display_age, mi.starsign AS starsign,IF(mi.member_weight_uid=1,'',mwt.weight_band) AS weight,IF(mi.member_height_uid=1,'',mht.height_band) AS height,'' AS current_job, IFNULL(mi.annual_income, 0) AS annual_income,mi.children, cchld.description AS children_word,'' AS about_me_full,'' AS about_me_one_line,mi.sexual_preference_uid, sp.name AS sexual_preference, mi.display_name AS InDisplayNameFlag,DATE_FORMAT(registration_date,'%d-%b-%Y %I:%i %p') AS registration_date,IFNULL(DATE_FORMAT(mi.last_updated, '%d-%b-%Y %I:%i %p'),'') AS nice_last_updated,TRUNCATE(PERIOD_DIFF(DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL DAYOFYEAR(mi.fuzzy_dob) DAY), '%Y%m'), DATE_FORMAT(DATE_SUB(mi.fuzzy_dob, INTERVAL DAYOFYEAR(mi.fuzzy_dob) DAY), '%Y%m'))/12, 0) AS age,mi.want_children, wchld.description AS want_children_word,mi.smoking, smk.description AS smoking_word,mi.drinking, drnk.description AS drinking_word,IFNULL(mi.looking_for_full,'') AS looking_for_full,IFNULL(mi.looking_for_full,'') AS looking_for,mi.default_photo AS default_photo,hair_li.list_order AS hair, hair_li.description AS nice_hair_colour,eye_li.list_order AS eye, eye_li.description AS nice_eye_colour,rela_li.list_order AS relationship, rela_li.description AS nice_relationship_status FROM member_info mi, membership_type mst ,member_weight mwt,member_height mht, list_data cchld,list_data sp, list_data wchld, list_data smk, list_data drnk, list_data hair_li, list_data eye_li, list_data rela_li WHERE mi.member_info_uid=490 AND mwt.member_weight_uid=mi.member_weight_uid AND mht.member_height_uid=mi.member_height_uid AND cchld.list_order=mi.children AND cchld.list_type='CHILD_CNT' AND sp.list_order=mi.sexual_preference_uid AND sp.list_type='SEX_PREF' AND wchld.list_order=mi.want_children AND wchld.list_type='WANT_CHILD' AND smk.list_order=mi.smoking AND smk.list_type='SMOKING' AND drnk.list_order=mi.drinking AND drnk.list_type='DRINKING' AND hair_li.list_uid=mi.hair_colour AND eye_li.list_uid=mi.eye_colour AND rela_li.list_uid=mi.relationship_uid AND mst.membership_type_uid=mi.membership_type_uid