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 65 forks source link

Error message: Unknown column 'actual_date_earned' #795

Closed nsteinfeld closed 2 years ago

nsteinfeld commented 3 years ago

When manually issuing Open Badges through the user profile page, badges are created with entry ID 0 and never showed up on the user's profile page. e.g. Badge-0-248.png, Badge-0-1430.png

WordPress database error: [Unknown column 'actual_date_earned' in 'field list'] There isn't an actual_date_earned column in the wp_badgeos_achievements table, but there is a date_earned column.

I issued our last badge on September 8 without any issues, so the problem started somewhere between September 8 and September October 14. If I see this correctly in the Changelog BadgeOS 3.6.6 was released Oct.2? Was the issue caused by the new release?

Steps to Reproduce

  1. Set up Open Badges
  2. Add $wpdb->show_errors() after $success = $wpdb->insert() in function badgeos_update_user_achievements().
  3. Issue Open Badge through any user's profile page (/wp-admin/user-edit.php).

Result: Unknown column 'actual_date_earned'

the-wooninjas commented 2 years ago

Issue has been addressed and fixed, please upgrade to latest version 3.6.12. Thank you