User titles doubled up

[Lene]

Not sure if this should go here or under bugs, but feel free to move if on the wrong board...

First I installed 3.7, then I imported from phpBB 2.4(I think), and now I ugraded to 3.8. Not totally sure if this problem was present before the upgrade, but the problem is that user titles are doubled up, one under the other, and some are messed up completely, see all posts here: http://www.hamsterforening.no/vbulletin/showthread.php?t=1336

I've run all the counter updates, and checked everywhere I could thing of, but can't seem to fix the problem. Any help will be greatly appriciated :)

[Lene]

Update:
I've search the database, and I found this:



INSERT INTO vbusertextfield VALUES('1', NULL, NULL, '', '', NULL, NULL, '<b>Syrisk</b>');
INSERT INTO vbusertextfield VALUES('2', NULL, NULL, '', '', NULL, NULL, '<b>Syrisk</b>');
INSERT INTO vbusertextfield VALUES('4', NULL, NULL, NULL, NULL, NULL, NULL, '<b>Tysk felthamster</b>');
INSERT INTO vbusertextfield VALUES('5', NULL, NULL, NULL, NULL, NULL, NULL, '<b>Admin</b><b>Moderator</b><b>Roborovski</b>');


etc.
I've searched the whole admincp and the online manuelt, but can't seem to find where I can remove this. So help still needed ;)

[Jerry]

Check the usergroups and the ranks.

[Lene]

I did, and nothing unusual there. I removed the lowest rank to check if that did anything, and it didn't do more than removing what is was supposed to, but not the extra title. It seems that the AdminModeratorRoborovski (roborovski was my lowest title) is connected to the lowest rank, and the others just show up doubled.

[Jerry]

Most bizarre, looks like field7 ?

So this would clear them all out :



UPDATE vbusertextfield SET field7=''

[Lene]

Ok, but where/how? I'm not too used to working with databases, so the teaspoon might be useful here :p

[Lats]

How to run a query (http://www.vbulletin.com/forum/showthread.php?t=169111)

[Lene]

Thanks, Lats.

I tried the query, and got an error message:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'field7' in 'field list'

If it helps at all, here are the text from the db, which is before the table I gave in my first post:



DROP TABLE IF EXISTS vbusertextfield;
CREATE TABLE `vbusertextfield` (
`userid` int(10) unsigned NOT NULL default '0',
`subfolders` mediumtext collate latin1_danish_ci,
`pmfolders` mediumtext collate latin1_danish_ci,
`buddylist` mediumtext collate latin1_danish_ci,
`ignorelist` mediumtext collate latin1_danish_ci,
`signature` mediumtext collate latin1_danish_ci,
`searchprefs` mediumtext collate latin1_danish_ci,
`rank` mediumtext collate latin1_danish_ci,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci;

[Lats]

Carrying on from Jerry's guess that it's field7, try this...

UPDATE vbuserfield SET field7=''

[Lene]

Lats, are you sure I then won't end up deleting something that's supposed to be there?

Jerry, what made you say is was field7?

[Jerry]

Jerry, what made you say is was field7?

Being half asleep and mostly brain dead I would of thought :D

It should of been this :



UPDATE vbusertextfield SET rank=''

[Lene]

Hehe, that happens to us all;)

Anyway, it fixed the problem, so yay, and thank you very much :)

EDIT: Shouldn't have said that, as when I updated the user ranks and titles through Maintanace, it came back.

[Jerry]

EDIT: Shouldn't have said that, as when I updated the user ranks and titles through Maintanace, it came back.

Then it is the rank titles being applied to the users.

[Lene]

Yes, I understand that it's connected somehow, I don't understand how, though. The user ranks looks normal in the Admin cp. So how do I get rid of it permenantly?