SQL Error
| Project: | User Badges |
| Version: | 5.x-1.4 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
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

#1
I am experiencing this identical problem, also.
#2
Hello, sorry for the late reply!
Can you please check if you really have those tables on you DB?
#3
I have the same trouble :(
#4
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
#5
same problem. hopefully we can get some badges!
#6
Maybe we should try the badgers!
-B
#7
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?
#8
Automatically closed -- issue fixed for 2 weeks with no activity.