Announcement

Collapse
No announcement yet.

Cant get search working - DB error

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

  • aceofspades
    replied
    Worked perfectly, thank you.

    Leave a comment:


  • Steve Machol
    replied
    Try adding that field with this query:

    ALTER TABLE search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1';

    Leave a comment:


  • aceofspades
    started a topic Cant get search working - DB error

    Cant get search working - DB error

    Hi,

    I fixed one database error with your help, now I have one final one I need help with.
    Database error in vBulletin 3.6.2:

    Invalid SQL:

    SELECT * FROM search AS search
    WHERE searchhash = '65d871b7f803198613f55ec884d81e6e'
    AND userid = 1
    AND completed = 1;

    MySQL Error : Unknown column 'completed' in 'where clause'
    Error Number : 1054
    Date : Monday, July 13th 2009 @ 08:42:50 PM
    Script : http://xxx/forums/search.php?do=process
    Referrer : http://xxx/forums/search.php
    IP Address : xxx
    Username : xxx
    Classname : vB_Database
    Can anyone help me to understand why this is happening? I was able to fix the last database error by running a query found on this forum that created a missing table. Can i do the same with this one?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X