Facing Database issues

  • Resolved priyankac

    (@priyankac)


    1 year, 4 months ago

    Hello Team,

    I have installed PublishPress Permissions plugins.

    Currently, I’m encountering some database issues:

    WordPress database error: [Table ‘databasename.wpm2_pp_group_members’ doesn’t exist] SELECT * FROM wpm2_pp_group_members INNER JOIN wpm2_pp_groups AS g ON wpm2_pp_group_members.group_id = g.ID WHERE member_type = ‘member’ AND status = ‘active’ AND user_id IN (‘1’) ORDER BY wpm2_pp_group_members.group_id

    WordPress database error: [Table ‘.databasename.wpm2_pp_group_members’ doesn’t exist]
    SELECT user_id FROM wpm2_pp_group_members WHERE group_id = 1 AND user_id = 1

    WordPress database error: [Table ‘databasename.wpm2_pp_group_members’ doesn’t exist]
    SHOW FULL COLUMNS FROM wpm2_pp_group_members

    Could you please advise on how to resolve this issue?

    Thank you.

Viewing 1 replies (of 1 total)
  • Plugin Author Kevin Behrens

    (@kevinb)

    1 year, 4 months ago

    Hello @priyankac,

    Please try the following troubleshooting / workaround steps:

    1. Use a website file manager to delete the folder press-permit-core folder (inside wp-content/plugins).
    2. Use phpMyAdmin or a similar database utility to execute the following query:
      DELETE from wp_options WHERE option_name = 'presspermit_version'
      Note that you will need to change “wp_options” to your actual table name including the unique database prefix.
    3. Edit your wp-config.php file, adding the following code snippet just below existing constant definitions:
      define( 'PRESSPERMIT_LEGACY_DB_SETUP', true );
    4. Re-activate the plugin.

    If you can’t execute a database query, try using your database utility to browse the options folder, search for the option_name presspermit_version, then delete the matching row in the search result.

Viewing 1 replies (of 1 total)

The topic ‘Facing Database issues’ is closed to new replies.