Search forum dosn't work

[Nj0y]

Hi there first off all i want to say this forum is great, but i need a little help here i hope you guy's can help me out.

1. Error

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 (6, '86.86.224.20', 1, 'MrGrind', '', 'post.dateline', 'DESC', 0.00547, 1, '3', 1171098020, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:3;s:7:\" MrGrind\";}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\";}}', '70bb083ed4ffb0755d4d856aeaedea9e', 1);

MySQL Error : Unknown column 'completed' in 'field list'
Error Number : 1054
Date : Saturday, February 10th 2007 @ 10:00:20 AM
Script : hard2handle| Gaming clan Database Error
Referrer : hard2handle| Gaming clan - View Profile: MrGrind

2. error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 7 AND searchhash = 'e994d57e853003b06188cbe91f91b79e' AND orderedids = '24,23,7' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Saturday, February 3rd 2007 @ 09:19:14 AM
Script : hard2handle| Gaming clan
Referrer : hard2handle| Gaming clan - Members List

3. Error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'dfb11d1653e4495aac2aca53208d0c4f' AND orderedids = '23,24' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Sunday, February 4th 2007 @ 02:48:19 AM
Script : hard2handle| Gaming clan Database Error
Referrer : hard2handle| Gaming clan

4. Error

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid

FROM forum AS forum;

MySQL Error : Unknown column 'lastthread' in 'field list'
Error Number : 1054
Date : Wednesday, February 7th 2007 @ 03:44:56 AM
Script : http://forum.hardtohandle.net[FONT=verdana,geneva,lucida,'lucida grande',arial,helvetica,sans-serif,mon]/[/font]

Can someone tell me how to resolve this problem?
And tell me the best way to resolve this, if there are mods for it, could you please post a link for download.


I realy hope you guys can help me out.

Kind Regards,
Nj0y/Dennis

MySQL Error : Unknown column 'completed' in 'where clause'
MySQL Error : Unknown column 'lastthread' in 'field list'

add those two fields, search this site for the first error, i already answered it

[Nick R]

I'll get you the 2 queries you need to run. Give me 10 mins.

[Nick R]

Query 1:

ALTER TABLE forumssearch ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT 1

Query 2:

ALTER TABLE forum ADD lastthread VARCHAR(250) NOT NULL

Or both together:

ALTER TABLE forum ADD lastthread VARCHAR(250) NOT NULL;
ALTER TABLE forumssearch ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT 1;

[Nj0y]

Thanks for the repley's i hope they work I'm glad i post this becouse i was going crazy to figure it out myself

*Edit*

Those are the following errors:

[quote]Problem resolved!! THanks!!! You may close this thread ;)[/qoute]

Again thanks for all your help!!

[XxHunTerxX]

im having the same problem and that is getting me crasy i reinstalled vb like 4 time
can u guys explain more
what is Query
and where can i put those codes u posted
i didnt get it
tnx

[Nj0y]

You can put it in phpmyadmin if you don't know how to reach it ask your hosting!

And i still got annother problem with Exporer i will post a screen.


Translation:

The website "link" can't be opend, the treatment is ended
(bad englisch i know!)

Hope you guys can help me out,

Kind regards,
Nj0y

[Nick R]

The actule english error is:

Internet Explorer cannot open the Internet site http://forum.hardtohandle.net/forumdisplay.php?f=2

Operation aborted

Contact your host.

[phantasm]

I'm having the same exact problem
here are the results after running the queries:

ALTER TABLE forumssearch ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT 1

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

[phantasm]

When running the second query I get the following:
ALTER TABLE forum ADD lastthread VARCHAR(250) NOT NULL
An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'lastthread'


Please help