Closed (fixed)
Project:
User Badges
Version:
5.x-1.1
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
6 Dec 2008 at 20:16 UTC
Updated:
20 Jan 2009 at 17:10 UTC
Update.php fails and i cant find anything in the watchdog. all i'm left with is 10,000,000 of these:
Unknown column 'b.href' in 'field list' 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 = 0 ORDER BY b.weight, b.name in /home/site/public_html/includes/database.mysql.inc on line 174.
i'm guessing that those particular errors are because it did not upgrade.
Comments
Comment #1
icecreamyou commentedSame problem here, plus on every page I get a message with a list of the UIDs of users who have links to their profile on that page. Reverting fixed the issue. It looks like part of the problem is that the .info file says it's for 5.x-1.x-dev.
Comment #2
MrGeek commentedSame issue here with the list of UID's everywhere..
Comment #3
nunoveloso commentedThe UID message is fixed. Sorry, it was for debug and I forgot to delete it.
MrGeek I don't see why your update.php fails but it has nothing to have to user badges because if you check the .install file you can see conform hook_update_N.
Comment #4
icecreamyou commentedIt definitely has to do with user badges. There were no changes made to my site within 24 hours on either side of the user badge update. Immediately after uploading the new files I was getting error messages on any page; after running update.php (during which the only update was for user_badges) both updates failed; after the update there weren't any more errors but user badges didn't work at all. And of course there's the fact that the error messages have to do explicitly with user badges.
Here's the error that showed up immediately after replacing the files.
Comment #5
MrGeek commentedThe only update being made was for the user badge module.. It's not update.php that fails, it's the user badge update being run from update.php that is failing - giving a result message something to the effect of "unable to update user badges/unable to update tables" - i did not save the exact wording - but it was from the user badges update after uploading the new files.
Comment #6
nunoveloso commentedOk. It is strange because it works here. I'll take a look to it Tuesday. If anyone could do the same I'll appreciate ;)
Sorry for this issue but, like I said, it works out here.
Comment #7
icecreamyou commentedJust for more information: I'm running PHP 5.2, MySQL 5, D5.12.
Comment #8
nunoveloso commentedCould you please try this:
On line 33 of .install file, remove the `.´ (last char) and check of it solves. This s a typo that probably causes the error.
Comment #9
leeugene commentedsubscribe
Comment #10
leeugene commented#8 worked for me. was having same problem. thanks!
Comment #11
leeugene commentedcan't assign badges to roles. inactive only shows in the drop down to assign roles. i don't know if this is problem's related? there's no rid field in the table for user_badges_badges. does that mean anythign?
Comment #12
Abilnet commentedAfter upgrading to ver. 1.2 I got two "failed" messages when running "update.php"
After the upgrade badges were not published anymore. When going to user profile, the checkbox of the badge was not checked anymore. When checking it again and submitted, it did not save. Had to downgrade back to ver. 1.0 and now it works again.
Hope this helps.
Comment #13
Democron commentedSame problem here, can't assign badges to users after upgrade
Comment #14
fighter75 commentedsame probleme...
the error is
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. )' at line 6 query: CREATE TABLE user_badges_badges ( bid int(10) NOT NULL default '0', name varchar(50) NOT NULL default '', image varchar(80) NOT NULL default '', weight int(2) NOT NULL default '0', href VARCHAR(80) default . ) in /home1/******/public_html/******/includes/database.mysql.inc on line 174.tryin to install user_badges on D 5.14.
MySQL 5.0.67
PHP 5.2.8
Comment #15
nunoveloso commentedFixed @ 5.3