1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

I need help with database of my forum! vBulletin 3.6.4

Discussion in 'MySQL' started by Loonm, Jul 18, 2007.

  1. #1
    I dontknow what kin of problem is this, im total dummie in this whole database error and stuff.
    But please can anyone help me. I have this error message whem I'm and anybody else trying to search on my forum:
    
    Database error in vBulletin 3.6.4:
    
    Invalid SQL:
    
    					SELECT * FROM search AS search
    					WHERE searchhash = 'f811323ed990aaf7fcfd2d0488a98e53'
    						AND userid = 1
    						AND completed = 1;
    
    MySQL Error  : Unknown column 'completed' in 'where clause'
    Error Number : 1054
    Date         : Thursday, July 19th 2007 @ 01:11:04 AM
    Script       : http://onlinemovieforum.com/search.php?do=process
    Referrer     : http://onlinemovieforum.com/index.php
    IP Address   : 212.7.31.96
    Username     : Loonm
    Classname    : vB_Database
    
    Code (markup):
    or check by yourself, here is the link : http://onlinemovieforum.com
    try search enything.
    Thanks !!!
     
    Loonm, Jul 18, 2007 IP
  2. kcammandc

    kcammandc Peon

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Have you fixed the problem? i went to the site and all seemed to working
     
    kcammandc, Jul 21, 2007 IP
  3. Loonm

    Loonm Peon

    Messages:
    744
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #3
    No i haven't, somebody says that quick search dont work, but for me any search is unavaliable.
     
    Loonm, Jul 22, 2007 IP
  4. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Check with vbulletin. It may need to be upgraded.
    I heard there was an issue with v3.6
    Current version is 3.6.7 PL1
     
    cyanide, Jul 23, 2007 IP
  5. Loonm

    Loonm Peon

    Messages:
    744
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I dont think there is alot of forums that are 3.6.4.
    Could this problem be caused by bad hosting (old mysql version or something i dont know) ?
     
    Loonm, Jul 24, 2007 IP
  6. Cardiff_88

    Cardiff_88 Guest

    Messages:
    496
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Ok to me it looks like the SQL is either older or newer than the script files. Have you tried updating recently?
     
    Cardiff_88, Jul 24, 2007 IP
  7. Demon fox

    Demon fox Active Member

    Messages:
    703
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    78
    #7
    try going to admincp->maintenance->repair/optimize tables and select all then click run.

    If that doesnt help then when you run the repair it should tell you after if you have any older script files.
     
    Demon fox, Jul 25, 2007 IP
    Loonm likes this.
  8. Loonm

    Loonm Peon

    Messages:
    744
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #8
    thanks demon fox!
     
    Loonm, Jan 3, 2008 IP
  9. Demon fox

    Demon fox Active Member

    Messages:
    703
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    78
    #9
    I take it, you fixed it
     
    Demon fox, Jan 3, 2008 IP
  10. Amilo

    Amilo Peon

    Messages:
    624
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Fox you beat me to it.

    Thats how I fix the problem,works everytime.

    Also rebuild the search index.
     
    Amilo, Jan 4, 2008 IP