Page 1 of 1

[RESOLVED] "View posts since last visit" error

PostPosted: Thu Sep 14, 2006 5:41 am
Author: BMD
I just tried the "View posts since last visit" in my user block and get the following error...
Could not delete old search id sessions

DEBUG MODE

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

DELETE FROM "DB PREFIX"_search_results WHERE search_time < 1158233475

Line : 908
File : search.php


This is post hacked site and install from scratch with latest version of phpBB and IM 140 and added security patches.

NOTE: I redirected the new IM to the OLD database..... so far everything else seems ok.....

Any Ideas on this? Not a major thing...just an annoyance.


Thanks in advance for any assistance on this.

[UPDATED INFO]
I just checked my SQL database and the "DB PREFIX"_search_results table...
there is no column in the table for search_time....


I am assuming that's the problem..... I am going to rename that and make a copy of the table from the install created DB and rename that no see if it corrects the erroor.

Re: "View posts since last visit" error

PostPosted: Thu Sep 14, 2006 5:54 am
Author: BMD
This has been resolved.

I copied the back up table and renamed it to fit the DB propper and BINGO..... it's working fine now.