Mysql command

[Sco]

Hello,

Im wondering how i can get all the forums to be deleted with a command on Vbulletin. With Execute SQL Query. Im using Vb3.5 Release 2 Thanks

[Andreas]

You mean delete all Posts/Threads?


truncate post;
truncate post_parsed;
truncate thread;
truncate word;
truncate postindex;


The rebuild counters.

[Marco van Herwaarden]

I think he wants to delete forums Kirby.

[Andreas]

well ... then add

truncate forum;


to the List ;)
(I also forgot subscriptions, deletionlog, editlog, ...)

[Sco]

Hello,

"An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'sco_forum.forum' doesn't exist"

hmm, i supose ill have to go through deleting all of them manually.

[Andreas]

That's one possibility.
But you could also just add your Table-Prefix.

Mental note: Why on earth does everybody use Table-Prefixes?