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?
As mentioned, if you call data from multiple tables in our Plugin, you will not be able to edit a table like that. Please check the editing limitations on this Page. I will just point them out here, to make it easier :
Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” pagecan be edited.
Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.
MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.
So, the main point, as you can see is, our Plugin can only edit when you call one table at a time.
The only way currently to edit data which is called from a foreign table is via our foreign key relation feature. Please check more here - Basically, this can allow you to get all possible unique values from a foreign table's column into this table's column, and you can edit it via single value selectbox - But this can not save data in that foreign table - it is only saved in the current table which you are viewing/editing.
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
Hi tobin,
As mentioned, if you call data from multiple tables in our Plugin, you will not be able to edit a table like that.
Please check the editing limitations on this Page. I will just point them out here, to make it easier :
So, the main point, as you can see is, our Plugin can only edit when you call one table at a time.
The only way currently to edit data which is called from a foreign table is via our foreign key relation feature.
Please check more here - Basically, this can allow you to get all possible unique values from a foreign table's column into this table's column, and you can edit it via single value selectbox - But this can not save data in that foreign table - it is only saved in the current table which you are viewing/editing.
I hope it helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thanks Milos. Pls close this ticket. Bests, tobin