I've been using the following query which you wrote for us several years ago:
| Code: |
SELECT
TRIM(BOTH '"' FROM ADDR1.profile_value) AS Address1,
TRIM(BOTH '"' FROM DNAME.profile_value) AS Dname,
TRIM(BOTH '"' FROM ADDR2.profile_value) AS Address2,
TRIM(BOTH '"' FROM PHONE.profile_value) AS Phone,
TRIM(BOTH '"' FROM DEMAIL.profile_value) AS Demail
FROM
#__users U LEFT JOIN #__user_profiles ADDR1
ON U.id = ADDR1.user_id AND ADDR1.profile_key = 'profile.address1'
LEFT JOIN #__user_profiles DNAME
ON U.id = DNAME.user_id AND DNAME.profile_key = 'profile.dname'
LEFT JOIN #__user_profiles ADDR2
ON U.id = ADDR2.user_id AND ADDR2.profile_key = 'profile.address2'
LEFT JOIN #__user_profiles PHONE
ON U.id = PHONE.user_id AND PHONE.profile_key = 'profile.phone'
LEFT JOIN #__user_profiles DEMAIL
ON U.id = DEMAIL.user_id AND DEMAIL.profile_key = 'profile.demail'
|
But at some point in the past two weeks it has stopped working and the page now displays this warning:
"DataTables warning (table id = 'at_92'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error."
Joomla 3.6.2
Ari Data Tables 1.15.10
