Query Bulider do nothing

  • Resolved MarekL

    (@hawai)


    4 years, 4 months ago

    Hi.
    I installed WPDA. When I execute simple sql query (like SELECT * FROM table) in Query Builder and click Execute nothing happens. Button Save also doesn’t work. And there is button Visual Query Buider.
    Data Exlorer works fine, I can show tables, add row.
    I tried in different browsers, clean browsers cache, different computers, reinstall WPDA – nothing helps.
    I’m using version 5.9 WP and 5.1.1 WPDA

    Regards
    Marek

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 4 months ago

    Hi Marek,

    This looks like a ajax issue. Please check this:
    – Open the Data Explorer
    – Click the Manage link of a table
    – Does this open the table tabs?

    If not:
    – Open the inspector (tab Network)
    – Click of the Manage links again
    – What is the server response?

    Thanks,
    Peter

    Thread Starter MarekL

    (@hawai)

    4 years, 4 months ago

    Hi Peter
    Thank you for your answer.
    Data Explorer works fine. I can manage tables, I see tabs: Actions, Settings. Columns etc. I can switch tabs, button works well.
    I also have a problem with Data Publisher – Table/View Name field is empty.
    Could it be a problem with residues from other plugins I tested?

    Regards
    Marek

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 4 months ago

    Hi Marek,

    Thank you for your reply!

    When you start the Query Builder, can you please:
    – Open the inspector (tab Network)
    – Execute a query
    – Check the response (look for: admin-ajax.php)

    Can you share the response? You can use the contact form on thge plugin website if you prefer to send this information in private.

    Thanks,
    Peter

    Thread Starter MarekL

    (@hawai)

    4 years, 4 months ago

    Hi Peter,
    Thank you for your answer.
    I have reset my WordPress (my project is in its early stages). I droped database, installed new WordPress & the plugins I use. Finally, I imported the data.
    Now the WPDA works much better. I can query the Query Buider, the Data Publisher displays the tables. There is just no Visual Query Builder button in Query Builder.
    Thank you for your help Peter.

    Regards
    Marek

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 4 months ago

    Hi Marek,

    Thank you for reporting back! Good to read you got it working. 👍

    Some WP Data Access services rely on clean ajax responses. If an ajax response is malformed by some code on your server, some services might not work.

    The Query Builder is part of the free version. The Visual Query Builder requires a premium license. That is why you are missing the button.

    Best regards,
    Peter

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Query Bulider do nothing’ is closed to new replies.