Announcement

Collapse
No announcement yet.

Table doesn't exist after upgrade to 4.0.2 PL4

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

  • anupam_luv
    replied
    Im also gettin this error... can u tell me which addon are u talkin about .... Is it post thanks addon?

    Leave a comment:


  • Gorf
    replied
    oh, wait... I see where this is coming from. It's from an add-on. Ok, please disregard.

    Leave a comment:


  • Gorf
    started a topic [Forum] Table doesn't exist after upgrade to 4.0.2 PL4

    Table doesn't exist after upgrade to 4.0.2 PL4

    After upgrading to 4.0 I now get these errors thrown when searching:

    Code:
    Database error in vBulletin 4.0.2:
    
    Invalid SQL:
    
                            REPLACE INTO vb_search (userid, ipaddress,  personal, searchuser, forumchoice, sortby, sortorder, searchtime,  showposts, orderedids, dateline, displayterms, searchhash)
    
                            VALUES (0, '67.195.115.245', 1,  'tarotwolf', '', 'post.dateline', 'DESC', 0.00205, 1,  '77182,77104,77068,77054,77045,76799,76617,76554,66247',  1270091195, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:329;s:9:\"tarotwolf\";}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\";}}',  '1e24748db2d236fb4fdde0f15cb14203');
    
    MySQL Error   : Table 'pnwhs_forums.vb_search' doesn't exist
    Error Number  : 1146
    
    Request Date  : Wednesday, March 31st 2010 @ 08:06:35 PM
    Error Date    : Wednesday, March 31st 2010 @ 08:06:35 PM
    Script        : [URL]http://forums.pnwhs.org/post_thanks.php?do=findthanks_user_gave&u=329[/URL]
    Sure enough if I go look, the vb_search table doesn't exist. Per the suggestions on first login to the Admin CP, I rebuilt the Search Index. I'm not really sure what's going on. Any thoughts?

    Server Type Linux
    Web Server Apache v2.2.3
    PHP 5.3.1
    PHP Max Post Size 8.00 MB
    PHP Maximum Upload Size 8.00 MB
    PHP Memory Limit 64.00 MB
    MySQL Version 5.1.41
    MySQL Packet Size 1.00 MB

Related Topics

Collapse

Working...
X