Page 5 of 19

Posted: Fri Dec 02, 2005 11:47 pm
by Galixte de EzCom
chatasos wrote: ....

[url=http:///www.psclub.gr/chatasos/rebuild_search/rebuild_search_2.2.1b.zip]rebuild_search_2.2.1b.zip[/url]

To update from 2.2.1a just overwrite file admin/admin_rebuild_search.php.


Hi,

just a wrong link ;)

rebuild_search_2.2.1b.zip.

@+.

Posted: Sun Dec 04, 2005 11:17 am
by ycl6
MOD Updated to version 2.2.1b
See first post for Download Link

Re: Blank Page

Posted: Tue Dec 06, 2005 5:20 pm
by TheSeeKerUK
chatasos wrote: HI TheSeeKerUK,

Please make sure you have followed exactly the instructions as they are written. Also all the template changes that refer to subSilver must be done on all your installed templates too.


Chatasos,

Thanks for that. I checked and rechecked the installation and its not that. However, I've since narrowed it down to something it doesn't like about the template. Once I've cracked it I'll let you know.

Regards

Posted: Wed Dec 07, 2005 5:33 pm
by egranto
i don`t know what`s wrong here

but i install this mod i do it step by step but i`m getting this error

i don`t know what can be im using 2.18 version in nuke and i really need this mod

Code: Select all

Could not obtain rebuild details

DEBUG MODE

SQL Error : 1146 Table 'crdance2006data.search_rebuild' doesn't exist

SELECT * FROM search_rebuild ORDER BY rebuild_session_id DESC LIMIT 1

Line : 239
File : functions_admin_rebuild_search.php
in nuke my folder looks like this
db (forum)
includes(forum)
modules
:arrow: forum(phpbb home)

my common say something like that

Code: Select all

if (defined('FORUM_ADMIN')) {
    include("../../../db/db.php");
    include("../../../includes/constants.php");
    include("../../../includes/template.php");
    include("../../../includes/sessions.php");
    include("../../../includes/auth.php");
    include("../../../includes/functions.php");
} else {
    include("includes/constants.php");
    include("includes/template.php");
    include("includes/sessions.php");
    include("includes/auth.php");
    include("includes/functions.php");
    include("db/db.php");
}
Plz help me i really need this mods

what a need to change to works

even i have 2 tables

nuke_bbsearch_rebuild
and
nuke_search_rebuild

Code: Select all

$dbhost = "localhost";
$dbuname = "root";
$dbpass = "";
$dbname = "crdance2006data";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";

Removed BEGIN and END

Posted: Thu Dec 08, 2005 12:05 pm
by TheSeeKerUK
With reference to my blank screen problem, got the mod to work by removing the BEGIN/END pairs from rebuild_search.tpl

The screen is displayed now, but shows some corruption (spurious characters either side on L_ information), but the mod works and thats what counts.

I'll post again if I ever find out what causing the screen corruption.

Thanks again

Posted: Fri Dec 09, 2005 4:02 pm
by chatasos
egranto wrote: i don`t know what`s wrong here

but i install this mod i do it step by step but i`m getting this error

i don`t know what can be im using 2.18 version in nuke and i really need this mod

Code: Select all

Could not obtain rebuild details

DEBUG MODE

SQL Error : 1146 Table 'crdance2006data.search_rebuild' doesn't exist

SELECT * FROM search_rebuild ORDER BY rebuild_session_id DESC LIMIT 1

Line : 239
File : functions_admin_rebuild_search.php
in nuke my folder looks like this
db (forum)
includes(forum)
modules
:arrow: forum(phpbb home)

my common say something like that

Code: Select all

if (defined('FORUM_ADMIN')) {
    include("../../../db/db.php");
    include("../../../includes/constants.php");
    include("../../../includes/template.php");
    include("../../../includes/sessions.php");
    include("../../../includes/auth.php");
    include("../../../includes/functions.php");
} else {
    include("includes/constants.php");
    include("includes/template.php");
    include("includes/sessions.php");
    include("includes/auth.php");
    include("includes/functions.php");
    include("db/db.php");
}
Plz help me i really need this mods

what a need to change to works

even i have 2 tables

nuke_bbsearch_rebuild
and
nuke_search_rebuild

Code: Select all

$dbhost = "localhost";
$dbuname = "root";
$dbpass = "";
$dbname = "crdance2006data";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";


First of all, i'd like to make clear that this mod has only be tested in pure phpbb forums. Installing it in other forum variations, means you'll have to change some things.

If you look at the install instructions, you'll see:

Code: Select all

CREATE TABLE `phpbb_search_rebuild` (
  `rebuild_session_id` mediumint(8) unsigned NOT NULL auto_increment,
  `start_post_id` mediumint(8) unsigned NOT NULL default '0',
  `end_post_id` mediumint(8) unsigned NOT NULL default '0',
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `last_cycle_time` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_posts` mediumint(8) unsigned NOT NULL default '0',
  `session_cycles` mediumint(8) unsigned NOT NULL default '0',
  `search_size` int(10) unsigned NOT NULL default '0',
  `rebuild_session_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`rebuild_session_id`),
  KEY `end_post_id` (`end_post_id`)
);
You say you have created "nuke_bbsearch_rebuild" & "nuke_search_rebuild" tables, but if you look at the db error you get, you'll see that mod asks for "search_rebuild" table.

Maybe you have to change the following line in the admin/admin_rebuild_search.php file and use the nuke table prefix instead of "$table_prefix":

Code: Select all

define('SEARCH_REBUILD_TABLE', $table_prefix.'search_rebuild');

Posted: Sat Dec 10, 2005 7:48 pm
by egranto
thx works like that

Code: Select all

CREATE TABLE `search_rebuild` (
  `rebuild_session_id` mediumint(8) unsigned NOT NULL auto_increment,
  `start_post_id` mediumint(8) unsigned NOT NULL default '0',
  `end_post_id` mediumint(8) unsigned NOT NULL default '0',
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `last_cycle_time` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_posts` mediumint(8) unsigned NOT NULL default '0',
  `session_cycles` mediumint(8) unsigned NOT NULL default '0',
  `search_size` int(10) unsigned NOT NULL default '0',
  `rebuild_session_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`rebuild_session_id`),
  KEY `end_post_id` (`end_post_id`)
); 
works with this table

and another change in case somebody else need this in phpbb on nuke

change to this

Code: Select all

//
// Let's set the root dir for phpBB
//
$no_page_header = true;
$phpbb_root_path = "../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
require($phpbb_root_path . '../../includes/functions_search.'.$phpEx);
require($phpbb_root_path . '../../includes/functions_admin_rebuild_search.'.$phpEx);
on admin_rebuild_search.php


thanks for the help chatasos :wink:

Posted: Sat Dec 17, 2005 10:41 pm
by agent00shoe
Awesome mod and very nice GUI. :D

Posted: Sun Dec 18, 2005 3:19 am
by agent00shoe
BTW, I used the DELETE option and ran it without disabling the board and it went smoothly. Shaved a little over 1.5 million rows from the search tables.

Posted: Mon Dec 19, 2005 9:20 am
by Helio-Yago
Just finished rebuilding my Search engine with this mod. Excellent !!! :wink:

I user CH + other MODs and no problem at all. I have more than 766000 posts and around 100 users inside my forum at any time... (from 60 to 150 users on line all the day). I can't dissable the board, so the rebuild was done with the forum active.

520,645 words and 15,535,374 matches. It tooks aroud 20 days and I had to reload process for 86 times. I don't know why but after 2-3 hours working it looses conextion. I have 572 entries in my search_stopwords.txt file, and before rebuilding my matches table was around 30 millions records. Now I've only half records, and my search engine runs fine...

Any way i find this mod the best solution for large boards like mine: http://foros.guitarramania.com/index.php

Thanks again for your great Job chatasos !! :wink:

Posted: Sat Dec 24, 2005 2:04 am
by Marmotte
Hi !

I just tried to install the v2,2,1b of this mod, and the CREATE TABLE query did not want to execute with an error on the default value of the key.

it seems mySQL v4.1.12 does not like DEFAULT VALUE '0' on a AUTO_INCREMENT column.

removing the "DEFAULT VALUE '0'" seems to work allright.

Posted: Sat Dec 24, 2005 3:20 am
by chatasos
Marmotte wrote: Hi !

I just tried to install the v2,2,1b of this mod, and the CREATE TABLE query did not want to execute with an error on the default value of the key.

it seems mySQL v4.1.12 does not like DEFAULT VALUE '0' on a AUTO_INCREMENT column.

removing the "DEFAULT VALUE '0'" seems to work allright.


hi Marmotte,

There is no DEFAULT VALUE '0' being used on the auto-increment field which is `rebuild_session_id`. Are you sure you used the following sql query?

Code: Select all

CREATE TABLE `phpbb_search_rebuild` (
  `rebuild_session_id` mediumint(8) unsigned NOT NULL auto_increment,
  `start_post_id` mediumint(8) unsigned NOT NULL default '0',
  `end_post_id` mediumint(8) unsigned NOT NULL default '0',
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `last_cycle_time` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_posts` mediumint(8) unsigned NOT NULL default '0',
  `session_cycles` mediumint(8) unsigned NOT NULL default '0',
  `search_size` int(10) unsigned NOT NULL default '0',
  `rebuild_session_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`rebuild_session_id`),
  KEY `end_post_id` (`end_post_id`)
);


Posted: Tue Jan 03, 2006 3:08 pm
by PamRamRadio
Outstanding! This worked perfectly. Thank you.

Posted: Tue Jan 03, 2006 8:00 pm
by Marmotte
chatasos wrote: hi Marmotte,

There is no DEFAULT VALUE '0' being used on the auto-increment field which is `rebuild_session_id`. Are you sure you used the following sql query?

Code: Select all

CREATE TABLE `phpbb_search_rebuild` (
  `rebuild_session_id` mediumint(8) unsigned NOT NULL auto_increment,
  `start_post_id` mediumint(8) unsigned NOT NULL default '0',
  `end_post_id` mediumint(8) unsigned NOT NULL default '0',
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `last_cycle_time` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_posts` mediumint(8) unsigned NOT NULL default '0',
  `session_cycles` mediumint(8) unsigned NOT NULL default '0',
  `search_size` int(10) unsigned NOT NULL default '0',
  `rebuild_session_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`rebuild_session_id`),
  KEY `end_post_id` (`end_post_id`)
);

errr... you're right, I can't find it now... I was sure I had found it in the query that produced an error.
I think I'll stop trying to install MODs so late at night you could call it early morning ;)

Posted: Wed Jan 04, 2006 3:38 pm
by Snapdragon
chatasos wrote:
Snapdragon wrote: Absolutely correct. It recognized the board was disabled, however, it still turned it back on when I cancelled the operation, twice.

Yep, you're right here. :wink:
If you cancel the process, the board gets enabled. It seems i forgot to add something...

Please try the following version:
[url=http:///www.psclub.gr/chatasos/rebuild_search/rebuild_search_2.2.1b.zip]rebuild_search_2.2.1b.zip[/url]

To update from 2.2.1a just overwrite file admin/admin_rebuild_search.php.


Sounds good. Now I see someone running an almost equally sized forum to ours sucessfully ran the rebuild while NOT being disabled... what are (if any) the side effects to having posters continue to post and edit while it's running? Is there a risk of anything going wrong? Should I post a notice not to DELETE any posts during the run?