Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
dad7732
RavenNuke(tm) Development Team


Joined: Mar 18, 2007
Posts: 1242

PostPosted: Mon Apr 07, 2008 6:16 pm Reply with quote

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
 
View user's profile Send private message
dad7732
PostPosted: Mon Apr 07, 2008 7:15 pm Reply with quote

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
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Tue Apr 08, 2008 2:07 am Reply with quote

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.
 
View user's profile Send private message Send e-mail
dad7732
PostPosted: Tue Apr 08, 2008 4:24 am Reply with quote

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
 
Guardian2003
PostPosted: Tue Apr 08, 2008 5:46 am Reply with quote

OK thanks for letting me know Smile
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©