Okay
  Public Ticket #1074402
JSON Problem
Closed

Comments

  •  2
    Frank started the conversation

    Hi 
    I'm formatting one column as a URL and another as email. I get the JSON error. When running the FF development tools and trace the error, it looks like it is trying to escape the forward slashes in the JSLint console. Here is the result:

    {
        "draw": 1,
        "recordsTotal": "336",
        "recordsFiltered": "336",
        "data": [
                ["2", "Caloosa River Boat Rentals", "Cape Coral", "(239) 691-4099", "http:\/\/www.caloosaboatrental.com<\/a>", "[email protected]<\/a>"],["3","Gulf Coast Kayaks","Matlacha","(239) 283-1125","
                    target = '_blank' > http: \/\/gulfcoastkayak.com<\/a>","<\/a>"],["4","Ms.B.Haven Fishing & Eco Charters","Naples","(239) 825-4292","http:\/\/www.fishinnaples.com<\/a>"," href='mailto:'><\/a>"],["5","Priority 1 Charters","Naples","(239) 825-4418","www.cruisefishdive.com<\/a>"," href="/cdn-cgi/l/email-protection#f39d92839f96809e92819a9d92b39081869a8096959a809b979a8596dd909c9e">[email protected]<\/a>"],["12","Captain Bob's Sunrise Charters","Cape Coral","(239) 945-3098","-1&&m>28){j=28+s;s='                target = '_blank' > http: \/\/gulfcoastkayak.com<\/a>","<a href='mailto:'><\/a>"],["4","Ms.B.Haven Fishing & Eco Charters","Naples","(239) 825-4292","<a href='http:\/\/www.fishinnaples.com' target='_blank'>http:\/\/www.fishinnaples.com<\/a>","<a href='mailto:'><\/a>"],["5","Priority 1 Charters","Naples","(239) 825-4418","<a href='http:\/\/priority1charters.com' target='_blank'>http:\/\/priority1charters.com<\/a>","<a href='mailto:'><\/a>"],["6","West Coast Fishing Charters","Cape Coral","(239) 283-9340","<a href='http:\/\/westcoastfishingcharters.com' target='_blank'>http:\/\/westcoastfishingcharters.com<\/a>","<a href='mailto:'><\/a>"],["7","Back On The Water","Fort Myers","(239) 267-1185","<a href='' target='_blank'><\/a>","<a href='mailto:'><\/a>"],["8","Segway Adventures","Naples","(239) 601-7529","<a href='http:\/\/extremefamilyfunspot.com' target='_blank'>http:\/\/extremefamilyfunspot.com<\/a>","<a href='mailto:'><\/a>"],["10","Captain Ivan Garza Fishing Charter","Naples","(239) 537-1643","<a href='http:\/\/captainivangarza.com' target='_blank'>http:\/\/captainivangarza.com<\/a>","<a href='mailto:'><\/a>"],["11","Naples Marina And Excursions","Naples","(239) 431-8831","<a href='http:\/\/www.cruisefishdive.com' target='_blank'>http:\/\/www.cruisefishdive.com<\/a>","<a href="/cdn-cgi/l/email-protection#f39d92839f96809e92819a9d92b39081869a8096959a809b979a8596dd909c9e">[email protected]<\/a>"],["12","Captain Bob's Sunrise Charters","Cape Coral","(239) 945-3098","<a href='http:\/\/fishftmyers.com' target='_blank'>http:\/\/fishftmyers.com<\/a>","<a href="/cdn-cgi/l/email-protection#5f283a3d323e2c2b3a2d1f3b302b3e31262b37363138713c3032">[email protected]<\/a>"]]}<script>/ * < ![CDATA[ * /(function(d,s,a,i,j,r,l,m,t){try{l=d.getElementsByTagName('a');t=d.createElement('textarea');for(i=0;l.length-i;i++){try{a=l[i].href;s=a.indexOf('/cdn - cgi / l / email - protection ');m=a.length;if(a&&s>-1&&m>28){j=28+s;s='
                            ';if(j<m){r='
                            0x '+a.substr(j,2)|0;for(j+=2;j<m&&a.charAt(j)!='
                            X ';j+=2)s+=' % '+('
                            0 '+('
                            0x '+a.substr(j,2)^r).toString(16)).slice(-2);j++;s=decodeURIComponent(s)+a.substr(j,m-j)}t.innerHTML=s.replace(/</g,' & lt;
                            ').replace(/\>/g,' & gt;
                            ');l[i].href='
                            mailto: '+t.value}}catch(e){}}}catch(e){}})(document);/* ]]> */</script>

    And the error:
    Error: Parse error on line 6:
    ...m<\/a>", "

    When I change the column type to text it works fine.
    Any suggestions?

    Thanks,

    Frank

  •  1,771
    Miloš replied

    Hi Frank,
    Thank you for your purchase and sorry for late response we had a lot of tasks and testing for 1.7.2 version.

    Can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Also can you tell me how did you make a table and from which file?
    Can you just send me that file so I can take a look and investigate it.
    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables