Hi,
thanks for your post, and sorry for the trouble.
That means that your user (or the user role that it has) does not possess the necessary access rights/capabilities for importing and exporting tables.
If you are not an admin user, an admin might have taken those from you, otherwise they might have been removed by accident.
Can you maybe check with a plugin like Members or User Role Editor whether your user’s user role has the “tablepress_import_tables” and “tablepress_export_tables” capabilities?
Regards,
Tobias
I am the only administrator. I used User Role Editor and checked my capabilities. All of the “tablepress_*” options are checked.
Hi,
ok, thanks for checking. That’s really weird then, and I don’t see what could be wrong here…
Therefore, if possible, I’d like to take a direct look at this on your site. Could you therefore please create a temporary admin account for me and send me the details via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!
Regards,
Tobias
Done. Thanks for looking into this.
Hi,
thanks! I was able to log-in and could reproduce the issue.
Then, I went into User Role Editor, and saw that the “tablepress_import_tables” and “tablepress_export_tables” capabilities were missing entirely (i.e. they were not even appearing as unchecked checkboxes).
I then simply re-added them, so that all TablePress screens should appear now 🙂
Regards,
Tobias
Perfect! Thanks Tobias! Awesome support!
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
Worked like a charm. Resolved.
Hi,
thanks for the confirmation!
Best wishes,
Tobias
Hey Tobias, I too did this trying to get a user to only be able to edit tables. Is there something I can do in mysqladmin? or do I need you to work your magic?
Thanks!
Hi,
if you want to strip a user of certain rights, I recommend to use the “Members” plugin from http://ww.wp.xz.cn/plugins/members/
It has a Role Manager built in that you can use to remove certain capabilities from the desired user roles.
With that, you need to remove all capabilities that begin with “tablepress_” from the desired user roles.
Regards,
Tobias
Oops, sorry I should have been more clear.
I have lost the Tablepress tab as well.
Is it something I can fix in mysqladmin?
Got it!
I used the following link then deleted the plugin.
I will try Members.
Thanks Tobias!
http://ww.wp.xz.cn/support/topic/warning-user-role-editor-can-remove-admin-menu-and-functionality
I’m using the TablePress Plugin and Duplicate Posts plugin.
If you “Reset” roles in User Role Editor, 1) Your TablePress menu will be unaccessible and 2) You “clone” posts/pages from the Duplicate Posts will be gone.
To restore your admin menu for Tablepress:
1. Goto User Role Manager and click “Add Capability”
2. Re-enter the below for Tablepress – this will restore your Tablepress admin menu.
tablepress_edit_tables
tablepress_delete_tables
tablepress_list_tables
tablepress_add_tables
tablepress_copy_tables
tablepress_import_tables
tablepress_export_tables
tablepress_access_options_screen
tablepress_access_about_screen
tablepress_import_tables_wptr
tablepress_edit_options
Hi,
yes, that’s what I meant 🙂 Good to hear that you were able to restore the capabilities.
Just be careful with which user roles you give them to (if your sites has multiple users in different roles).
Regards,
Tobias
