Using Drupal 5.x and User Badges 5.x-1.4 - I installed the module and enabled it, and now I'm seeing SQL errors at the top of every page. I'm fairly new to drupal & not sure where to even begin troubleshooting.

The error in question is:

* user warning: Table 'solstice_coalition.user_badges_badges' doesn't exist query: SELECT DISTINCT b.bid, b.weight, b.name, b.image, b.href FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 1 ORDER BY b.weight, b.name in /home/solstice/public_html/clients/coalition/includes/database.mysql.inc on line 174.
* user warning: Table 'solstice_coalition.user_badges_badges' doesn't exist query: SELECT DISTINCT b.bid, b.weight, b.name, b.image, b.href FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 1 ORDER BY b.weight, b.name in /home/solstice/public_html/clients/coalition/includes/database.mysql.inc on line 174.
* user warning: Table 'solstice_coalition.user_badges_badges' doesn't exist query: SELECT DISTINCT b.bid, b.weight, b.name, b.image, b.href FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 1 ORDER BY b.weight, b.name in /home/solstice/public_html/clients/coalition/includes/database.mysql.inc on line 174.
* user warning: Table 'solstice_coalition.user_badges_badges' doesn't exist query: SELECT DISTINCT b.bid, b.weight, b.name, b.image, b.href FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 1 ORDER BY b.weight, b.name in /home/solstice/public_html/clients/coalition/includes/database.mysql.inc on line 174.
* user warning: Table 'solstice_coalition.user_badges_badges' doesn't exist query: SELECT DISTINCT b.bid, b.weight, b.name, b.image, b.href FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 2 ORDER BY b.weight, b.name in /home/solstice/public_html/clients/coalition/includes/database.mysql.inc on line 174.

My site is at http://COA.BadAve.net but is currently closed to new users as it's under heavy development. I need to get this site up & function as soon as possible and the badge functionality is critical.

Any and all help with this would be GREATLY appreciated!

Thanks,
Spinetta

Comments

dccircuit’s picture

dccircuit commented

I am experiencing this identical problem, also.

nunoveloso’s picture

nunoveloso commented

Hello, sorry for the late reply!

Can you please check if you really have those tables on you DB?

yAndre’s picture

yAndre commented

I have the same trouble :(

brianbrown’s picture

brianbrown commented

I have the same issue also. The module is not creating the table, even after uploading a badge:
user_badges_badges
Badges? BADGES?!? I don need no stinkin' BADGES!
Regards,
Brian

RikiB’s picture

RikiB commented

same problem. hopefully we can get some badges!

brianbrown’s picture

brianbrown commented

Maybe we should try the badgers!
-B

Richard Blackborder’s picture

Richard Blackborder commented
Status: Active » Fixed

I corrected a syntax error in the latest version of the module relating to DB creation. Can you try uninstalling your current version (use the link on the modules admin page), then installing the new release?

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.