View Posts Since Last Visit Problem

Posted: Mon Apr 07, 2008 6:16 pm

Users click on any of the three links at the top of the forum to view posts since last vist - View your posts - View unanswered posts 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 nuke_bbsearch_results WHERE search_time < 1207607241

Line : 669
File : search.php

How do I fix this?

Thanks, Jay

Posted: Mon Apr 07, 2008 7:15 pm

Fixed it !! Smile

The search_time field was missing from nuke_bbsearch_results. So what I did was exported the nuke_bbsearch_results table from another of my installations and then did a sql import for "structure" only. Worked like a charm, no more DEBUG errors. Probably could have used the ALTER method but I was more comfortable with the long way.

Cheers, Jay

Posted: Tue Apr 08, 2008 2:07 am

I just checked our files and that field is present in both 2.20.00 and 2.20.01
Was this database from a clean install, if so I need to see if I can reproduce the problem.

Posted: Tue Apr 08, 2008 4:24 am

Actually not from a clean install but rather a "borrowed" installation so to speak from a running test domain. So no telling how it happened as I was doing an awful lot of modifications, replacing tables, etc. to make this a production DB which it now is and running quite well.

I wouldn't concern yourself with hunting down a bug in light of the above explanation.

Cheers, Jay

Posted: Tue Apr 08, 2008 5:46 am

OK thanks for letting me know Smile