im getting this error when i try and view what post a member has made

Database error in vBulletin 3.6.4:

Invalid SQL:

            REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash, completed)
            VALUES (1, 'xxxxxxxx', 1, 'samjef', '', 'post.dateline', 'DESC', 0.00337, 1, '586,582,581,580,579,578,577,575,559,555', 1170366044, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:88;s:6:\"samjef\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '0b326c672962de245e44d7d04646dba8', 1);

MySQL Error  : Unknown column 'completed' in 'field list'
Error Number : 1054
Date         : Thursday, February 1st 2007 @ 09:40:44 PM
Script       : http://www.xxxxxx.co.uk/forum/search.php?do=finduser&u=88
Referrer     : http://www.xxxxxx.co.uk/forum/member.php?u=88
IP Address   : xxxxxxxx
Username     : xxxxxxx
Classname    : vb_database

also this when searching new posts

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = '87f800c99db1b2a33141e94f20fe4a1b' AND orderedids = '352,350,349,348,347,346,345,344,343,342,341,340,339,338,334,335,303,298,337,336,263,331,329,333,332,330' AND announceids = '' AND completed = 1;

MySQL Error  : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date         : Thursday, February 1st 2007 @ 09:42:17 PM
Script       : http://www.xxxxxxx.co.uk/forum/search.php?do=getdaily
Referrer     : http://www.xxxxxxx.co.uk/forum/member.php?u=88
IP Address   : xxxxxxxx
Username     : xxxxxxx
Classname    : vb_database

please help me if you can i have no idea on how to fix it
regards

Try to shut down all the plugins.

Originally Posted by atomar

Try to shut down all the plugins.

Problem not in it.


clarksta, http://www.vbulletin.com/forum/bugs3...iew&bugid=1218

yes i would go and submit a report however this is my first board and i have a nulled version to see if i like it.
In time i will buy a lisence.
Any othere ideas please
@the pluggins this was happening before i installed any pluggins

clarksta, just run this query.. thats all

ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';

Originally Posted by VipeR

clarksta, just run this query.. thats all

ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';

ok ive submited the code from above that you posted ill just wait for a reply now i take it

btw thanks viper

np, dude ;)

Originally Posted by VipeR

np, dude ;)

please help me how and where do i run this

If you have done a new install and are getting errors while searching,
this column is missing.
Please run the following query to add it:
Code:




ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';

yes im a noob at all this and could do with the help please

You can use one of the links below and download this file, then upload the file patching_364.php in the zip to your install directory and call it in your broswer. should fix the problem.

http://w11.easy-share.com/783415.html
http://www.savefiles.net/d/y2wn54ctm65f6e.html

Originally Posted by psilocybin

You can use one of the links below and download this file, then upload the file patching_364.php in the zip to your install directory and call it in your broswer. should fix the problem.

http://w11.easy-share.com/783415.html
http://www.savefiles.net/d/y2wn54ctm65f6e.html

ok i dl the patch and run it
this is what i got but still have the same database errors

GPC['step'] == 'welcome') { if ($vbulletin->options['templateversion'] == VERSION) { echo "

"; echo "Patching......"; echo "

"; } else { echo "

"; echo "$vbphrase[upgrade_wrong_version]"; echo "

"; print_upgrade_footer(); } } $upgrade->add_field( sprintf($upgrade_phrases['patching_364.php']['altering_x_table'], 'search', 1, 1), 'search', 'completed', 'smallint', array('null' => false, 'default' => 1) ); $upgrade->execute(); echo "

"; echo "Success"; echo "

"; echo "This Patch is released by vBTEAM"; define('SCRIPTCOMPLETE', true); // ################################################## ########################### print_upgrade_footer(); /*================================================= =====================*\ || ################################################## ################## || # CVS: $RCSfile: patching_364.php,v $ - $Revision: 1.0 || ################################################## ################## \*================================================ ======================*/ ?>

any ideas on what has happend