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
Hi,
For some mysterious reason, the query generator truncates certain columns names as if it does not like the column name.
For instance, if I write a query like this against my table:
SELECT DELTA_SYSIBMADM_SNAPDB.ROWS_DELETED
FROM DELTA_SYSIBMADM_SNAPDB
I can see the sample data as I am building the wpDataTable but when I try to actually create the table, I get an error message. The query that gets submitted to mySQL is changed to
SELECT DELTA_SYSIBMADM_SNAPDB.ROWS_D
FROM DELTA_SYSIBMADM_SNAPDB
The generator just chopped off a part of the column name.
But it doesn't do that with certain other column names like ROWS_READ.
Any idea why this is happening?
Many thanks.
HI AliManouchehri,
Thank you for your purchase.
Yes that is normal behavior of plugin, because it contains functions that removes all dangerous strings from query like DELETE, DROP, INSERT...
As you can see in your query that contain word DELETE. Please change this column in database and use for example ROWS_REMOVED.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you Milan, as always very helpful, and makes sense.
I would be very grateful if you can send me a list of the dangerous keywords that I should stay away. And you can close this ticket.
Thanks...Ali
HI Ali,
You are welcome.
That are dangerous keywords from previous post.I accidentally add more dots on end.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Just left a 5-star review and mentioned your name.
Cheers...Ali
HI Ali,
Thank you so much for excellent review. You made my day.
Have a nice weekend.
Best regards
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables