smf_members table confusion

[Srinib]

I just checked the phpMyAdmin database for my test forum.
I am confused to see there are 2 tables related to members.
smf_members and smf_sgcmembers. I understand that sgc is the short form of my domain name.
There are 11,578 members in smf_members.
But my actual member list is only 58. smf_sgcmembers show 58 rows.

• Are the members in table smf_members spammers?
• Why are there 2 sets of tables? like

• smf_members and smf_sgcmembers,
• smf_calendar and smf_sgccalendar,
• smf_categories and smf_sgccategories and so on...

[MrPhil]

What does Settings.php show for the "database_prefix" it's using? Did it somehow get changed from "smf_" to "smf_sgc"? Whoever did that must have created a bunch of tables, and perhaps copied over part of your original tables. Did you have someone, or your host, do some work on your forum or site, perhaps to deal with a spammer problem? What did they do? Did you install a new version of SMF, rather than upgrade to the new version?

[Srinib]

database_prefix in Settings.php shows $db_prefix = 'smf_sgc'
I installed a new version of 2.0.2. I downloaded the zip file from SMF(NOT from Fantastico of my host)
I didnot check soon after the install, maybe 3 or 4 months back. Just yesterday i was checking for something else, and there are rows in both smf_members and smf_sgcmembers tables.
But in the members area of the forum, the members i see are from smf_sgcmembers and NOT from smf_members.

[Matthew K.]

They must be two different SMF installations in the same database.

[NanoSector]

The tables like smf_members are from a different installation, you installed two installations in the same database yet with different prefixes, therefore it shows double tables.

[Srinib]

Two installations in the same database? I am not sure about that when i was installing. But one thing i remember, while installing, for the Table prefix: i gave smf_sgc. Maybe that could be the reason for smf_sgcmembers, smf_sgccalendar and a lot of other tables with smf_sgc.

I am still testing my forum. Till now i have no issues. Do you guys think this double installation(which i am not sure) or the same tables with two prefixes, ie. smf_ and smf_sgc will create some issues to my forum in the latter stages?