Badges missing after upgrading moodle from 2.8.3 to 3.2.1

Badges missing after upgrading moodle from 2.8.3 to 3.2.1

by Mohammad kabir -
Number of replies: 2

moodle version : 3.2.1

Parent theme : Bootstrapbase: 2.3.0 

I have upgraded moodle from 2.8.3 to 3.2.1 and missing badges.  How can I get badges back?

Let me know if you need more info. Thanks in advance. 

Average of ratings: Useful (1)
In reply to Mohammad kabir

Re: Badges missing after upgrading moodle from 2.8.3 to 3.2.1

by Mohammad kabir -

Please see the attachment.

Here I had 3 badges but all are disappeared , instead an old badges showing.

How can I get back my badges?

NB: Badges disappeared when I upgrade moodle2.8.3 to moodle 3.2.1

Attachment badges.png
Average of ratings: Useful (1)
In reply to Mohammad kabir

Re: Badges missing after upgrading moodle from 2.8.3 to 3.2.1

by Mohammad kabir -

By running query I found  badge:

 https://beta3.dvm.iktsenteret.no/pluginfile.php/7173/badges/badgeimage/152/f1


 So data is in database and file is in moodleData folder. But badges not showing in badges->manage badges. Is there any permission issue or anyother issue involved to show badges ?

If anybody has any idea?  Thanx in advance.


NB:

The query I runned:

SELECT u.username, b.name AS badgename, f.contextid, f.itemid, CONCAT (f.contextid,'/badges/badgeimage/',f.itemid,'/',SUBSTRING_INDEX(f.filename,'.',1 ))

 AS badgeimage FROM mdl_badge_issued AS d JOIN mdl_badge AS b ON d.badgeid = b.id JOIN mdl_user AS u ON d.userid = u.id JOIN mdl_files AS f ON b.id = f.itemid WHERE (b.status = 1 OR b.status = 3) AND

 (f.component = 'badges' AND f.filename = 'f1.png') ORDER BY u.username

Average of ratings: Useful (1)