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

Thanks Milos.  Pls close this ticket.  Bests, tobin