Quick help needed...

[coolbreeze86]

Database error in vBulletin 4.2.2:

Invalid SQL:

REPLACE INTO vb_searchlog
(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,resul ts)
VALUES
(0,'115.242.201.93','97f49c8ffce9219801e2c6c4cd38318b','groupdateline','desc',0,1385742016 ,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\ 0vB_Search_Criteria\0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0; s:27:\"\0vB_Search_Criteria\0filters\";a:2:{s:11:\"contenttype\";a:1:{s:2:\"eq\";a:1:{i:0; i:1;}}s:7:\"datecut\";a:1:{s:2:\"gt\";i:1385655616;}}s:24:\"\0vB_Search_Criteria\0sort\";a :2:{i:0;s:13:\"groupdateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i: 1;s:31:\"\0vB_Search_Criteria\0searchterms\";a:4:{s:10:\"searchdate\";i:1;s:13:\"contentty peid\";s:1:\"1\";s:11:\"search_type\";i:1;s:9:\"showposts\";i:0;}s:32:\"\0vB_Search_Criter ia\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Sear ch_Criteria\0display_strings\";a:2:{s:4:\"type\";s:11:\"Type: Posts\";s:7:\"newitem\";s:19:\"Posts From Last Day\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0high lights\";a:0:{}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\ 0errors\";a:0:{}s:11:\"search_type\";s:3:\"new\";}','');

MySQL Error : Failed to read auto-increment value from storage engine
Error Number : 1467
Request Date : Friday, November 29th 2013 @ 04:20:16 PM
Error Date : Friday, November 29th 2013 @ 04:20:16 PM
Script : http://www.xxxxx.com/forums/search.p...e=vBForum_Post
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :

[coolbreeze86]

And also this,

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vb_searchgroup (username, contenttypeid, groupid, userid, dateline)
VALUES ( '', 3, 185, 0, 1385742723 )
ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), groupid = VALUES(groupid), userid = VALUES(userid), dateline = VALUES(dateline);

MySQL Error : Failed to read auto-increment value from storage engine
Error Number : 1467
Request Date : Friday, November 29th 2013 @ 04:32:03 PM
Error Date : Friday, November 29th 2013 @ 04:32:04 PM
Script : http://www.xxxxx.com/forums/newreply...treply&t=62890
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

[coolbreeze86]

I tried to repair the tables but getting
SQL query: REPAIR TABLE `vb_searchlog`
Msg_text: The storage engine for the table doesn't support r...

[Zachery]

You need to get with your webhost, I've not see that error before.

[coolbreeze86]

It seems that the tables vb_searchcore, vb_searchcore_text and search log are reseted. I can't find members latests post and latest started threads. But the posts are viewable through members profile activity.

[coolbreeze86]

searching too not working. Pls help me how to make this correct is Rebuild Search Index gives solution? or any other alternative is there?

[snakes1100]

Yes, do a simple rebuild of the search index.