Title: ERROR: Not authorized
Last modified: March 20, 2020

---

# ERROR: Not authorized

 *  Resolved [mikebian](https://wordpress.org/support/users/mikebian/)
 * (@mikebian)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized/)
 * 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)

[←](https://wordpress.org/support/topic/error-not-authorized/?output_format=md) 
[1](https://wordpress.org/support/topic/error-not-authorized/?output_format=md) 
2

 *  Thread Starter [mikebian](https://wordpress.org/support/users/mikebian/)
 * (@mikebian)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized/page/2/#post-12565230)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/error-not-authorized/page/2/#post-12566015)
 * 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)

[←](https://wordpress.org/support/topic/error-not-authorized/?output_format=md) 
[1](https://wordpress.org/support/topic/error-not-authorized/?output_format=md) 
2

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/)

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