Page 1 of 1

problem with search function

Posted: Mon Jun 12, 2006 8:24 pm
by talltim
I seem to get an error when i try to search

Code: Select all

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1054 Unknown column 'search_time' in 'where clause'

DELETE FROM phpbb_search_results WHERE search_time < 1150136555

Line : 667
File : search.php 
  
It seems to happen for any search term and also if I narrow the searched forums down
You may be already aware of this.

Tim

Posted: Mon Jun 12, 2006 8:43 pm
by richard
Thanks - I'll investigate.

There's another update due to be applied to the forum software. Unfortunately every time there's a new update, it becomes more likely that there'll be a problem.

Richard

Posted: Mon Jun 12, 2006 9:10 pm
by richard
Tim: I think I have the problem fixed. Let me know if you have any further problems!

(the last set of patches updated the forum code & pages, but failed to apply the relevant patches to the underlying database)

Actually, while I have everything 'open' (in a heart surgery kind of way), I'm about to apply the next set of patches...


Richard

Posted: Mon Jun 12, 2006 9:39 pm
by richard
I've added the latest set of phpBB patches. Let me know if you have any problems.


Richard

Posted: Tue Jun 13, 2006 2:52 pm
by talltim
Thanks, the search works OK for me now

tim