search

opencredit / badgeos

BadgeOS is a plugin to WordPress that allows you to easily create badges and set up the steps and achievements users take to earn them. Badges are Mozilla OBI compatible and sharable via Credly.
http://www.badgeos.org
GNU Affero General Public License v3.0
92 stars 64 forks source link

WordPress database error #878

Open younes-dro opened 2 years ago

younes-dro commented 2 years ago

Hi. Every time i log-in i get this error :

[13-Sep-2022 06:27:58 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''wp_posts' as posts
            LEFT JOIN 'wp_postmeta' AS m1 ON ( posts.ID = m1' at line 2 for query SELECT *
            FROM 'wp_posts' as posts
            LEFT JOIN 'wp_postmeta' AS m1 ON ( posts.ID = m1.post_id AND m1.meta_key = 'wp_postmeta' )
            LEFT JOIN '_badgeos_trigger_type' AS m2 ON ( posts.ID = m2.post_id AND m2.meta_key = '_badgeos_earned_by' )
            WHERE m1.meta_value = 'earn-rank'
                OR m2.meta_value = 'rank' made by wp_signon, do_action('wp_login'), WP_Hook->do_action, WP_Hook->apply_filters, award_default_ranks_to_user, badgeos_update_user_rank, badgeos_get_rank_based_achievements