At this point I consider this a low-priority report as it is not limiting my progress or use of wpdatatables at this point.
Purchased and installed wpdatatables v2.0.1 on Aug 12, 2017 into WordPress v4.8.1
Have been able to create and manage tables.
Am not able to use/view the Setting page. Upon selecting Settings menu from WP menu on left, the page is displayed (greyed) and circling donut cursor is displayed. Have waited 5+ minutes, the cursor never disappears.
Am able to navigate to other pages without errors.
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.
We require minimum 5.4 version but as I know some version of 5.6 have some issues. So looking at your configuration I think the best solution will be to update to 7.0.
Upon your request to upgrade PHP from v5.x to v7.x, I have installed a new OS, Apache2, MySQL, PHP and WordPress. The problem still exists. However, we have solved the issue. For those encountering the same, read on...
New machine: OS: Debian 9 (Stretch) PHP: 7.0.19-1 (cli) (built: May 11 2017 14:04:47)
Apache2 Error Log: [1]
Did some research and found the error being logged was related to CURL. There are many known issues related to this problem. [2]
According to the Apache2 error log, we had an exception at line 103 of /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/tabs/info.php.
Reviewing the file we can see CURL is not being found.
Installing curl and restarting Apache2 using the following fixed the problem sudo apt-get install php-curl sudo service apache2 restart
The following article was helpful installing CURL [3]
References:
[1] [Thu Aug 17 01:33:55.216451 2017] [core:notice] [pid 23114] AH00094: Command line: '/usr/sbin/apache2' [Thu Aug 17 01:34:17.406489 2017] [mpm_prefork:notice] [pid 23114] AH00169: caught SIGTERM, shutting down [Thu Aug 17 01:34:17.499535 2017] [mpm_prefork:notice] [pid 23374] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations [Thu Aug 17 01:34:17.499604 2017] [core:notice] [pid 23374] AH00094: Command line: '/usr/sbin/apache2' [Thu Aug 17 13:47:18.139526 2017] [:error] [pid 23375] [client 24.207.44.104:51304] WordPress database error Unknown column 'wp_' in 'field list' for query SELECT wp_, referer: http://45.33.51.141/wp-admin/setup-config.php?step=1&language=en_CA sh: 1: /usr/sbin/sendmail: not found [Thu Aug 17 14:26:00.399448 2017] [:error] [pid 29003] [client 24.207.44.104:51528] PHP Fatal error: Uncaught Error: Call to undefined function curl_version() in /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/tabs/info.php:103\nStack trace:\n#0 /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/settings.inc.php(84): include()\n#1 /var/www/html/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(460): include('/var/www/html/w...')\n#2 /var/www/html/wp-includes/class-wp-hook.php(298): wdtSettings('')\n#3 /var/www/html/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters('', Array)\n#4 /var/www/html/wp-includes/plugin.php(453): WP_Hook->do_action(Array)\n#5 /var/www/html/wp-admin/admin.php(222): do_action('wpdatatables_pa...')\n#6 {main}\n thrown in /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/tabs/info.php on line 103, referer: http://45.33.51.141/wp-admin/admin.php?page=wpdatatables-administration
At this point I consider this a low-priority report as it is not limiting my progress or use of wpdatatables at this point.
Purchased and installed wpdatatables v2.0.1 on Aug 12, 2017 into WordPress v4.8.1
Have been able to create and manage tables.
Am not able to use/view the Setting page. Upon selecting Settings menu from WP menu on left, the page is displayed (greyed) and circling donut cursor is displayed. Have waited 5+ minutes, the cursor never disappears.
Am able to navigate to other pages without errors.
Hi robchur,
Thank you for your purchase.
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.
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 Rob,
I can see the issue, very strange.
Can you please tell me which version of PHP do you use and if you can check your server log and see if there are some issues.
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 Rob,
Can you please tell me if it is possible for you to update the PHP version to latest.
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 Rob,
We require minimum 5.4 version but as I know some version of 5.6 have some issues.
So looking at your configuration I think the best solution will be to update to 7.0.
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 Rob,
No need to worry, ticksy will automatically close tickets which are older then 7 days but you can re open it any time.
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
Upon your request to upgrade PHP from v5.x to v7.x, I have installed a new OS, Apache2, MySQL, PHP and WordPress. The problem still exists. However, we have solved the issue. For those encountering the same, read on...
New machine:
OS: Debian 9 (Stretch)
PHP: 7.0.19-1 (cli) (built: May 11 2017 14:04:47)
Apache2 Error Log: [1]
Did some research and found the error being logged was related to CURL. There are many known issues related to this problem. [2]
According to the Apache2 error log, we had an exception at line 103 of /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/tabs/info.php.
Reviewing the file we can see CURL is not being found.
Installing curl and restarting Apache2 using the following fixed the problem
sudo apt-get install php-curl
sudo service apache2 restart
The following article was helpful installing CURL [3]
References:
[1]
[Thu Aug 17 01:33:55.216451 2017] [core:notice] [pid 23114] AH00094: Command line: '/usr/sbin/apache2'
[Thu Aug 17 01:34:17.406489 2017] [mpm_prefork:notice] [pid 23114] AH00169: caught SIGTERM, shutting down
[Thu Aug 17 01:34:17.499535 2017] [mpm_prefork:notice] [pid 23374] AH00163: Apache/2.4.25 (Debian) configured -- resuming normal operations
[Thu Aug 17 01:34:17.499604 2017] [core:notice] [pid 23374] AH00094: Command line: '/usr/sbin/apache2'
[Thu Aug 17 13:47:18.139526 2017] [:error] [pid 23375] [client 24.207.44.104:51304] WordPress database error Unknown column 'wp_' in 'field list' for query SELECT wp_, referer: http://45.33.51.141/wp-admin/setup-config.php?step=1&language=en_CA
sh: 1: /usr/sbin/sendmail: not found
[Thu Aug 17 14:26:00.399448 2017] [:error] [pid 29003] [client 24.207.44.104:51528] PHP Fatal error: Uncaught Error: Call to undefined function curl_version() in /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/tabs/info.php:103\nStack trace:\n#0 /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/settings.inc.php(84): include()\n#1 /var/www/html/wp-content/plugins/wpdatatables/controllers/wdt_admin.php(460): include('/var/www/html/w...')\n#2 /var/www/html/wp-includes/class-wp-hook.php(298): wdtSettings('')\n#3 /var/www/html/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters('', Array)\n#4 /var/www/html/wp-includes/plugin.php(453): WP_Hook->do_action(Array)\n#5 /var/www/html/wp-admin/admin.php(222): do_action('wpdatatables_pa...')\n#6 {main}\n thrown in /var/www/html/wp-content/plugins/wpdatatables/templates/admin/settings/tabs/info.php on line 103, referer: http://45.33.51.141/wp-admin/admin.php?page=wpdatatables-administration
[2]
https://stackoverflow.com/questions/45001345/call-to-undefined-function-curl-version
[3]
https://stackoverflow.com/questions/33775897/how-do-i-install-the-ext-curl-extension-with-php-7/35035211#35035211
Hi Rob,
Thank you for sharing the solution with us, we really appreciate it.
I will also noted this so we can test it 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