ERROR: Not authorized

  • Resolved mikebian

    (@mikebian)


    4 years, 12 months ago

    I have several non WordPress tables I added to my database. Two of these I want to be able to edit from your plugin. Using Data Explorer, I can edit one of the tables with no problem. With the other, I can click on Edit, but when I try to save the row, I get an “ERROR: Not authorized” error message back and the row is not updated.

    I am using BlueHost and with them, I do not have true admin access. I created both tables in the same manner through phpMyAdmin, and data is inserted into both tables via PHP code that gets executed in a form submit, so WordPress definitely has at least INSERT permissions. Since both tables were created in the exact same manner, and I can update one of them through your app, I can’t see why the other table would not be updatable.

    Any thoughts? Thanks.

Viewing 2 replies - 16 through 17 (of 17 total)
  • Thread Starter mikebian

    (@mikebian)

    Peter: Awesome! That fixed the problem. Thanks!

    So was the issue with the PK being a timestamp? I used to be pretty good with IBM DB2 and I’d do that all the time – meaning no ID type column. It’s great that this worked, and I really don’t care about adding the ID column, but still not sure why it was failing (not that it really matters) and if I was doing something questionable from a MySql point of view with my table def.

    Dave: BlueHost does let you create unique db users and assign them to individual databases. What it does not allow you to control is what user gets used when you launch phpMyAdmin from their control panel. It always uses some internal user that it generates and I have no control over.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Mike,

    Great that it works! ??

    The plugin is not handling the timestamp column correctly if it is a primary key. It is on my to do list! I’ll pick it up and try to fix it in the next release.

    Thank you for being so patient and co-operative! I really appreciate that. It helps to improve the quality and stability of the plugin.

    Have a nice weekend! ??

    Best regards,
    Peter

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘ERROR: Not authorized’ is closed to new replies.