Title: ERROR: Not authorized
Last modified: March 3, 2021

---

# ERROR: Not authorized

 *  [carlrgates](https://wordpress.org/support/users/carlrgates/)
 * (@carlrgates)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/error-not-authorized-3/)
 * Error is when I add or edit children. Screen blanks out and I get just the message
   ERROR: Not Authorized. When I do it from my web site using short code, it shows
   no error and goes to home page.
 * In either case, I do not get child added/updated.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ferror-not-authorized-3%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14133743)
 * Hi [@carlrgates](https://wordpress.org/support/users/carlrgates/),
 * Does it work when you add your Data Project to your dashboard?
 * Please see the known limitions for shortcode wpdadiehard:
    [https://wpdataaccess.com/docs/documentation/getting-started/known-limitations/](https://wpdataaccess.com/docs/documentation/getting-started/known-limitations/)
 * Thanks,
    Peter
 *  Thread Starter [carlrgates](https://wordpress.org/support/users/carlrgates/)
 * (@carlrgates)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14134822)
 * Thanks for the quick response. No, it does not work when added to dashboard, 
   I get error message “ERROR: Not authorized”. I think I have created a straightforward
   uncomplicated database but if you think it will help, I can completely uninstall
   and reinstall.
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14136164)
 * Hi [@carlrgates](https://wordpress.org/support/users/carlrgates/),
 * Does column roles contain your role?
 * Thanks,
    Peter
 *  Thread Starter [carlrgates](https://wordpress.org/support/users/carlrgates/)
 * (@carlrgates)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14255749)
 * I have the Data Projects/Role parameter set to “Admin”. Is this the Column Roles
   you are taking about?
 * I have each parent/child table defined as a menu item on the dashboard so I am
   able to go to the table directly from the dashboard and add rows as well as adding
   using Data Explorer. I see the rows when I “View” or “Edit” the parent but when
   I go to “Add New” to the child, I get the error.
 * I was able to delete the parent which also deleted the children.
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14259099)
 * Hi Carl,
 * >>> I see the rows when I “View” or “Edit” the parent but when I go to “Add New”
   to the child, I get the error.
 * How is your relationship defined? Can you share that?
 * Does your child table have a primary or unique index? Is a table or a view?
 * Thanks,
    Peter
 *  Thread Starter [carlrgates](https://wordpress.org/support/users/carlrgates/)
 * (@carlrgates)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14260838)
 * All are tables,
    all relationships are 1:n, all relationships have source of 
   primary key to child table (Parent_table.key + Child_table.Parent_key).
 * all have “PRIMARY” indexes on key only and are unique.
    all keys are auto_increment.
 *  Thread Starter [carlrgates](https://wordpress.org/support/users/carlrgates/)
 * (@carlrgates)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14260866)
 * Continued from previous message-
 * Would you prefer an admin link to my application? It is just a test/learning 
   site so I can always recreate it if messed up. I would need a non-public email
   to send info.
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14261629)
 * >>> Would you prefer an admin link to my application?
 * Yes, please! You can use the contactform on the lugin website to send the information
   in private.
 * Thanks,
    Peter

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

The topic ‘ERROR: Not authorized’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [child](https://wordpress.org/support/topic-tag/child/)
 * [not authorized](https://wordpress.org/support/topic-tag/not-authorized/)
 * [Relationship](https://wordpress.org/support/topic-tag/relationship/)

 * 8 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [5 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized-3/#post-14261629)
 * Status: not resolved