I am trying to create a wordpress data table with a serialized php array and after I put in the file url and click save it gives me this error: SSL certificate problem: unable to get local issuer certificate. The file url is correct and the file is submitting the right results but no matter what I try I cannot get it to work. I have it working on my local so I pushed the files to the development site and now when I try to make the table on the dev site it won't let me.

I already have the carcert.pem and those lines in the php.ini file. The data tables work fine when I do a sql query table but the PHP serialized array and the JSON file options both give that error right when I click save.

It is definitely something to do with curl. I am not very familiar with it. So the file I use for the data table just echos a serialized array. How would I make that go through curl?

Yes. I did try that. That did not work either.

Adding this to functions.php fixed it for me:

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);