[RESOLVED] "View posts since last visit" error

Support for IntegraMOD 140

Moderator: Integra Moderator

[RESOLVED] "View posts since last visit" error

PostAuthor: BMD » Thu Sep 14, 2006 5:41 am

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.
Last edited by BMD on Thu Sep 14, 2006 5:59 am, edited 1 time in total.

BMD
Members
Members
 
Posts: 84
Likes: 0 post
Liked in: 0 post
Joined: Thu Aug 24, 2006 5:12 am
Cash on hand: 0.00

Re: "View posts since last visit" error

PostAuthor: BMD » Thu Sep 14, 2006 5:54 am

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.
Last edited by BMD on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

BMD
Members
Members
 
Posts: 84
Likes: 0 post
Liked in: 0 post
Joined: Thu Aug 24, 2006 5:12 am
Cash on hand: 0.00


Return to IntegraMOD 140

Who is online

Registered users: App360MonitorBot, Bing [Bot], Google [Bot]