v2.20 Forum Leaders

[Zeoran]

After upgrading to 2.20 and clicking on this mysterious link, I get the following:

Database error in vBulletin 2.2.0:

Invalid SQL:
SELECT
userfield.field2, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1

mysql error: Unknown column 'userfield.field2' in 'field list'

mysql error number: 1054

Date: Friday 02nd of November 2001 10:12:19 AM
Script: http://www.guardianbrotherhood.org/f...wgroups.php?s=
Referer: http://www.guardianbrotherhood.org/forums/index.php?s=

[Chen]

Have you removed your Location field from the profile?

[salizar]

Yeah I'm getting the same issue.

And yes the location field in my profiles have been removed.


PS please send me a PM as to where I"m supposed to enter my VB customer information...


Thanks

[Chen]

http://www.vbulletin.com/members/forums.php <= there.

Anyway, remove this bit:

userfield.field2,

(including the comma!)
from showgroups.php. You'll need to make some template changes as well.

[Zeoran]

what template changes do I need to make?

[salizar]

Yes please post the template changes that should be made...
thanks

[Chen]

Edit your showgroups_xxx templates, and remove the Location field from them.

[Zeoran]

I'm still getting errors from VB about this missing field. Can someone post exact instructions on how to remove the location field from the templates? I see it in the template, but I'm not confident enough in my knowledge of php to just delete it without some more exact instructions. (ie. delete from "..." to "...")

TIA

[Fusion]

Am I understanding this right? The latest ver bugs on a field people can include/exclude optionally? And you're saying this requires hacks to fix? I'm sorry, but that's just a bad, bad way to do things. If a field is optional, then the relevant files SHOULD include code to address this. Come on, Devs.

[tubedogg]

95% of users never change anything about the board, let alone remove custom profile fields. It was a mistake to bet on it but yes it requires a hack to fix it...how do you think bugs are fixed?

[Fusion]

Heheh, you so don't want me to answer that, tubedogg.
If it isn't already made, maybe it's a thought to include a repair script to restore such fields in the database.

[Freddie Bingham]

Change userfield.field2, to userfield.*,

[Zeoran]

where should I change that... exactly what files? what templates?

For those of us noobs who haven't memorized the entire file system, we need explicit instructions please.

[tubedogg]

The file where you are getting the error...showgroups.php

[Rick Horwitz]

Ok guys, how about a step by step, hold my hand walk through. Obviously I'm not the only one who is lost.

Either that or release 2.2.1 to take care of this and what seems to be a slew of other bugs in the newest (last... yeah right) release of ver 2.x.