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

icecreamyou’s picture

Same 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.

MrGeek’s picture

Same issue here with the list of UID's everywhere..

nunoveloso’s picture

The 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.

icecreamyou’s picture

It 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.

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 /.../public_html/includes/database.mysql.inc on line 174.
MrGeek’s picture

Title: Can't upgrade to 5.x-1.1; breaks site » Can't upgrade to 5.x-1.1

The 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.

nunoveloso’s picture

Ok. 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.

icecreamyou’s picture

Just for more information: I'm running PHP 5.2, MySQL 5, D5.12.

nunoveloso’s picture

Could 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.

leeugene’s picture

subscribe

leeugene’s picture

#8 worked for me. was having same problem. thanks!

leeugene’s picture

can'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?

Abilnet’s picture

After 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.

Democron’s picture

Same problem here, can't assign badges to users after upgrade

fighter75’s picture

same 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

nunoveloso’s picture

Status: Active » Fixed

Fixed @ 5.3

Status: Fixed » Closed (fixed)

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