View unanswered posts error

New Member Joined: Jul 17, 2006 Posts: 9

I am not sure if this is the right place to ask. I have searched and will continue to do so but I have not found the answer yet . . .

when in the forums if a user clicks"
view unanswered posts
view posts since your last visit
or view your posts
they 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 < 1153630169

Line : 668
File : search.php

I am assuming that this is refering to the search.php file located in the forums module.

here is my code from lines 661 to 675

Code:

      //


      // Delete old data from the search result table


      //


      $sql = 'DELETE FROM ' . SEARCH_TABLE . '


         WHERE search_time < ' . ($current_time - (int) $board_config['session_length']);


            if ( !$result = $db->sql_query($sql) )


            {


               message_die(GENERAL_ERROR, 'Could not delete old search id sessions', '', __LINE__, __FILE__, $sql);


            }





      //


      // Store new result data


      //


      $search_results = implode(', ', $search_ids);


      $per_page = ( $show_results == 'posts' ) ? $board_config['posts_per_page'] : $board_config['topics_per_page'];

can anyone direct me on finding out how to fix this?

Posted: Sun Jul 23, 2006 4:59 am

Pls post the table structure for nuke_bbsearch_results
And let us know what version of nuke your running and what version of phpbb.

The error is basically saying there is no field for search_time and therfore it cannot run the sql properly, The file is fine.

Posted: Sun Jul 23, 2006 10:43 am

Code:

Field                  Type            Null        Default


search_id       int(11)                No     0      


session_id       varchar(32)     No           


search_array     text               No           








 Indexes:


Keyname    Type              Cardinality       Field


PRIMARY          PRIMARY           2                  search_id


session_id    INDEX               2                     session_id








 Space usage:


Type    Usage


Data    1,948    Bytes


Index    3,072    Bytes


Total    5,020    Bytes


         Row Statistics:


Statements           Value


Format                     dynamic


Rows                      2


Row length ø           974


Row size  ø            2,510 Bytes


Creation             Jul 02, 2006 at 11:19 PM


Last update            Jul 20, 2006 at 11:36 AM


Last check            Jul 20, 2006 at 11:59 PM

I am running raven7.6 I believe the forums phpbb version is2.0.15 (Is it important for me to upgrade this to 2.0.21?)

Anywasy my problem with the veiw topics appeared after I downgraded from 7.8 to 7.6. Everything else works fine.

I am not sure if what I gave you from nuke_bbsearch_results for the structure is what you asked for, i went into phpmyadmin found nuke_bbsearch_results and clicked the structure tab and thats what came up.

Thank you for your time.

Posted: Sun Jul 23, 2006 12:40 pm

I'm sure 'D' will check your table structure and confirm that it is missing but I just wanted to say DO NOT upgrade the phpbb forum to 2.0.21 - there are some unresolved issues with it.

Posted: Sun Jul 23, 2006 1:54 pm

cash contact me via yahoo or msn and send me the cpanel username pass and well get to the bottom of this (no worries I have no ill will towards someone elses hard work, just want to help).

Posted: Sun Jul 23, 2006 8:59 pm

if you could pm me your contact info I would be more than happy to get ahold of you and will be very glad for the help.

-Thanks

Posted: Mon Jul 24, 2006 6:54 pm

In my profile is a contact for msn and yahoo.

Hangin' Around Joined: Dec 06, 2004 Posts: 46

Since I have exactly the same error, I was wondering if you guys finally found a solution to this error, thanks in advance.

Regards,

Eduardo.

Posted: Sat Aug 12, 2006 3:19 pm

Using phpMyAdmin (or equivalent host provided tool), add a field to this table:

search_time
int(11)
Null = no
Default = 0 (zero)

You somehow missed an upgrade of BBtoNuke I believe... I did too...

Posted: Sat Aug 12, 2006 4:03 pm

Excellent! I had that bug for some time, thank you very much Montego :clap:

Just to clarify, the table is "bbsearch_results" and the missing field was "search_time".

Best regards,

Eduardo.

Posted: Mon Aug 14, 2006 6:18 am

I am sure you meant "nuke_bbsearch_results"... Wink

Posted: Mon Aug 14, 2006 11:57 am

er... but of course! hehehe regards! Smile

Posted: Thu Aug 24, 2006 11:51 am

Great work !

even i was having this problem !

glad i found the way to fix it up !

thnx guys !

Worker Joined: Jun 01, 2005 Posts: 178

montego wrote:

Using phpMyAdmin (or equivalent host provided tool), add a field to this table:

search_time
int(11)
Null = no
Default = 0 (zero)

You somehow missed an upgrade of BBtoNuke I believe... I did too...

You Are God!

Thx man......been pulling my hair out for the last month and a half.

Posted: Tue Aug 29, 2006 10:08 pm

in my case, this corrected only view unanswered posts.

so, view posts since your last visit is still giving the same error !

Posted: Tue Aug 29, 2006 10:39 pm

s60addict, are you sure it is the exact same error? Humor me please and just post the complete error text here? Thx a bunch.

Posted: Tue Aug 29, 2006 10:42 pm

Well, before i added this field to this table, i was getting the same error:

search_time
int(11)
Null = no
Default = 0 (zero)

After i added it, everything worked fine except for view posts since last visit

Now when i click on it, it gives an error message:

"Information
No topics or posts met your search criteria"