PDA

View Full Version : [fixed] Forum Leaders error


Rick Horwitz
Mon 5th Nov '01, 5:40pm
This is what I get when I tried to access the Forum Leaders.

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: Monday 05th of November 2001 02:34:00 PM
Script: http://www.explorerforum.com/forums/forums/showgroups.php?
Referer: http://www.explorerforum.com/forums/index.php?
Rick Horwitz
Tue 6th Nov '01, 2:14am
BTT
tubedogg
Tue 6th Nov '01, 5:16am
http://vbulletin.com/forum/showthread.php?s=&threadid=32197&highlight=userfield.field2
Rick Horwitz
Tue 6th Nov '01, 4:37pm
What does it mean Fixed? Will it be fixed in an upcoming release? Do I download the file again now and re-install it? Or do I have to follow the scattered instructions in the other thread?
Steve Machol
Tue 6th Nov '01, 7:23pm
'Fixed' means it'll be part of the next release. Meanwhile if you want to implement the fix now you'll need to follow the instructions if they are given. (Some fixes are too complicated to post.)
Rick Horwitz
Fri 16th Nov '01, 5:34pm
This is NOT fixed in 2.2.1. There are 2 instances of userfield.userfield2 in the showgroups.php file. Only one of them has been changed to userfield.*. Both must be changed to eliminate the error.
Freddie Bingham
Fri 16th Nov '01, 5:40pm
Have you tried the version up now?
Rick Horwitz
Fri 16th Nov '01, 6:48pm
Depends... did you change it since this morning? If so it would be nice to have yet a different version number so we could always be sure we have the latest version.
Freddie Bingham
Fri 16th Nov '01, 6:50pm
I think it was changed 6 hours ago.

If you wish to continue the debate regarding this than there a few threads open on it.
Rick Horwitz
Fri 16th Nov '01, 8:54pm
Originally posted by freddie
I think it was changed 6 hours ago.

If you wish to continue the debate regarding this than there a few threads open on it.

Oh brother... This is a no brainer. You change the downloadable file you change the version number. PERIOD.

Anything less and you're just looking for more confusion.

I don't want to debate. I want to know I'm running the LATEST MOST STABLE version of the software.