XF 2.3 Deleted all threads and reset thread count to zero

[sudhakar]

Idea is to clear complete thread and start fresh, have 5,28,000 post and 6900 topic / threads.

Used batch posts update and cleared all the thread, rebuilt cache and run all cron jobs too.

Still while creating new post, could see the topic count is 6901 instead of 1.

Help me reset topic / thread count to 0.

 

[Chromaniac]

yeah for that you would probably have to start with a fresh database. i do not think it is possible to start from thread id 1 without actually messing around with the database index entries.

 

[sudhakar]

yeah for that you would probably have to start with a fresh database. i do not think it is possible to start from thread id 1 without actually messing around with the database index entries.

Thanks for the instant reply, am willing to run queries in sql as well. XF thread view count reset to 0, still post count is not going to 1 for 1st thread id

 

[sudhakar]

No assistance from community for 3-4 days for simple query !