View unanswered posts error

cash7c3 · 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?

gregexp · 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.

cash7c3 · New Member Joined: Jul 17, 2006 Posts: 9

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.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4868

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.

gregexp · 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).

cash7c3 · New Member Joined: Jul 17, 2006 Posts: 9

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

gregexp · Posted: Mon Jul 24, 2006 6:54 pm

In my profile is a contact for msn and yahoo.

superflash · Hangin' Around Joined: Dec 06, 2004 Posts: 45

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.

montego · 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...

superflash · Hangin' Around Joined: Dec 06, 2004 Posts: 45

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.

montego · Posted: Mon Aug 14, 2006 6:18 am

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

superflash · Hangin' Around Joined: Dec 06, 2004 Posts: 45

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

s60addict · 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 !

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

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.

s60addict · 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 !

montego · 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.

s60addict · 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"