[missing WPDA_PARENT_KEY*?] when editing a page.

Hi expserv,

Which version are you using? The problem with editing the shortcode should be solved in version 2.6.0. Please update if you are using an older version.

If you want to show a project page on a web page with a shortcode you can ommit parameter table_name. Like this: [wpdadiehard project_id=”2″ page_id=”2″]

What is the page type of page 2 project 2? If it is a parent/child page you need to add a relationship. If there is no relationship you get the missing WPDA_PARENT_KEY error. Please set the page type to table if table purchase has no relationships. This should solve your problem.

Does your app work in the dashboard? If not, make sure it works in the dashboard first. The dashboard pages are much more stable. I’m working on version 2.6.1 which I hope to release before next weekend. Version 2.6.1 solves a lot of shortcode related issues and is the first stable version for web pages.

I would suggest you update to version 2.6.0 first (presuming you are using an older version), then get your data project working in the dashboard and add the shortcodes to your web pages after installing version 2.6.1. Is that acceptable to you?

I hope this helps! Let me know if you need more assistance.

Best regards,
Peter

Thank you for your quick reply.

The page type was set as ‘table.’ It was never ‘parent/child’ in the first place. The error of the white screen is still occurring. This project only uses one single table.

As for the app in the dashboard. It works for the most part except for the search bar.

Hi expserv,

Just a few questions:
1) Which version of WP Data Access are you using?
2) Can you describe your problem with the search bar?
3) Can you wait for release 2.6.1 for shortcode usage?

Best regards,
Peter

1) I am using the latest version. 2.6.0.

2) The search just doesn’t work. I tried every piece of values I added into the table and the search bar returns no result.

3) I think I can wait. I am currently exploring other plugins too, but your WP Data Access seems to be the only one with features I want to use. Front end editing. The buttons on the front end tables for editing lead to blank pages for now, but the possibilities exist.
Also, since this plugin actually creates a database table, I can let other plugins access the tables created here with some custom codes.

Hi expserv,

I released version 2.6.1 yesterday. Can you please update and then try again?

Please read the article about styling. You can find it here:
https://wpdataaccess.com/docs/documentation/shortcodes/styling-wpdadiehard-pages/

Let me know if you need help!

Best regards,
Peter

I updated to 2.6.1 and the problem remains. I am thinking of scraping the entire page and making a new one.

So, before I start this. I want to confirm the most optimal way to write a short code so I can edit the table in the front end.

Is this a proper way to write the code?:
[wpdadiehard project_id=”2″ page_id=”2″ show_view_link=“true” allow_insert=“true” allow_update=“true” allow_delete=“true” search_box_enabled=“true” filter_field_name=“true” ]

Also, are there any possible incompatibilities between certain short codes and other short codes, the plug-in setting, or other plug-ins?

Hi expserv,

Please check the following webpages to learn how you can use a data projects page in a shortcode:
(1) https://wpdataaccess.com/home/demos/demos-data-projects/data-project-parent-child-demo/
(2) https://wpdataaccess.com/docs/documentation/shortcodes/shortcode-wpdadiehard/
(3) https://wpdataaccess.com/docs/documentation/shortcodes/styling-wpdadiehard-pages/

The first page shows a demo. You can see the shortcode below the list table. Just enter a project_id and a page_id. The other arguments are only used in combination with parameter table_name.

There is a tutorial on the second page which might be helpful. The page shows you how you can style the list tables and data entry forms generated.

If you can you send me an export of your project and tables in private I can see if I can help. You send me a connection request on LinkedIn if you want to. You can find my LinkedIn page on the plugin page.

Best regards,
Peter

Thank you for all your help so far. The front end table is now functioning with the exception for the search bar. In the back end, the dashboard edit page now display: ‘ERROR: Wrong arguments [missing primary key value]’ in an all white screen.

However, this isn’t a major problem for me. I will start a new topic for other UI related issues.

Hi expserv,

I have no clue so far. Can you send me an export of your data projects table?
– wp_wpda_project
– wp_wpda_project_page
– wp_wpda_project_table

And the tables you are using in the project. You can send me empty tables if the table data confidential.

I hope I can help when I see what’s going wrong…

Best regards,
Peter

Hi expserv,

I released version 2.7.0. Please try if the problem is solved with the new release. I’m closing this topic. Please feel free to open a new topic if the problem recurs.

Best regards,
Peter

Hi, I have the same issue with version 3.0.0 : I get the message “ERROR: Wrong arguments [missing primary key value]” when I open the page into which I have put the shortcode [wpdadiehard project_id=”1″ page_id=”1″]
So I cannot even re-open the page. The page displays in the website, but if I add a record to my table, I get the same error message again. Thx for your help.
Marc

Hi Marc,

Was your project working correctly with the previous version? Was there a theme update?

Can you send me a full SQL export of the plugin tables wp_wpda_project and wp_wpda_project_page? You can create a full SQL export of these tables from the Data Explorer.

If you prefer to send me these files in private, please visit the plugin website (wpdatataaccess.com) and send me a private message. I will then reply and you can use the reply to add your files.

Best regards,
Peter

One additional question Mark!

If you run that project page in the dashboard, does it work then?

Best regards,
Peter

Hi Peter!

I’ve the same identical problem of @macbree.

Plugin version: 3.0.1
WP version: 5.3.2

In dashboard every page of the project works.

• This reply was modified 5 years ago by flazza87.

Hi flazza87,

Can you give me access to that page? Maybe set it to view mode?

Best regards,
Peter