multiple members in list after convert?

[necrosanct]

YaBB SE Version: 1.5.4
PHP Version: 4.3.2
MySQL Version: 4.0.x
Server Platform: Unix, Linux, or BSD
Link to Forum: www.necrosanct.com/yabbse

Problem Description:
Since I converted to the new forum from 1gold I had 2 of every member in the member list. Now I have some poeple up to as many as 4 on the member list.

Is there any way to fix this at all, without a total delete of the members that is?

[[Unknown]]

Try converting again, but this time selecting to purge the database.

-[Unknown]

[necrosanct]

As suggested in the conversion post I did purge but this is what happened to it after that.

I figure it might have to do with only one SQL Database on my server but do not know much on that to say if that is truly the reason.

[[Unknown]]

I wouldn't say that should be it...

Well, what you can do is this:

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;

Tell me if that helps at all.

-[Unknown]

[necrosanct]

Where would I put this at?

[Shadow's Pawn]

Run it in phpmyadmin.

[necrosanct]

Looked everywhere for something named phpmyadmin but could not find that anywhere...could you be more specific please.

[[Unknown]]

www.phpmyadmin.net

-[Unknown]

[necrosanct]

ok so I have myphpadmin now but where the heck on that is the place to add anything at? Looked around a bit but saw nothing that would let me add anything.

[Douglas]

Okay, now that you have phpMyAdmin, log onto it, select your database from the left side.  You'll see a window open on the right side.  Select the SQL or Query tab at the top.  In the big text area, put in the code that [Unknown] gave you.  

[necrosanct]

but what database? there are a ton on that left window

[necrosanct]

I have the following on the left window:

 phpbb_auth_access
 phpbb_banlist
 phpbb_categories
 phpbb_config
 phpbb_disallow
 phpbb_forum_prune
 phpbb_forums
 phpbb_groups
 phpbb_posts
 phpbb_posts_text
 phpbb_privmsgs
 phpbb_privmsgs_text
 phpbb_ranks
 phpbb_search_results
 phpbb_search_wordlist
 phpbb_search_wordmatch
 phpbb_sessions
 phpbb_smilies
 phpbb_themes
 phpbb_themes_name
 phpbb_topics
 phpbb_topics_watch
 phpbb_user_group
 phpbb_users
 phpbb_vote_desc
 phpbb_vote_results
 phpbb_vote_voters
 phpbb_words
 yabbse_banned
 yabbse_boards
 yabbse_calendar
 yabbse_calendar_holiday
 yabbse_categories
 yabbse_censor
 yabbse_instant_messages
 yabbse_log_activity
 yabbse_log_banned
 yabbse_log_boards
 yabbse_log_clicks
 yabbse_log_errors
 yabbse_log_floodcontrol
 yabbse_log_karma
 yabbse_log_mark_read
 yabbse_log_online
 yabbse_log_topics
 yabbse_membergroups
 yabbse_members
 yabbse_messages
 yabbse_polls
 yabbse_reserved_names
 yabbse_settings
 yabbse_topics

-----------------------------

Which one of those?

[Metho]

Icky. You have phpbb in the same database. I'd light myself on fire. But besides that, you're not selecting a table. Once you select your database, there should be several tabs on the right hand window (generally Structure, SQL, Export, Search, and Query) Click the SQL tab and then put [Unknown]'s stuff in there, then click 'Go'

Methonis

(In case you didn't get that, all the things you listed are TABLES. TABLES are within your DATABASE. So if you see all of those tables, you should see the SQL tab in the right hand window)

[necrosanct]

MySQL said:


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 'PRIMARY KEY (ID_MEMBER),
 KEY memberName (memberName(30)),

[[Unknown]]

Ooops, my bad.  Typo.

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;

-[Unknown]