XF 1.4 Thread URL reset

[CommanderMadi]

Hello,

I have had my forums up and closed for customization and testing purposes. I posted few test threads in different forums and now I deleted them. However, when I type new threads right now, the thread URL gets a number at its end that shows there was other threads created already. Example:

the first 4 thread I created generated the URLs:
www.mydomain.com/threads/thread.1
www.mydomain.com/threads/thread.2
www.mydomain.com/threads/thread.3
www.mydomain.com/threads/thread.4

After I deleted them and typed a new thread the URL showed up as:
www.mydomain.com/threads/thread.5

Are there any reset options or clearing cache possibilites that can make me start from thread.1?

 

[Liam W]

You would have to reset the auto increment value in the DB.

This can be done with the query

ALTER TABLE xf_thread AUTO_INCREMENT=1

But I wouldn't recommend it.

If you do run the query, do it with no threads.

Liam

 

[CommanderMadi]

Great. I already have no threads. I will do it right now and report back.

 

[CommanderMadi]

That did the trick. Thank you Liam