I'm liking your plugin...not loving it yet. I need your help...when using Generate a query to the MySQL database and completing the wizard, I'm either getting a white screen with a circling color "O" or an error: Column 'pos' cannot be null.
I've used the query wizards sql queries and I have used mysql queries generated from phpmyadmin all of which generate usable results.
I've created databases both inside and outside of the WP database. All query results are the same....good for phpMyadmin but not for WPDT data source SQL query.
Do you have any tips or insight on what's going on?
Pls advise. tobin shepherd
Here's my system data:
WordPress Environment
Home URL:
Site URL:
WP Content Path:
/home/public_html/cms/wp-content
WP Path:
/home/public_html/cms/
WP Version:
6.7
WP Multisite:
No
PHP Memory Limit:
256 MB
WP Debug Mode:
Inactive
Language:
en_US
Server Environment
Operating System:
Linux
Server Info:
Apache
PHP Version:
8.1.30
PHP Post Max Size:
128 MB
PHP Time Limit:
180
MySQL Version:
8.0.40
Max Upload Size:
64 MB
Multibyte String:
>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="Multibyte String (mbstring) is used to convert character encoding.">
XML extension:
>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="XML support is something that needs to be installed on the server for proper wpDataTables functionality.">
DOM extension:
>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="DOM support is something that needs to be installed on the server for proper wpDataTables functionality.">
Libxml extension:
>span class="wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="Multibyte String (mbstring) require libxml to be installed. ">
PDO extension:
- PDO Drivers: mysql, sqlite
>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="PDO is used to connect to separate database connection like MS SQL and PostgreSQL.">
Zip extension:
>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="ZIP support is something that needs to be installed on the server, as a package for the Linux operating system, or rather to the PHP software on the server.">
Curl extension:
>span class=" wpdt-icon-info-circle-thin" data-toggle="tooltip" data-placement="left" title="" data-original-title="wpDataTables use cURL for getting data from other servers.">
MIlos, thanks for your reply. It's not a simple query to 1 table of the database; rather its a simple query of a relational tables in the database. There are only 250 rows in the membership table.
SELECT `members_year_paid`.`yearpaid`, `ncehsamembership`.`name`, `ncehsamembership`.`emailaddress`, `ncehsamembership`.`district`, `ncehsamembership`.`county`, `ncehsamembership`.`active1` FROM `members_year_paid` LEFT JOIN `ncehsamembership` ON `members_year_paid`.`wdt_ID` = `ncehsamembership`.`wdt_ID`;
I tried the disable server side processing. I received the error: Error Column 'pos' cannot be null
After watching the mySQL view video, it appears I need to create views in mySQL and then call them from WPDT.
When modifying the query I still get the error message: Column 'pos' cannot be null. So the suggestion is a good idea but it does not work.
I need this relational query to update both tables. In your expertise, can creating views in a mySQL database to use with your plugin accomplish editable relational queries?
I'm liking your plugin...not loving it yet. I need your help...when using Generate a query to the MySQL database and completing the wizard, I'm either getting a white screen with a circling color "O" or an error: Column 'pos' cannot be null.
I've used the query wizards sql queries and I have used mysql queries generated from phpmyadmin all of which generate usable results.
I've created databases both inside and outside of the WP database. All query results are the same....good for phpMyadmin but not for WPDT data source SQL query.
Do you have any tips or insight on what's going on?
Pls advise. tobin shepherd
Here's my system data:
pls see the private ticket (3764582) with requested information. tobin shepherd
MIlos, thanks for your reply. It's not a simple query to 1 table of the database; rather its a simple query of a relational tables in the database. There are only 250 rows in the membership table.
SELECT `members_year_paid`.`yearpaid`, `ncehsamembership`.`name`, `ncehsamembership`.`emailaddress`, `ncehsamembership`.`district`, `ncehsamembership`.`county`, `ncehsamembership`.`active1`
FROM `members_year_paid`
LEFT JOIN `ncehsamembership` ON `members_year_paid`.`wdt_ID` = `ncehsamembership`.`wdt_ID`;
I tried the disable server side processing. I received the error: Error Column 'pos' cannot be null
After watching the mySQL view video, it appears I need to create views in mySQL and then call them from WPDT.
Let me tinker some more and see what happens.
Thanks Milos!
When modifying the query I still get the error message: Column 'pos' cannot be null. So the suggestion is a good idea but it does not work.
I need this relational query to update both tables. In your expertise, can creating views in a mySQL database to use with your plugin accomplish editable relational queries?
Pls advise. tobin