As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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