I have a query which is working in mysql php admin but is not working in the woDatatable, Query is Select * from ( another SELECT statement). The Error says : generated by mode of security.
Does this plugin allow for complicated select statements or Select within Select statement ?
It should be working just fine, unless that second SELECT is within a view.
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.
Also, please make sure to tell me what's the table's ID so I know where to look.
Variable definition also doesn't work, select in select also doesn't work, I mean (set @myvariable=(select x from table1 where condition LIMIT 1) then using variable in another query). I am able to test my queries directly on the phpMyAdmin server but same query gives error when launching through plugin.)
I guess easiest way is you test yourself. I am not beginner in sql but if really needed I can give you credential.
At this point I see the feature is not there in your plug in.
Anyway it is great plugin but I think required some improvement.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.
Unfortunately we don't have any tutorials on creating views. You can take a look at this thread to get some insight.
The view is actually dynamic, so what ever data you change in the original table, it will be changed in the datatable as well. Please note, though, that views cannot always be editable. The plugin sometimes doesn't recognize where the data should be added to because of multiple JOINS and other functions a view might implement.
Hello,
I have a query which is working in mysql php admin but is not working in the woDatatable, Query is Select * from ( another SELECT statement). The Error says : generated by mode of security.
Does this plugin allow for complicated select statements or Select within Select statement ?
Thanks
Navid
Hello Navid.
It should be working just fine, unless that second SELECT is within a view.
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.
Also, please make sure to tell me what's the table's ID so I know where to look.
Best regards.
Kind Regards,
Aleksandar Vuković
[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 Aleksandar,
Variable definition also doesn't work, select in select also doesn't work, I mean (set @myvariable=(select x from table1 where condition LIMIT 1) then using variable in another query). I am able to test my queries directly on the phpMyAdmin server but same query gives error when launching through plugin.)
I guess easiest way is you test yourself. I am not beginner in sql but if really needed I can give you credential.
At this point I see the feature is not there in your plug in.
Anyway it is great plugin but I think required some improvement.
Thanks
Navid
I see Navid.
If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (rarely happens, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Please let me know if it works like this.
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Thanks Aleksandar, do you have any video / tutorial about it? How can I make it dynamic and also connect that with charts ?
Thanks
Navid
Hi again Navid.
Unfortunately we don't have any tutorials on creating views. You can take a look at this thread to get some insight.
The view is actually dynamic, so what ever data you change in the original table, it will be changed in the datatable as well. Please note, though, that views cannot always be editable. The plugin sometimes doesn't recognize where the data should be added to because of multiple JOINS and other functions a view might implement.
Best regards.
Kind Regards,
Aleksandar Vuković
[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