Tables I create are only visible in Data Designer

  • Resolved lauralius

    (@lauralius)


    5 years, 9 months ago

    Hi Peter,

    I just started checking out WP Data Access this week, and I think it’s a solid solution to what I want my site to do once I can get through one error. I’m not sure if I missed a step somewhere or if there’s a bug in the plugin itself.

    I can create tables from scratch in Data Designer without too much issue, but none of the tables I made are available anywhere in Data Explorer or Projects. I can still edit their table structures however I want within Data Designer. I’ve tried a few different engines, collations, and settings within the tables, with the same results. I’ve made sure I have at least one key and that it is indexed, and I’ve tried indexing additional columns.

    I’m running WordPress 5.2.1 with PHP 7.2.10. I have WP Data Access 2.0.14. I’ve tried it on two unconnected sites with the same versions of PHP, WordPress, and theme (2015), with the same issue. None of my settings sound like they should be causing tables I created to be hidden, and plenty (44) of WordPress tables are present and accessible in the default Data Explorer view.

    When I go to WP Data Access -> Manage Repository, one site appears to have no recognized issues there, and the other looks like everything’s good except for “Trigger wp_wpda_menu_items_before_insert not found” and “Trigger wp_wpda_menu_items_before_update not found.” I didn’t mess with anything that could have deleted these, so I’m not sure why they’re only in one version. They both acknowledge the tables designs I have in the design repository.

    Thank you for your help.

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

    (@peterschulznl)

    Hi Lauralius,

    Let me try to answer your questions.

    Q1) None of the tables I made are available anywhere in Data Explorer or Projects

    Stupid question: Did you create the tables and indexes?

    Let me explain… The Data Designer allows you to DESIGN a table. After designing a table you have to explicitly create the table (and indexes) from your design.

    Please let me know if you get any errors while you try to create your tables and indexes. Maybe I can help!

    Q2) I’m not sure why the triggers are only in one version

    The triggers for table wp_wpda_menu_items are meant to keep the data in that table clean. The plugin will work without the triggers as well, but users might enter invalid data which might cause problems when you add (invalid) menu-items to your own dashboard menu.

    For the installation where you are missing the triggers you are most probably not able to create database triggers. There are two possible causes: (1) you are using an older MySQL version or (2) you do not have permission to create triggers on that database.

    The create table and triggers script for table wp_wpda_menu_items creates the table and triggers in two steps to allow the create trigger statements to fail. You can safely ignore this message. Keep in mind however that you check the validity of a menu-item when you create a dashboard menu (from the menu: WP Data Access menu > Data Project > Manage Dashboard Menus).

    Please let me know if this helps!

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Laura,

    I’m closing this topic and hope my post was helpful!

    After reading it again I realize that you might have misunderstood my post. When I wrote “Stupid question” I meant my question: “Did you create the tables and indexes?” Not your question!!! I did not mean to offend you in any way. I apologize if I did!

    Best regards,
    Peter

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Tables I create are only visible in Data Designer’ is closed to new replies.