1. Home
  2. Docs
  3. Getting Started
  4. Known limitations

Known limitations

  • Shortcode wpdadiehard does not work on a homepage. Data Forms is a premium feature which does not have these limitations.
  • To support data entry and table bulk actions a table must have a primary key or a unique index.
  • If you add list tables or data entry forms to your web pages, you might get a 404 error for column names that interfere with WordPress, theme or other plugin parameters (like ‘id’, ‘name’, ‘search’, ‘s’, ‘page’, ‘action’, ?). Solution: rename your column. For example: rename column ‘name’ to ‘person_name’.
  • Media items are not supported in data entry forms on web pages.
  • On activation the plugin creates a repository. If the plugin is networked activated on a multisite installation a repository is created for every blog. For blogs added later, the repository must be created manually (Manage Plugin > Manage Repository).
  • WP Data Access uses plugin tables which are prefixed with $wpdb->prefix. If you change the WordPress database tables prefix after installing WP DAta Access, you’ll need to change the prefix of the WP Data Access table equally.
  • There is a limit on the file size for imports. The maximum file size depends on your installation. Read more…
  • Please make sure your WordPress date format is defined as “Y-m-d” if you want to make your date columns searchable in the Search Builder. Other date formats are currently not supported.
Was this article helpful to you? Yes 3 No

14 Replies to “Known limitations”

  1. Hi Peter,
    Is it possible when entering multiple child-records to clear the entry form after entering each child? Instead of leaving the screen, returning to the list and push the add new button again.
    kind regards

  2. Hi Mieke,

    Not sure if I understand your question correctly. The intended flow is as follows:
    – Click button Add New to insert a new child record
    – Enter child record
    – Save
    – Click button Back To List
    You need to repeat these steps if you want to add multiple child records.

    The reset button is to reset the form. Suppose you entered or changed some data and want to return to the old values, you click the reset button.

    If I understand your question correctly, you like the Add New button to be visible all the time? Is that right?

    Best regards,

    1. Hi Peter,

      Yes, to see the add new button all the time would be a good solution.
      I thought that by pressing the reset button after saving my new child record, I could enter the next new child record. Clearing the values = returning to the old situation and because it is add new, it would be logical to be able to enter a new cild record.

      kind regards

  3. Hi Mieke,

    The buttons “Add New” and “Add Existing” for child rows are always visible in the next version (2.7.0) which I hope to publish this week. I see now how this has a positive effect on data entry. 😉 Thank you for your feature request!

    Best regards,

  4. Hi Pawan,

    Sorry, but the plugin uses wildcards in queries. I added your request to my to do list. See if I can add a feature for exact searching. I let you know if when is available.

    Best regards,

  5. Can you confirm if I purchase Data Access on premium monthly for a number of months to improve our website, then cancel premium and go back to free version, would I loose any access to the tables or php code work I carry out in WordPress.
    In particular, I will build new tables, link to existing via query and display linked output on pages for visitors, what if anything would I loose by reverting back to free version of Data Access?
    It is the case that I am not absolutely sure this plugin will do everything I will need it to, but have to use Premium to confirm.
    Also can I use Premium single site in my sandboxed localhost as well as in Live, if all goes to plan with the same single site premium license?
    Many Thanks, and so far I have to say, this looks to be the best plugin I have come across for a lot of my requirements.

    1. Hi Mark,

      You will not lose any data when you switch from premium to free. The only difference is that some features will no longer be available in the free version. The premium version is free on localhost. You just a need a premium license for your public server.

      Hope this helps,

  6. Peter,

    Thank you for the response.
    I have just purchased the Premium on a monthly basis for now, but activated it on the localhost first.
    Will there be any issues if I then use the same activation code on the public site?
    Thank you for the great application. Saves me a lot of time and effort with my work.
    Mark H

    1. Hi Mark,

      Thank you for upgrading to premium!

      You can use an activation code on one system only. You can transfer your activation code anythime from here:

      The premium version is free on your localhost! Just activate it and use your premium activation code on your public server.

      Hope this helps,

  7. Hello there,

    I have the premium plugin and am using the wpdadiehard shortcode in my pages.
    On the page/frontend I need users to be able to sort an ASC/DESC column with a lookup relationship but this sorting feature is disabled by default, how can I enable this on my page?


    1. Hi Matt,

      Sorting on child table columns should be available per default, but does not work with lookup columns. Is this your case?


        1. Hi Matt,

          Sorting on lookup columns is currently not supported and there is actually no workaround. Sorry! But we added your request to our to do list. We need a little time to implement this. Hope to add it first quarter next year. Thanks for your contribution!

          Best regards,

Leave a Reply

Your email address will not be published.