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 !

 

[Digital Doctor]

== Options: ==
(1) Full database (posts, member account and passwords, lots of other stuff) -> "delete all posts" [ This is likely hard ]
(2) New Install -> import all member accounts [ probably easier ]

one of the forum migration experts might be able to help.

 

[Digital Doctor]

could see the topic count is 6901 instead of 1.

reset it to 10000 ?

 

[briansol]

delete the records to clear the data.
truncate the table to reset the auto increment and clear the data (among other differences)

TRUNCATE TABLE table_name;

 

[sudhakar]

delete the records to clear the data.
truncate the table to reset the auto increment and clear the data (among other differences)

TRUNCATE TABLE table_name;

Thank you and which table to truncate.

 

[sudhakar]

== Options: ==
(1) Full database (posts, member account and passwords, lots of other stuff) -> "delete all posts" [ This is likely hard ]
(2) New Install -> import all member accounts [ probably easier ]

one of the forum migration experts might be able to help.

1st step tried
2nd step done with fresh install and used backup of full database instead of members only import.
2nd one, even I have installed fresh. I need entire design and forum customisations I have done. So we cannot upload members only.

 

[briansol]

Thank you and which table to truncate.

xf_post