Welcome! 🙂
I haven’t seen a 403 error before. That one is new to me. Let’s see if we can fix it…
Can you give me a little background information?
– Are using one table? Or a relationship (multiple tables)?
– Are you using Data Projects?
– How do you use your table in the dashboard?
– How do you use it on a web page? Can you give me the shortcode and arguments?
When you use shortcode wpdadiehard, table and column names can collapse with themes or other plugins. The most common column names that are giving trouble are:
id, name, search, s, page, action, …?
They usually give a 404 error, but it might be worth checking. Renaming these column names usually solves the 404 error.
Thanks,
Peter
Thank you for the quick reply Peter.
– I’m just trying out a single table with primary key given.
– Yes, using it with data projects.
– Dashboard table as followed in the guide no problem.
– The problem only occurs when trying it in the webpage even logged in using the admin account.
As long as I’m using wpdadiehard it will give error in the webpage when I try to press on anything from the table.
There’s 2 method that I use with wpdadiehard that give me error:
1) [wpdadiehard table_name=”wpux_options”]
2) [wpdadiehard project_id=”1″ page_id=”1″]
Is your web page live? Can I see the error? If not, can you provide a screen shot?
If you have additional plugins installed, can you temporarily turn them of to see if the error disappears?
Can you give me your table structure?
Thanks,
Peter
Yes the webpage is live at https://nscmhmedicalcentre.com/testing/
Only WP Data Access plugin is installed activated yet the error still occur when I press on anything from the table.
The Table is based on phpMyadmin table and use WP Data Access create new “Data Projects” to display it on website. In dashboard, WP Data Projects able to click “view” and “edit” link, but when I put Data management on Web unable to click “view” and “edit” link.
I’m seeing this:
ERROR: No access [could not determine user role]
That is because I’m not logged in. Can you add a screenshot? I would like to see what you see when you are logged in. Can you see the list table? Can you add your create table script?
Thanks,
Peter
Hi Peter,
I’ve already updated the table with [wpdadiehard table_name=”wpux_usermeta”] instead but the error will still occur if I press on any table options.
-
This reply was modified 6 years, 1 month ago by
kokchoon.
Thanks! The page is now showing the table and when I click a table options I’m getting the same error. Can you please check out the link below? You’ll find an explanation how to fix exactly this error.
https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-403-forbidden-error-in-wordpress/
Hope this helps. If not, can you give me temporarily access to your WordPress installation? You can use the contact form on the plugin website to get in touch privately.
Best regards,
Peter
I already tried all of the available methods that is in the link but none of it seems to be working.
I already sent a response to the contact form in the plugin website.
Hi Peter, the issue has been already resolved.
Thank you so much.
@peterschulznl I too am having a similar issue. I’m trying to create a simple form like the Registration Form shown in the video at https://www.youtube.com/watch?v=ogclFArjF4Q
but when I try to access it as a non-logged in user I get this message
as you can see at http://arainbowagreement2020.net/test/.
If you go to the home page, I have the select working fine, but am trying to add a form to directly insert. Any help you can provide would be awesome. I’ve been struggling with this for two days now.
Thanks in advance for your help,
Karin
Hi Karin,
Can you please check your role settings:
– Go to Settings menu
– WP Data Access
– Tab Manage Roles
– Disable checkbox “Use roles in shortcode wpdadiehard (Data Projects)”
– Save your settings and try again
Please let me know if this helps…
Best regards,
Peter
@peterschulznl That solved the displaying the two fields on the page, but when I click submit, I get this error “Oops! That page can’t be found.”
Hi Karin,
That is usually the result of a column name which is already used in your theme or another plugin. Don’t use column names like ‘id’, ‘name’, ‘search’, ‘s’, ‘page’ and ‘action’. These column names are often used in themes and other plugins.
If your table contains one of these column name, please rename it. Alternatively you can also try to change your theme.
For example: If your table contains a column name, rename it to something like person_name.
Please let me know if this helps…
Best regards,
Peter
Thank you @peterschulznl Problem solved.
