Lost capabilities after changing table prefix

  • Resolved useStrict

    (@usestrict)


    1 year, 3 months ago

    Hi,

    Love your plugin. I always use the change table prefix feature, but this time I had to restore the database.

    When changing the table prefix and running wp user list, the roles/capabilities column comes up blank. No admins can access the back end.

    I noticed that the meta_key ‘$prefix_cabilities’ in $prefix_usermeta wasn’t changed. When comparing it to another site with the changed prefix, that meta_key uses the correct prefix.

    So I tried manually changing it but still didn’t get the capabilities to be loaded.

    Can you shed some light on the matter?

    Cheers,
    Vinny

Viewing 1 replies (of 1 total)
  • Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    1 year, 3 months ago

    Hi @usestrict,

    If I cross-check locally the user meta table having the $prefix_capabilities seems changed.

    https://snipboard.io/mQqdNI.jpg

    It might be there some error when updating usermeta table. generally this as message shown for the db prefix update

    The usermeta table records which had references to the old DB prefix were updated successfully!

    Regards

Viewing 1 replies (of 1 total)

The topic ‘Lost capabilities after changing table prefix’ is closed to new replies.