'Todays Posts' Error

[lduckfunk]

When my Forum users click 'Todays Posts' it comes up with
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 2 AND searchhash = '13d7d3605bac06dc782066b2bd65c70d' AND orderedids = '398,397,396,395,394,393,392,390,389,87,388,387,38 6,385' AND announceids = '8' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Sunday, September 9th 2007 @ 12:46:12 PM

This also happens when you request to 'View Users Posts' or 'View Users Threads' on Their profiles.

Help Please?

[Paul M]

How did you get to version 3.6.8 ?

That's a very old problem caused by a faulty upgrade about 4 versions ago now, you need to run a bit of sql to add the missing column.

[sql]ALTER TABLE search ADD completed SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT 1;[/sql]