Announcement

Collapse
No announcement yet.

Quick help needed...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Quick help needed...

    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 :










  • #2
    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 :

    Comment


    • #3
      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...

      Comment


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

        Comment


        • #5
          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.

          Comment


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

            Comment


            • #7
              Yes, do a simple rebuild of the search index.
              Gentoo Geek

              Comment

              Related Topics

              Collapse

              Working...
              X