How to reset ID Members?

[MESWEB]

I delete all members from my site. How to reset ID?

[Kindred]

how/why did you delete all members?

[MESWEB]

Most spamers.

[Ninja ZX-10RR]

Plus, your site gives me a 105 error atm.

[MESWEB]

Plus, your site gives me a 105 error atm.

What do You mean? What error 105?

[Ninja ZX-10RR]

I mean what the attached screenshot says.

The translation (as it's italian) for it is: impossible to solve domain's name, check your network (done) and your DNS configuration (can't as only my ISP could but it's related to your site as it's the only one not working to me).

[Kindred]

(you neglected to answer) HOW did you delete all members?

[MESWEB]

I mean what the attached screenshot says.

The translation (as it's italian) for it is: impossible to solve domain's name, check your network (done) and your DNS configuration (can't as only my ISP could but it's related to your site as it's the only one not working to me).

Sorry I just forget update my profile. This is my site obeznany.pl

(you neglected to answer) HOW did you delete all members?

Just delete all entry in MySQL database "members".

[Dragooon]

Well...what about the posts? And what do you mean by reset?

[MESWEB]

All posts deleted with spamers. Reset:
Now when someone register smf give him ID. Now ID is about 29000+. I want restet ID to 1 because My is 1. Next user should be 2 etc.

[vbgamer45]

You have to change the auto increment column on the members table.

[MESWEB]

You have to change the auto increment column on the members table.

There is no auto increment column on the members table. In members table is only me with my profile details.

[margarett]

If you deleted all members and posts, why don't you just reinstall SMF?

[MESWEB]

Not all posts. I just leave My posts, stats, settings. SO IS THERE ANY OPTION TO RESET ID?

[margarett]

Yes, there is as vbgamer told you

You have to change the auto increment column on the members table.

Code Select Expand

ALTER TABLE smf_members AUTO_INCREMENT = 2
Assuming that your user is ID 1 and that your prefix is smf_

[kat]

Wild idea, this... Assuming that you don't have a backup to restore, have you asked your host if they have one?

[MESWEB]

I have Direct Admin. Smf installed from INSTALLATRON. I setup Auto Backup but I dont know wher is backup file.

[MESWEB]

Code Select Expand

ALTER TABLE smf_members AUTO_INCREMENT = 2
Assuming that your user is ID 1 and that your prefix is smf_

Is working. Thanks.

[Kindred]

If you deleted things directly in the database, then you have likely screwed things up as well..

unless you know exactly what you are doing, you should never do that - because there are multiple inter-related tables involved with both members and messages.

[Eathuis]

It was abit exteme to delete the whole "smf_members" (assuming your forums database prefix is smf_) table, when you could have just manually done this on the forums. More time consuming I know, but ALOT safer and would have been considerably less problematic.