Hey there, Just thought I'd let you know about an issue I ran into.
When trying to create a foreign key to a sql query generated table, adding the semicolon in the query breaks the foreign key and the dropdown select box is blank.
Deleting the semicolon makes everything work fine.
Thank you for reaching out to us, but we are already aware of that issue.
Not only that, but you may want to look out for these as well:
For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query. If you use them, there's a chance search, filtering and sorting will not work correctly.
If you leave the asterisk ( * ) in the same row, the table may not display due to a conflict with security plugins or mod_security.
Once again thanks for the heads-up, and if you run into anything else, please let us know.
Hey there,
Just thought I'd let you know about an issue I ran into.
When trying to create a foreign key to a sql query generated table, adding the semicolon in the query breaks the foreign key and the dropdown select box is blank.
Deleting the semicolon makes everything work fine.
Hello withlovingarms
Thank you for reaching out to us, but we are already aware of that issue.
Not only that, but you may want to look out for these as well:
Once again thanks for the heads-up, and if you run into anything else, please let us know.
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