• carlrgates

    (@carlrgates)


    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 to see the link]

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

    (@peterschulznl)

    Hi @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/

    Thanks,
    Peter

    Thread Starter carlrgates

    (@carlrgates)

    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

    (@peterschulznl)

    Hi @carlrgates,

    Does column roles contain your role?

    Thanks,
    Peter

    Thread Starter carlrgates

    (@carlrgates)

    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

    (@peterschulznl)

    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

    (@carlrgates)

    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

    (@carlrgates)

    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

    (@peterschulznl)

    >>> 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.