MySQL error after upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Anonymous999
    Senior Member
    • Aug 2005
    • 207
    • 4.1.x

    [Forum] MySQL error after upgrade

    Got some database errors after an upgrade from 3.8.6 to 4.0.7

    Code:
    Database error in vBulletin 4.0.7:
     
    Invalid SQL:
     
    REPLACE INTO vbsearch (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
    VALUES (0, 'xx.xxx.xx.xxx', 1, 'junior', '', 'post.dateline', 'DESC', 0.01297, 1, '182193,182192,181017', 1295908090, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:13090;s:11:\"junior\";}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\";}}', '694148d32888dbed5de7e12c6ada3856');
     
    MySQL Error : Table 'prefix_my web site.vbsearch' doesn't exist
    Error Number : 1146
    Request Date : Monday, January 24th 
    Error Date : Monday, January 24th
    Script : [URL="http://www.mywebsitedahdahdah.co.uk/post_thanks.php?do=findthanks_user_gave&u=13090"][COLOR=#0068cf]http://www.my web site /post_thanks.php?do=findthanks_user_gave&u=1090[/COLOR][/URL]
    Referrer : 
    IP Address :
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    Last edited by Anonymous999; Fri 15 Apr '11, 10:57am.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    That error is from an add-on. You need to either remove that add-on or post for help with this over at www.vbulletin.org.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Anonymous999
      Senior Member
      • Aug 2005
      • 207
      • 4.1.x

      #3
      Thanks

      Comment

      • Kuya
        New Member
        • Aug 2010
        • 26
        • 4.1.x

        #4
        I had this same error trying to upgrade from 4.1.0 to 4.1.2 and to make it worse my SQL backup was corrupted, so I've lost a few days of posts and threads (and a couple of new users) after resetting my site to a previous full backup done by the host company

        Any idea what add on might do this?
        British Filipino

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          If you have the same error, then it too is from an add-on and the previous reply is applicable.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          Related Topics

          Collapse

          Working...