When I click on Apply i get the following error message: "error setting certificate verify locations: CAfile: c:\cgi\php56\curl-ca-bundle.crt CApath: none"
I was able to create a table with your spreadsheet. ( attachment)
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.
The issue probably because that curl expected the certificate to be at the path /etc/ssl/certs/ but could not find it because it is on different path or does not exist.
My suggestion is to contact your hosting provider to tell you where this certificate is located on server.
So if I understand you correctly the plugin will not function correctly without having a SSL certificate? What about on my localhost for developmental testing?
Yes it works! But I still need assistance! I tested it on localhost and it works,
I tested in my staging environment (new.sir98.org) and it worked,
I tested it in my production environment (sir98.org) and I got the following errors:
PHP Warning: Invalid argument supplied for foreach() in D:\Hosting\7512859\html\SIRs98org\new\wp-content\plugins\wpdatatables\templates\admin\table-settings\add_column_modal.inc.php on line 72
PHP Warning: Invalid argument supplied for foreach() in D:\Hosting\7512859\html\SIRs98org\new\wp-content\plugins\wpdatatables\templates\admin\table-settings\remove_column_modal.inc.php on line 40
Same errors I reported in ticket # #1314683 and described in my private reply to you.
I then went back to my staging environment and changed wp-config.php to the following:
// Enable WP_DEBUG mode define( 'WP_DEBUG', false );
// Enable Debug logging to the /wp-content/debug.log file define( 'WP_DEBUG_LOG', flase );
and received the same errors as on my production environment. I went back to my production environment and set wp-config.php as follows:
// Enable WP_DEBUG mode
define( 'WP_DEBUG', true );
// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );
and everything works.
Bottom line, I can't run my site with debug enabled. So I need to figure out how to fix this.
Thanks for getting us much further along. Hope we can get all the way!
Yes I see the wpdatatables support table that you created. And yes I was able to recreate that same test table. I did not see the PHP warnings. What did you change to eliminate the PHP warnings as I need to do that on my production site as well!
Thank you. I applied the fixes to my production environment and all tests out correctly. Will TMS be issuing a plugin update with these fixes? If not how do I prevent them from being overwritten, if and when, TMS issues a plugin update?
I forwarded this to my team and I hope that it will be included in the upcoming release.
Just made a backup of that files and if the changes are lost you can follow the guide that I gave you below, but like I said I will emphasize to add this fix for the next version. Unfortunately I can not tell you precisely the date of the release but we are working on it.
You are welcome.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Unable to build a table from an existing Googlesheets document using
Create a table linked to an existing data source .
.
I followed the instructions at:
https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/
When I click on Apply i get the following error message: "error setting certificate verify locations: CAfile: c:\cgi\php56\curl-ca-bundle.crt CApath: none"
Googlesheets link is: https://docs.google.com/spreadsheets/d/1bZMBZLYNOdT_vV223DOGufbe2zG2Abz5P7uZY-6it9I/edit#gid=0 and copy of the publish to web screenshot is attached.
If I try to create the table using:
Create a table by importing data from data source .
I end up getting the following error message:
"There was an error while trying to generate the table! Internal Server Error"
Three different URLs for the same document. Each opens and displays the document correctly within Google Chrome browser:
https://docs.google.com/spreadsheets/d/1bZMBZLYNOdT_vV223DOGufbe2zG2Abz5P7uZY-6it9I/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1bZMBZLYNOdT_vV223DOGufbe2zG2Abz5P7uZY-6it9I/edit#gid=0
https://docs.google.com/spreadsheets/d/e/2PACX-1vSQ6HHI7OVrAglgCAKCrvwvyo3MKdjhpDtNQfuj5fp9bnOwvcrCOV6KT5GlCl_I5_9NGrfWCed110WQ/pubhtml
Any help is appreciated,
Pete M.
Hi Pete,
Thank you for your purchase.
I was able to create a table with your spreadsheet. ( attachment)
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.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi Peter
The issue probably because that curl expected the certificate to be at the path
/etc/ssl/certs/
but could not find it because it is on different path or does not exist.My suggestion is to contact your hosting provider to tell you where this certificate is located on server.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
So if I understand you correctly the plugin will not function correctly without having a SSL certificate? What about on my localhost for developmental testing?
Hi Peter
The SSL certificate is necessary for connection with https , it can be overwritten with few line of codes.
In local host it should be working because SSL is not included there.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Hi Bogdan,
Sorry but in local host I get a similar error:
Error
SSL certificate problem: unable to get local issuer certificate
CLOSE
What lines of code do I need to overwrite and where?
Hi Peter,
Can you please tell me which OS are you running.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
See attached for System info.
Hi Peter,
Can you please check now.
I added this line of code
in file ../wp-content/plugins/wpdatatables/source/class.wdttools.php around line 145
You will be able to see that code.
Also please tell me does the Spreadsheet upload is working for you because I tested it and it is working.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Bogdan,
Yes it works! But I still need assistance! I tested it on localhost and it works,
I tested in my staging environment (new.sir98.org) and it worked,
I tested it in my production environment (sir98.org) and I got the following errors:
Same errors I reported in ticket # #1314683 and described in my private reply to you.
I then went back to my staging environment and changed wp-config.php to the following:
and received the same errors as on my production environment. I went back to my production environment and set wp-config.php as follows:
and everything works.
Bottom line, I can't run my site with debug enabled. So I need to figure out how to fix this.
Thanks for getting us much further along. Hope we can get all the way!
Regards,
Pete
Hi Peter,
Can you please check now and tell me do you see the wpdatatables support table that I created on your site.
Also tell me do you still see that PHP warnings.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Bogdan,
Yes I see the wpdatatables support table that you created. And yes I was able to recreate that same test table. I did not see the PHP warnings. What did you change to eliminate the PHP warnings as I need to do that on my production site as well!
Thanks for all your good work!
Pete
Hi Peter,
First in file
../wp-content/plugins/wpdatatables/templates/admin/table-settings/add_column_modal.inc.php i found this line of code
and I added some changes to look like this
Then in file
../wp-content/plugins/wpdatatables/templates/admin/table-settings/remove_column_modal.inc.php I found this line of code
and change it to look like this
I just added IF condition in both of those files which gave you a warnings. ( attachments)
Hope this can help you out.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Bogdan,
Thank you. I applied the fixes to my production environment and all tests out correctly. Will TMS be issuing a plugin update with these fixes? If not how do I prevent them from being overwritten, if and when, TMS issues a plugin update?
Thanks again,
Pete
Hi Peter,
Glad that we solved the issue.
I forwarded this to my team and I hope that it will be included in the upcoming release.
Just made a backup of that files and if the changes are lost you can follow the guide that I gave you below, but like I said I will emphasize to add this fix for the next version.
Unfortunately I can not tell you precisely the date of the release but we are working on it.
You are welcome.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Bogdan,
Thank You again. TMS provided great service.
Pete
Hi Pete,
The pleasure is all mine.
You are welcome.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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