Welcome, Guest. Please Login or Register.
March 15, 2025, 07:30:17 PM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  English Help  |  multiple members in list after convert? « previous next »
Pages: 1 [2] Reply Ignore Print
Author Topic: multiple members in list after convert?  (Read 1757 times)
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #15 on: September 06, 2003, 07:55:21 PM »
Reply with quote

Ok so I ran that and got:
Your SQL-query has been executed successfully

SQL-query : [Edit] [Create PHP Code]
CREATE TABLE yabbse_members2(
PRIMARY KEY ( ID_MEMBER ) ,
KEY memberName( memberName( 30 ) ) ,
KEY dateRegistered( dateRegistered ) ,
KEY memberGroup( memberGroup( 30 ) ) ,
KEY birthdate( birthdate ) ,
KEY posts( posts ) ,
KEY lastLogin( lastLogin ) ,
KEY lngfile( lngfile( 30 ) )
) TYPE = MYISAM SELECT *
FROM yabbse_members
GROUP BY memberName;

RENAME TABLE yabbse_members TO yabbse_members_duplicates;

RENAME TABLE yabbse_members2 TO yabbse_members;

=====================

Ok that worked out in the members list link itself. It now shows 45 members.

Any way to fix the total displayed though as it still shows 87?
Logged
Shadow's Pawn
Support Team
YaBB God
*****
Posts: 597


ich soll nicht toten

ICQ - 8039201shadowpawn@hotmail.com WWW
Re:multiple members in list after convert?
« Reply #16 on: September 06, 2003, 08:59:35 PM »
Reply with quote

Have you clicked "Recount all board totals" yet?
Logged

apologize \A*pol"o*gize\, v. i. - To lay the foundation for a future offense.
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #17 on: September 06, 2003, 09:07:03 PM »
Reply with quote

ahhh all is well....for now.
Logged
Pages: 1 [2] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  multiple members in list after convert? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.179 seconds with 20 queries.