[2.0.21] Rebuild Search

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
58
81%
Very Good
10
14%
Good
3
4%
Fair
0
No votes
Poor
1
1%
 
Total votes: 72

chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos » Fri Jul 21, 2006 11:17 am

These are the changes from the previous version:

Code: Select all

##	2006-06-17 - Version 2.4.0
##	- Added Fast mode option
##	- Changed the board disabling function
##	- Various small fixes
##	- Updated instructions
In order to upgrade:

Code: Select all

##	- When upgrading from versions 2.1.x to 2.2.0 or later, you have to run the db command 
##	  "DROP table `phpbb_search_rebuild`" before proceeding with the install,
##	  because the mod's table has changed its structure.

##	- When upgrading from version 2.2.0 to a later version, you just have to copy (overwrite) 
##	  all the files to their appropriate directory. No changes have been made in the DB.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)

suff22886
Registered User
Posts: 10
Joined: Mon Dec 26, 2005 3:16 pm
Contact:

Post by suff22886 » Fri Jul 21, 2006 11:34 am

We have @set_time_limit(0); there. Exactly like it should be. Also we've updated mod ver to the latest. But it doesnt work (. Is there a way to fix it? Maybe it's just host problem?

chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos » Fri Jul 21, 2006 12:25 pm

Maybe you can try to replace

Code: Select all

@set_time_limit(0);
with

Code: Select all

if ( !ini_get('safe_mode') )
{
	@set_time_limit(0);
}
but that isn't the recommended way. I still wonder why this error appears to you.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)

suff22886
Registered User
Posts: 10
Joined: Mon Dec 26, 2005 3:16 pm
Contact:

Post by suff22886 » Fri Jul 21, 2006 12:58 pm

thnx very much

should we undo that replacing when search rebuilding will be done.

cputester
Registered User
Posts: 103
Joined: Fri May 12, 2006 8:23 pm

Post by cputester » Tue Jul 25, 2006 6:53 pm

I moved my old forum (2.0.19) to another host and I restored the db but when I am going to make a search this message appears:
Could not delete old search id sessions

DEBUG MODE

SQL Error : 1054 Unknown column 'search_time' in 'where clause'

DELETE FROM phpbb_search_results WHERE search_time < 1153838152

Line : 657
File : search.php


The forum is modified with the simple subforums mod.
I had emptied the search tables and I installed the rebulid search mod to rebuild the search tables witch I did succesully but still the same message. What is it???

Also I did this:
karlsemple wrote: This error is due to the restore replacing a later version of the database structure with an earlier one and is missing addtional tables or fields. Or not running the update_to_latest.php after an update.

The current version of your files is expecting this table/field.

0. If you don't have the full install file set for the version of your forum, download it again

1. upload the install directory from it to your forum.
2. Point your browser to http://{YOUR_FORUM}/{FORUM_ROOT}/install/update_to_latest.php. Change the labels inside the { and } markers to your values.
3. remove the install directory.


and I haven't noticed any difference at the database. When I did it a page appeared showing this:

Updating to latest stable release



Information
Database type :: mysql4
Previous version :: 2.0.21
Updated version :: 2.0.21

Updating database schema
Progress :: No updates required

Updating data
Progress :: No updates were required

Updating version and optimizing tables
Progress :: . . Done
Result :: No errors

Update completed
Please make sure you have updated your board files too, this file is only updating your database.

You should now visit the General Configuration settings page in the Administration Panel and check the General Configuration of the board. If you updated from versions prior to RC-3 you must update some entries. If you do not do this emails sent from the board will contain incorrect information. Don't forget to delete this file!

what should I do?

chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos » Wed Jul 26, 2006 7:38 pm

Table "phpbb_search_results" should have the following structure:

Code: Select all

CREATE TABLE `phpbb_search_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_array` text NOT NULL,
  `search_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) 
It seems your own is missing the search_time field. Something must have gotten wrong while updating your forum.

You can try to drop the table (see below) and create it from the beginning using the above structure.

Code: Select all

DROP TABLE IF EXISTS `phpbb_search_results`;

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)

cputester
Registered User
Posts: 103
Joined: Fri May 12, 2006 8:23 pm

Post by cputester » Wed Jul 26, 2006 9:28 pm

The time field exists. Also I did this: http://www.phpbb.com/phpBB/viewtopic.ph ... 11&start=0 and it's ok now.

chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos » Wed Jul 26, 2006 9:44 pm

Yep...the script you run created it :wink:

Code: Select all

...
$sql[] = "ALTER TABLE " . SEARCH_TABLE . " ADD COLUMN `search_time` int(11) NOT NULL default '0'"; 
...

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)

Josh18657
Registered User
Posts: 425
Joined: Wed Nov 30, 2005 9:55 pm
Contact:

Post by Josh18657 » Mon Jul 31, 2006 9:34 pm

Just wanted to say thank you for this great mod, worked perfectly for me after I got some search errors.

Thanks again
Josh

Eru2
Registered User
Posts: 1
Joined: Sun Aug 06, 2006 3:59 pm

Post by Eru2 » Sun Aug 06, 2006 4:21 pm

Hello chatasos i tried to contact you by mail but your mail server think that i am a spammer... 8)

Anyway, i paste here the mail:
In my mail i wrote: Hello, my name is Guillaume Antier (aka Eru).

I found your Rebuild Search mod.
It is very usefull and well done, so congratulations.

I like it so much that i made a french traduction of it.
It is my gift to thank your work.

Fell free to include the traduction into your package (or not ;) )
And if your add some features to your mod, fell free to ask me to translate :)

Again, thank you.


As there is no attach mod on this board i put the file on my personnal website: http://eru.jexiste.fr/divers/lang_admin ... earch.phps (please change the extension into .php after download ;) )

Best Regards.

pengunio
Registered User
Posts: 78
Joined: Wed Jun 21, 2006 8:24 pm

Post by pengunio » Tue Aug 29, 2006 3:03 am

works great, install with easy mod no problem and restores simply

SKLiF
Registered User
Posts: 37
Joined: Tue Feb 03, 2004 7:30 am

Post by SKLiF » Tue Sep 05, 2006 9:11 am

I have 2 problems :)

timeouts server errors time to time (i played with settings and results vary :) )

and also sql tells this

Code: Select all

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY word_id HAVING COUNT(word_id) = 1' at line 3 

EXPLAIN SELECT word_id FROM aerob_search_wordmatch WHERE word_id IN () GROUP BY word_id HAVING COUNT(word_id) = 1 

Line : 231 
File : class_db.php 
how bad it is? 'cause database is filling and everything works fine. How can i be shure that search will work when everything is finished? :) Script tells me that it will work for 7 more days :) :D

thank you!

mgutt
Registered User
Posts: 346
Joined: Tue Sep 21, 2004 2:54 pm
Location: Germany, Sankt Augustin
Contact:

Post by mgutt » Tue Sep 05, 2006 10:52 am

@ SKLiF

Categories Hierarchy 2.1.6 has included a search rebuild.

I had the same problem in the past:
http://ptifo.clanmckeen.com/viewtopic.php?p=18886#18886
Forums: Honda || phpBB Categories Hierarchy
Mods: Spamfilter against bot registrations || Seo Urls

SKLiF
Registered User
Posts: 37
Joined: Tue Feb 03, 2004 7:30 am

Post by SKLiF » Tue Sep 05, 2006 10:10 pm

CH?

you meen i have to install it? ;) 'cause i haven't it running

debdee_MI
Registered User
Posts: 30
Joined: Wed Jul 12, 2006 4:36 pm
Location: Michigan

Post by debdee_MI » Fri Sep 08, 2006 1:37 pm

I am using 2.0.21. I have moved my forum from one site to another. The search by keyword is not working. I have a little under 6,000 posts.

I have installed your mod and have run it numerous times. It keeps timing out, even when running 1 post per cycle. It will get about 1/3 done, after about 3 hours, and it will time out. I try to restart from where it stopped, and it will time out and not restart, even waiting hours after the timeout.

Any ideas?

Post Reply

Return to “[2.0.x] MOD Database Releases”