problem with search function

This forum is for suggestions and discussion about this site. What would you like to see?

Moderators: 52D, Tom F, Rlangham, Atlantic 3279, Blink Bonny, Saint Johnstoun, richard

Post Reply
talltim
GNR J52 0-6-0T
Posts: 23
Joined: Sun Jun 11, 2006 11:55 am
Location: Chesterfield
Contact:

problem with search function

Post 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
User avatar
richard
LNER A4 4-6-2 'Streak'
Posts: 3385
Joined: Thu Sep 01, 2005 5:11 pm
Location: Wichita Falls, Texas
Contact:

Post 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
Richard Marsden
LNER Encyclopedia
User avatar
richard
LNER A4 4-6-2 'Streak'
Posts: 3385
Joined: Thu Sep 01, 2005 5:11 pm
Location: Wichita Falls, Texas
Contact:

Post 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
Richard Marsden
LNER Encyclopedia
User avatar
richard
LNER A4 4-6-2 'Streak'
Posts: 3385
Joined: Thu Sep 01, 2005 5:11 pm
Location: Wichita Falls, Texas
Contact:

Post by richard »

I've added the latest set of phpBB patches. Let me know if you have any problems.


Richard
Richard Marsden
LNER Encyclopedia
talltim
GNR J52 0-6-0T
Posts: 23
Joined: Sun Jun 11, 2006 11:55 am
Location: Chesterfield
Contact:

Post by talltim »

Thanks, the search works OK for me now

tim
Post Reply