SQL Like Incompatible with

  • Resolved voidunnamed

    (@voidunnamed)


    2 years, 11 months ago

    Whenever I built SQL query with like ‘%ac’ with WP Data Access,

    SELECTa.b` as ‘b’
    FROM a
    WHERE (a.b like ‘%%ac%’)`

    The result will be last_query: "SELECTa.bas 'b' FROMaWHERE (a.blike '%%') limit 100 ".

    It looks like %ac is some kind of reversed words. The same happens for %ad as for as I know.

    Does anyone know what may cause this and how am I going to fix it?

    • This topic was modified 2 years, 11 months ago by voidunnamed.
    • This topic was modified 2 years, 11 months ago by voidunnamed.
    • This topic was modified 2 years, 11 months ago by voidunnamed.
    • This topic was modified 2 years, 11 months ago by voidunnamed.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @voidunnamed,

    I have seen this behavior before, but I cannot reproduce it. Can you send me your system info? Open plugin settings, tab System Info and click “Copy to clipboard”. Then go to the plugin website, open the contact form and paste your system info in the message with a reference to this forum issue. I’ll look into it…

    Thanks,
    Peter

    Thread Starter voidunnamed

    (@voidunnamed)

    Hi @peterschulznl,

    I have submitted a contact forum. I submitted the system info as much as I can due to the 2048 characters limitation. Please let me know how I am going to send the full System Info, or if I submitted it in the wrong place.

    Best,
    Marvin

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Thank you Marvin,

    I don’t see any issues in your configuration. Can you check the request?

    Please try this:
    – Start the Query Builder
    – Open the Network tab of the inspector
    – Send the query that results in an error
    – Check the request:
    Please check wpda_sqlquery in payload
    And cmd in preview

    Is the query send and processed correctly?

    Thanks,
    Peter

    Thread Starter voidunnamed

    (@voidunnamed)

    Hi Peter,

    Yes, the query is sent correctly.
    wpda_sqlquery: SELECT a.b as ‘b’
    FROM a
    WHERE (a.b like ‘%%ac%’)

    The response becomes to “last_query”: “SELECT\ta.b as ‘b’\nFROM\ta\nWHERE\t(a.b like ‘%%’) limit 100 “.

    Best,
    Marvin

    • This reply was modified 2 years, 11 months ago by voidunnamed.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Marvin,

    Problem found and fixed! The fix will be available after the next update.

    Thank you for your patience and cooperation,
    Peter

    Thread Starter voidunnamed

    (@voidunnamed)

    Hi Peter,
    Thanks for fixing the bug. After upgraded to the latest version, the query function works well. I found that the same problem still holds in URL filter via GET Method. For example, /?wpda_search_column_a=%ac% still cannot be executed correctly.
    Best,
    Marvin

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Marvin,

    My apologies for my late reply! During my stay in Aruba I was not able to recharge my laptop battery which was limiting my internet access.

    I can reproduce this issue! Sorry, it must have been late. ?? I’ll fix it before I deploy the next version.

    Thanks again for your contribution ??
    Peter

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘SQL Like Incompatible with’ is closed to new replies.

Tags