Hi, Viktor 

Thanks for reaching out to us

Please note : The format of the serialized array should be the following: 2D-array, where the parent level is an indexed array, and the second level is an associative array. Parent array entries will be parsed as rows, child array keys will be parsed as column headers, and child array values as cell values.

-

Can you please check did you follow all the instructions explained here, with an example on how to use PhP serialized data with our plugin?

-

This is strange. When i try to link a table as PhP array, and i use your link ,  a  table gets created and i have no errors on my screen :

I use this as source : https://www.makpetrol.com.mk/wp-content/uploads/2022/08/istorija_na_ceni.php

Maybe i should look at your WP-Admin, to see if i can isolate the issue for you.

Please provide me a temporary WP-admin (administrator) user 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 parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Hi, Viktor 

Sincere apologies for all the waiting time.

Yes, this is quite odd - If i try to link the PhP array to my local Test site,  it works with no errors;

but if i try to link it on our Demo site;  i got the same error as you : Peer's Certificate issuer is not recognized.

Here is my screen recording, just to see how it looks from my end - if you wish.  You can see the difference when i try our Demo site ( with the same error),  and when i try my localhost, without the error.

https://we.tl/t-3e6sRdvFYo

I will urgently ask our 2nd level Team for help -  i am confident they will know what the issue is.

I am guessing that something needs to be modified in the code, or some kind of permission somewhere - since i am able to create a table on my local site without the issue.

-

I will report back as soon as they respond.

Hi, Viktor 

I still don't have the final confirmation from the senior colleagues - i did research a bit on my own in the meantime;

it seems that this has to do with a specific SSL configuration for a certificate, or something like that, that is blocking the linking of the source data - i am honestly not sure what exactly

-

I have a couple ideas, when i compare everything between our Demo and my localhost site - is that i did this small modification to allow unfiltered uploads to the server.

I am not sure if this might help - but you can certainly try (it won't do any harm).

Can you please add the following line to your wp-config.php file:
define( 'ALLOW_UNFILTERED_UPLOADS', true );

-

If that does not help;  i found another case where a user reported being unable to connect a Google Spreadsheet, 

he had another error, though,  about an SSL certificate, but it is worth a shot to try this, as well :

Adding this to functions.php fixed it for that user  ( you can add it to functions.php of your theme or child theme):

function filterCURLOptions($data, $ch, $url){      
      curl_close($ch);      
      $new_ch = curl_init();   
         $timeout = 5;     
       $agent = 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0';   
         curl_setopt($new_ch, CURLOPT_URL, $url);      
      curl_setopt($new_ch, CURLOPT_RETURNTRANSFER, 1);     
       curl_setopt($new_ch, CURLOPT_SSL_VERIFYHOST, false);      
      curl_setopt($new_ch, CURLOPT_SSL_VERIFYPEER, false);       
     curl_setopt($new_ch, CURLOPT_CONNECTTIMEOUT, $timeout);     
       curl_setopt($new_ch, CURLOPT_USERAGENT, $agent);         
   curl_setopt($new_ch, CURLOPT_REFERER, site_url());      
      curl_setopt($new_ch, CURLOPT_FOLLOWLOCATION, true);  
          $data = curl_exec($new_ch);           
     if (curl_error($new_ch)) {                
        $error = curl_error($new_ch);      
                  curl_close($new_ch);     
                   wp_die($error);        
        }      
          if (strpos($data, '')) {        
               wp_die(__('wpDataTables was unable to read your Google Spreadsheet, probably it is not published correctly.  You can publish it by going to File -> Publish to the web ', 'wpdatatables'));       
         }             
   $info = curl_getinfo($new_ch);      
          curl_close($new_ch);        
        if ($info['http_code'] === 404) {
        return NULL;         
       }       
    return $data;
}
add_filter('wpdatatables_curl_get_data','filterCURLOptions', 10, 3);

Please let me know if that perhaps solves the issue, and if you're now able to connect this PHP Array to your wpDataTable : https://www.makpetrol.com.mk/wp-content/uploads/2022/08/istorija_na_ceni.php

-

In the meantime, i will check if senior Team has additional advise. Thank you

Hello Viktor.

Milos is on a vacation, so I'll jump in.

This seems to be an issue with the security certificate. Can you take a look at this thread on Stack Overflow?

Basically, this usually indicates that an SSL certificate expired, I'm just surprised it happens on our demo also, so I'll check it with our developers.

Pozdrav Ivane,

Greska koju ste poslali je prikazana od strane naseg Plugina, ali ukazuje na to da izvor problema dolazi od negde drugde.

Moze biti vise stvari;

Ako postoji neko specificno formatiranje podataka na vasem source Sheet-u;

Ili ako mozda imate SSL problem.

Najbolje ce biti da otvorite nov privatni tiket gde mi mozete poslati pristup na Sheet za moj Email [email protected], onda mozemo mi pokusati da napravimo tabelu s nase strane i ispitamo izvor problema.

Recite nam da li to zvuci ok.

Hvala.

Pozdrav Ivane,

Drago mi je sto vidim da ste uspeli da resite problem.

Da, s vremena na vreme se desava da Google promeni neki korak ili naziv opcije.

Provericemo uskoro da li treba i mi da izmenimo neke korake sa nase Dokumentacije sto se tice toga.

Ako nesto novo iskrsne, molim vas nemojte se ustrucavati da otvorite nov tiket.

Hvala.