Welcome, Guest. Please Login or Register.
March 15, 2025, 04:37:58 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 1755 times)
necrosanct
Noobie
*
Posts: 16


I ate llama!

multiple members in list after convert?
« on: September 01, 2003, 09:10:30 PM »
Reply with quote

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?
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:multiple members in list after convert?
« Reply #1 on: September 03, 2003, 03:58:34 AM »
Reply with quote

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

-[Unknown]
Logged
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #2 on: September 03, 2003, 04:47:02 AM »
Reply with quote

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.
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:multiple members in list after convert?
« Reply #3 on: September 04, 2003, 02:58:03 AM »
Reply with quote

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]
Logged
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #4 on: September 05, 2003, 02:26:42 AM »
Reply with quote

Where would I put this at?
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 #5 on: September 05, 2003, 02:42:55 AM »
Reply with quote

Run it in phpmyadmin.
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 #6 on: September 05, 2003, 11:47:19 AM »
Reply with quote

Looked everywhere for something named phpmyadmin but could not find that anywhere...could you be more specific please.
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:multiple members in list after convert?
« Reply #7 on: September 05, 2003, 09:44:46 PM »
Reply with quote

www.phpmyadmin.net

-[Unknown]
Logged
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #8 on: September 06, 2003, 01:23:18 AM »
Reply with quote

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.

Logged
Douglas
aka The Bear
Support Team
YaBB God
*****
Posts: 1050


Bears rule! Llamas rule too!

WWW
Re:multiple members in list after convert?
« Reply #9 on: September 06, 2003, 01:58:31 AM »
Reply with quote

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.  :)
Logged

Need help? Please SEARCH first.  No need for a bad attitude, we like helping positive minded people.
ComeHit.us Short URL  redirection svcs with YSE powered forums, COMING SOON!
Want to say thanks?  Check out http://comehit.us/?u=3
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #10 on: September 06, 2003, 02:09:41 AM »
Reply with quote

but what database? there are a ton on that left window
Logged
necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #11 on: September 06, 2003, 02:11:41 AM »
Reply with quote

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?
Logged
Metho
Sr. Member
****
Posts: 342


I'm a llama!

Re:multiple members in list after convert?
« Reply #12 on: September 06, 2003, 02:42:08 AM »
Reply with quote

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)
« Last Edit: September 06, 2003, 02:43:34 AM by Metho » Logged

necrosanct
Noobie
*
Posts: 16


I ate llama!

Re:multiple members in list after convert?
« Reply #13 on: September 06, 2003, 03:24:12 AM »
Reply with quote

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)),
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:multiple members in list after convert?
« Reply #14 on: September 06, 2003, 07:00:46 PM »
Reply with quote

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]
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.039 seconds with 20 queries.