How to hard delete all soft deleted blog entries?

[Alfa1]

My blog installation has a large number of soft deleted blog entries. I want to hard delete these. What is the best way to do so?
Is there a query I can use?

Would something like this...

[Alfa1]

We are now at 3 million unique monthly visitors.

We have also broken another record, as we now have 200.000 members. I have pruned over 70.000 inactive accounts over time, the last userid...

Migrating my big board away from vbulletin.

[Alfa1]

vbulletin 5 has reached Gold status quite some time ago.

[Alfa1]

Currently the page does not show anything useful because the config file does not have a source database anymore and the page therefore shows a database error.

[Alfa1]

The theme is pretty similar to launchforum and a few other solutions.

[Alfa1]

I have no clue. In 2005 someone did the conversion for me. The original database no longer exists.
How can I check this?

[Alfa1]

In 2005 I migrated my site from webwiz to vbulletin with impex. This created a mass of database fields, like:
importattachmentid
importavatarid
importcustomavatarid
importcustomprofilepicid...

[Alfa1]

vb4 still has 850 bugs and its more than 3 years after release. So you cant realistically expect vb5 will be bug free anytime soon. Probably never.

[Alfa1]

It took a few minor tweaks to make vbulletin 3 compatible with mysql 5.5
The tweaks were posted here in the support forum by others. Especially Paul.

I know there is not going to be...

[Alfa1]

Weird. But if you show VMs then why not PMs?

[Alfa1]

Does vb4.2 support MySQL 5.6?
Are there any issues with MySQL 5.6?

http://dev.mysql.com/tech-resources/...mysql-5.6.html
http://www.oracle.com/us/corporate...

[Alfa1]

Now that MySQL 5.6 is released, I wonder if its possible to upgrade from MySQL5.5 to 5.6 while running vb3.8.7

Is there anything that I need to fix / modify?

[Alfa1]

Why on earth would you want to increase your post_max_size to 200MB and upload_max_filesize to 100mb? I would keep those low if you can. If you allow users to post or upload massive sizes then its easier...

[Alfa1]

We are at 2.5 million unique monthly visitors now and rapidly climbing. I expect that we will hit 3 million unique monthly visitors in a few months.

Still using good old vb3.8

[Alfa1]

Upgrade to vb 4.2 or 3.8.7
You can find the fixes on this forum. The first thing to do is find all instances of 'TYPE =' and replace by 'ENGINE ='
There are some more fixes. Search my posts...

[Alfa1]

Facebook is actively tweaking its system in order to get group discussions more on topic. I'm certain that facebook will get it right sooner or later.

There are many discussions that people...

[Alfa1]

If you think that PHPFox is a facebook clone, then you are not looking at it close enough. Yes, it certainly has many facebook functions. This is correct. But it also has many other functions. You could...

[Alfa1]

I do not have vb5, and have not read any information anywhere about such functionality being available. If it is, then thats very nice....

[Alfa1]

My statement referred to yearly fees. This post explains pretty well why I am already half way out the door:

The post was never answered.

Does that explain it to you?
...