News:

SMF 2.1.6 has been released! Take it for a spin! Read more.

Main Menu

Remove old / previous warnings ?

Started by MoreBloodWine, October 07, 2011, 11:03:43 PM

Previous topic - Next topic

MoreBloodWine

Quote from: Illori on October 19, 2011, 03:03:33 PM
well if you do it manually you will break the connection to it elsewhere, so unless you know what you are doing dont do it.
So what (not the smart ass so what), your saying the ID's of id_comment are linked to other tables / rows or whatever ?

In either event it still boils down to a personal preference / quirk of mine so I would still love to reset the ID's, preferrably without screwing something up which is what I gather your trying to suggest I would do even if I ran the right query or whatever.
Want a sig like mine for your BTCGuild stats ? Then check this out: Spend-ur-Bits


Joker™

Quote from: MoreBloodWine on October 19, 2011, 03:01:55 PM
I didn't truncate the table because I had spam questions in there, I just opened up the table and deleted the stuff I needed to delete. I'd rather use a query to reset the ID's but if I have to I'll just delete the id_comment row and recreate it where the ID's will be reset any way. Resetting the ID's is just a personal preference / quirk of mine.

Tbh resetting an auto increment column may break out some other things. Any specific reason you are trying to do that?

I have seen a lot of users doing this and later on facing issues like duplicate keys etc etc.
Github Profile
Android apps
Medium

How to enable Post Moderation

"For the wise man looks into space and he knows there is no limited dimensions." - Laozi

All support seeking PM's get microwaved

Illori

the query you suggested on the prior page would not even fix the problem it would make it worse, try to learn about php and mysql then learn about how smf code works along with that table then you can go ahead and create a proper query in all the related tables to fix the problem

Advertisement: