Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

JSON formatting error
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: JSON formatting error
#58606
JSON formatting error 1 Year, 1 Month ago Karma: 0
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
The administrator has disabled public write access.
 
#58607
Re:JSON formatting error 1 Year, 1 Month ago Karma: 667
Hello,

Is it possible to see the problem?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58608
Re:JSON formatting error 1 Year, 1 Month ago Karma: 0
Hi,

I just sent temporary admin credentials to info@ari-soft.com. Go to www.lakepointehomeowners.com and, once logged in, go to the "Directory" menu option.

Cheers,
Jay
The administrator has disabled public write access.
 
#58609
Re:JSON formatting error 1 Year, 1 Month ago Karma: 667
Download and upgrade the module to v. 1.15.11. It should help.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58610
Re:JSON formatting error 1 Year, 1 Month ago Karma: 0
Hi, that fixed it! Thank you so much for the prompt support!!

Best,
Jay
The administrator has disabled public write access.
 
#58615
Re:JSON formatting error 1 Year ago Karma: 0
Hi,

The directory is displaying and sorting correctly, but I just discovered that the search box is not working when I type in text.

Jay
The administrator has disabled public write access.
 
Go to topPage: 12