import members problem

[risestar]

I am importing files and members from ubb and for some reason it wont delete the existing ones.

Now I have duplicates of all of them so instead of 6000 I have 12000

How can I delete the old ones so I can reimport them?

thanks

[bigsoccer tech]

i have a not dissimilar problem that works under this thread title:

i imported my 5500 users, but it tells me I have 7500. Any idea why?

[risestar]

It seems to be a bug that wont allow you to delete existing data in the db for the members. If the initial importation is flawless, no prob. In my case, I ran into a prob and it duplicated the members when I tried again.

[werehere]

I would ask about it before *I* would do it, but you should be able to either drop the table and start again, or delete the data out of it right?

[John]

You should be able to select an option when you start to import users to wipe all existing users. If you want to do this manually from the MySQL client:


DELETE FROM user WHERE usergroupid<>6


This will delete all users except admins.

The other possibility was that UBB was miscounting the number of members. I find this unlikely, but we found that we had 2000 extra posts appear when we imported posts.

John

[risestar]

I'm on a dedicate dsecure server so I don't have direct access to server, however, I reinstalled files and tryed again and was successful the second time.

I was not able to clear the db without reinstalling.