problem in the search engine

[Nwras]

Hae.

I have a problem in the search engine as if it were located on the topic at the Forum showed me this letter that there is no themes or error database ..

Database error in vBulletin 3.6.0 Release Candidate 2:

Invalid SQL:

REPLACE INTO search (userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash)
VALUES (2, 0 ,'212.35.89.74', 0, 'نعتذر', '', '', 'lastpost', 'DESC', 0.08813, 0, '3512,1735,1547,1304,922,283', 1153642749, 'a:22:{s:5:\"query\";s:5:\"نعتذر\";s:10:\"searchuser\";s:0:\"\";s:9:\"exactname\";i:0;s:11:\"starteronly\";i:0;s:11:\"forumchoice\";a:0:{}s:11:\"childforums\";i:0;s:9:\"titleonly\";i:0;s:9:\"showposts\";i:0;s:10:\"searchdate\";s:0:\"\";s:11:\"beforeafter\";s:0:\"\";s:6:\"sortby\";s:0:\"\";s:9:\"sortorder\";s:0:\"\";s:9:\"replyless\";i:0;s:10:\"replylimit\";i:0;s:12:\"searchthread\";i:0;s:14:\"searchthreadid\";i:0;s:9:\"saveprefs\";i:0;s:11:\"quicksearch\";i:1;s:10:\"searchtype\";i:1;s:7:\"exclude\";s:0:\"\";s:7:\"nocache\";i:0;s:4:\"ajax\";i:0;}', 'a:6:{s:5:\"words\";a:1:{i:0;s:5:\"نعتذر\";}s:9:\"highlight\";a:1:{i:0;s:5:\"نعتذر\";}s:6:\"common\";a:0:{}s:5:\"users\";a:0:{}s:6:\"forums\";a:0:{}s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:0;s:6:\"action\";s:7:\"process\";}}', '5cfdb15e7410627daef3f9e845dfc1e5')
### SAVE ORDERED IDS TO SEARCH CACHE ###;

MySQL Error : Unknown column 'titleonly' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 03:19:09 AM
Script : http://www.nwras.net/vb/search.php?do=process
Referrer : http://www.nwras.net/vb/
IP Address : 212.35.89.74
Username : النورس الطائر
Classname : vb_database

Please help problem exists when I unloaded research agenda to mitigate the database

ThAnKs ALL ..

Best Regards ..
Nwras ..

[Kirk Y]

Well the SQL is trying to insert data into the col titleonly -- but for whatever reason it doesn't exist. Without a better explanation, that's all I can tell you.

[Nwras]

Hey ..

But what is the solution to think how I can rectify the problem ?

[Kirk Y]

I haven no idea -- because you haven't described your problem. At least, you haven't in a sense that I can understand. I realize that English is probably not your first language, but unless you can try and explain to me a little better what exactly the problem is, I can't help you.

[Nwras]

hey ...

the problem is ...

when i search for any words hi said for me


Database error in vBulletin 3.6.0 Release Candidate 2:

Invalid SQL:

REPLACE INTO search (userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash)
VALUES (2, 0 ,'212.35.89.74', 0, 'نعتذر', '', '', 'lastpost', 'DESC', 0.08813, 0, '3512,1735,1547,1304,922,283', 1153642749, 'a:22:{s:5:\"query\";s:5:\"نعتذر\";s:10:\"searchuser\";s:0:\"\";s:9:\"exactname\";i:0;s:11:\"starteronly\";i:0;s:11:\"forumchoice\";a:0:{}s:11:\"childforums\";i:0;s:9:\"titleonly\";i:0;s:9:\"showposts\";i:0;s:10:\"searchdate\";s:0:\"\";s:11:\"beforeafter\";s:0:\"\";s:6:\"sortby\";s:0:\"\";s:9:\"sortorder\";s:0:\"\";s:9:\"replyless\";i:0;s:10:\"replylimit\";i:0;s:12:\"searchthread\";i:0;s:14:\"searchthreadid\";i:0;s:9:\"saveprefs\";i:0;s:11:\"quicksearch\";i:1;s:10:\"searchtype\";i:1;s:7:\"exclude\";s:0:\"\";s:7:\"nocache\";i:0;s:4:\"ajax\";i:0;}', 'a:6:{s:5:\"words\";a:1:{i:0;s:5:\"نعتذر\";}s:9:\"highlight\";a:1:{i:0;s:5:\"نعتذر\";}s:6:\"common\";a:0:{}s:5:\"users\";a:0:{}s:6:\"forums\";a:0:{}s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:0;s:6:\"action\";s:7:\"process\";}}', '5cfdb15e7410627daef3f9e845dfc1e5')
### SAVE ORDERED IDS TO SEARCH CACHE ###;

MySQL Error : Unknown column 'titleonly' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 03:19:09 AM
Script : http://www.nwras.net/vb/search.php?do=process
Referrer : http://www.nwras.net/vb/
IP Address : 212.35.89.74
Username : النورس الطائر
Classname : vb_database

[Kirk Y]

Hmm... well, I'm afraid I don't know. You're missing your titeonly col. in your search table. You could try adding it in again through phpMyAdmin, but I don't know if that would help or just make things worse.

Did you install any modifications before this error started appearing?