1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Trying To Search

Discussion in 'MySQL' started by craig2k7, Apr 13, 2007.

  1. craig2k7

    craig2k7 New Member

    Joined:
    Apr 13, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    ok on my Vbulletin forums ( version 3.6.4) everytime i try to search i get the following error:

    Database error in vBulletin 3.6.4:

    Code:
    Invalid SQL:
    
    					SELECT * FROM phpbb_search AS search
    					WHERE searchhash = '38ba5f969be6d73b59fcd65974f1ab5b'
    						AND userid = 22
    						AND completed = 1;
    
    MySQL Error  : Unknown column 'completed' in 'where clause'
    Error Number : 1054
    Date         : Friday, April 13th 2007 @ 06:36:06 PM
    Script       : http://www.****.com/forums/search.php?do=process
    Referrer     : http://www.****.com/forums/index.php
    IP Address   : *******
    Username     : *****
    Classname    : vb_database
    

    any1 know a fix? or how i can fix this?
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    Do you have any mods / hacks installed.
     
  3. craig2k7

    craig2k7 New Member

    Joined:
    Apr 13, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    a do now... but when first installed board a didnt and it was the same
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    Run the following query.
    Code:
    ALTER TABLE vbsearch ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';
    There was an issue with the vB 3.6 I remember for an upgrade / import which I came to know when doing the cfanatic.com site.
     
  5. craig2k7

    craig2k7 New Member

    Joined:
    Apr 13, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    answer from queery

    An error occurred while attempting to execute your query. The following information was returned.
    error number: 1146
    error desc: Table 'web82-honcho.vbsearch' doesn't exist
     
  6. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    This table should exist. As you have a prefix use the following. phpbb_search as table name.
    Code:
    ALTER TABLE <vbsearch TABLENAME = phpbb_search> ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';
     
  7. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    I have no idea what is your table name but I am assuming it should be phpbb_search and so if you read the post what to execute you will see I have mentioned what to be substituted as table name.

    Now try this
    Code:
    ALTER TABLE phpbb_search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';
     

Share This Page