SQL Error

Spinetta - February 23, 2009 - 12:01
Project:User Badges
Version:5.x-1.4
Component:Miscellaneous
Category:support request
Priority:critical
Assigned:Unassigned
Status:closed
Description

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

dccircuit - February 25, 2009 - 18:26

I am experiencing this identical problem, also.

#2

Nuno Veloso - March 12, 2009 - 10:29

Hello, sorry for the late reply!

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

#3

yAndre - April 20, 2009 - 14:47

I have the same trouble :(

#4

brianbrown - April 24, 2009 - 20:00

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

RikiB - May 3, 2009 - 02:10

same problem. hopefully we can get some badges!

#6

brianbrown - May 6, 2009 - 04:21

Maybe we should try the badgers!
-B

#7

Likeless - September 7, 2009 - 21:08
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?

#8

System Message - September 21, 2009 - 21:10
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.