Facing database issues

  • Resolved priyankac

    (@priyankac)


    8 months, 1 week ago

    Hello Team,

    I have installed both the Profiles and 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

    Could you please advise on how to resolve this issue?

    Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Collins Agbonghama

    (@collizo4sky)

    This doesn’t look like a ProfilePress issue. We don’t have any database table named pp_group_members. And the SQL query isn’t a ProfilePress one.

    Am sorry, you will have to contact the other plugin developer.

    Thread Starter priyankac

    (@priyankac)

    Hello,

    Thanks for your response

    ..\wp-content\plugins\press-permit-core\classes\PublishPress\Permissions\DB\Groups.php

    I got issues on this page if I commented this below code issue is resolved

         // $results = $wpdb->get_results(

                //     $wpdb->prepare(

                //         “SELECT * FROM $wpdb->members_table $join”  // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

                //         . ” WHERE member_type = %s $status_clause $metagroup_clause AND user_id IN (‘$user_id_csv’)”  // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

                //         . ” ORDER BY $wpdb->members_table.group_id”,

                //         $member_type

                //     )

                // );

    Please confirm this is not a profile press or PublishPress Permissions? plugin

    Plugin Author Collins Agbonghama

    (@collizo4sky)

    I can authoritatively say this is not an issue from ProfilePress. We don’t own publishpress so I can’t speak for them.

    Thread Starter priyankac

    (@priyankac)

    How can I solve this issue? Is there a support team available?

    • This reply was modified 8 months, 1 week ago by priyankac.
    Plugin Author Collins Agbonghama

    (@collizo4sky)

    This is not a ProfilePress issue, so we can’t help you.

    Best if you contact the publishpress developers as it is likely to be an error from their plugin.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Facing database issues’ is closed to new replies.