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

Okay
  Public Ticket #4026844
Cannot Save Detail Table Query with %s Placeholder (Master-Detail Addon)
Open

Comments

  • Adrian started the conversation

    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.