FINAL DAYS FOR SUPPORT ON THIS PLATFORM
As mentioned through banners and newsletters, starting Sunday (June 1st), we're transitioning to a new support system that will be available through your store accounts (for premium/paid users) or directly on our product websites – Amelia, wpDataTables, and Report Builder (for pre-purchase questions) through a support widget in the bottom right corner.
Starting June 1st, you’ll no longer be able to reply to existing tickets or open new ones on this platform. Instead, please use the "Submit a Ticket" option, which will redirect you to the right page where you can easily reach out to us.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello wpDataTables Support,
I am trying to set up a Master-Detail table using the Master-Detail addon (which I have purchased and activated).
I have created my Master table and am now trying to create the Detail table. I am using the "Generate a query to SQL database" option.
>span class="inline-code ng-star-inserted">%s in the WHERE clause, like this:
SELECT ClaveProdServ, Descripcion, Cantidad, ValorUnitario, Importe FROM db_sat_xml_conceptos WHERE uuid = %s;
However, when I try to save the Detail table with this query, I get a MySQL syntax error. The rendered query shown in the error message still contains the literal %s:
Rendered query: SELECT ClaveProdServ, Descripcion, Cantidad, ValorUnitario, Importe FROM db_sat_xml_conceptos WHERE uuid = %s LIMIT 10
MySQL said: You have an error in your SQL syntax; check the manual... near '%s LIMIT 10' at line 1
I understand that the %s placeholder is necessary for the Master-Detail functionality to work, and that wpDataTables should handle this placeholder correctly during validation when the addon is active.
Could you please advise on why I am getting this syntax error and how I can properly save the Detail table query with the %s placeholder?
Thank you for your help.