After installing I tried to see the work of the module, went to configuration page, uploaded an image and tried to associate that image with a role and got an error message: There was a problem saving the badge information into the database.

Looked in the logs and found:
Table 'site_dbname.user_badges_badges'; doesn't exist query: user_badges_get_badges SELECT DISTINCT b.bid, b.weight, b.name, b.image FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 2976 ORDER BY b.weight, b.name in /home/site/public_html/includes/database.mysql.inc on line 172.

In this error log I don't like double '_badges_badges'. Could it be the reason?

Comments

heine’s picture

heine commented

This table is created when the module is first enabled. Did you receive an error when you enabled user_badges?

To try the table installation again, first execute the query:

DELETE FROM system WHERE name = 'user_badges';
yngens’s picture

yngens commented

I did and everything works now. Thanx. Does this module work with flatforum? Should user badge appear under the users picture in comments? For now I can only see badges in user profiles.

heine’s picture

heine commented
Category: bug » support
Status: Active » Fixed

You need to adapt your theme to display the badge. See README.txt for details.

yngens’s picture

yngens commented

Thanks Heine, I have successfully got it worked in flat forum. I guess in the beginning I had problem because the module does not clean the table, but just tries to install as if the tables are not there. And actually my website is an upgrade from 4.7 where I used this module too. So I guess MySql table structure or smth for the module was old.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)